A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

One form(as a template) to many tables with same fields



 
 
Thread Tools Display Modes
  #1  
Old September 8th, 2004, 05:41 AM
1 form for similar table
external usenet poster
 
Posts: n/a
Default One form(as a template) to many tables with same fields

i have to build a form which is built purposely for data entry. So i need the
form(masterpiece) to become a template for other tables which have the same
fields. For eg: i got tblWEEK01,tblWEEK02,tblWEEK03 all with the same fields.
In week01 i will enter data into tblWEEK01 using FORM(masterpiece) and in
week02 i will do the same thing to enter data into tblWEEK02 with the same
FORM(masterpiece)

So in other words, the FORM that i created become the template for all the
similar table, can i know how can i do it? i only manage to enter data into
tblWEEK01

Urgent, thanks for the help...

  #2  
Old September 8th, 2004, 06:05 AM
Larry Linson
external usenet poster
 
Posts: n/a
Default

Almost certainly, from your description, your database is unnormalized and
violates good relational database design practices -- immediately visible by
the fact that the table (names) themselves are part of the data. I'd suggest
you reconsider that table design, and replace all the separate tables with a
single one, with a data field that identifies the week. In the long run, it
will save you mental trauma and grief.

That said, if each of the tables has the same fields, you can set the
RecordSource of the Form in its Open event, or use the Filter argument of
the DoCmd.OpenForm statement to override it. That RecordSource will
determine where the form gets its data.

Larry Linson
Microsoft Access MVP




"1 form for similar table" 1 form for similar
wrote in message
...
i have to build a form which is built purposely for data entry. So i need

the
form(masterpiece) to become a template for other tables which have the

same
fields. For eg: i got tblWEEK01,tblWEEK02,tblWEEK03 all with the same

fields.
In week01 i will enter data into tblWEEK01 using FORM(masterpiece) and in
week02 i will do the same thing to enter data into tblWEEK02 with the same
FORM(masterpiece)

So in other words, the FORM that i created become the template for all the
similar table, can i know how can i do it? i only manage to enter data

into
tblWEEK01

Urgent, thanks for the help...



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
My tables lost their AutoNumber fields Bill Nicholson Database Design 2 July 2nd, 2004 02:20 AM
Mutliple Tables lookup? Westley Database Design 4 June 15th, 2004 01:07 AM
do i need six tables, or one? steve matco Running & Setting Up Queries 3 June 9th, 2004 04:48 PM


All times are GMT +1. The time now is 08:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.