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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access data Input
How do I input the same information into many records
-- JohnM Deepwater |
#2
|
|||
|
|||
Access data Input
More details please.
You could use the default value for controls in your form, you could use an update query, you could use an append query. Lots of options. Generally, you should not be entering the same information into many records. This can sometimes be accomplished with a properly designed relationship between two tables. For example, if you are entering a company name and address in every invoice record, then you have not designed your database properly. Please explain exactly what you are trying to accomplish. -- Rick B "JohnM" wrote in message ... How do I input the same information into many records -- JohnM Deepwater |
#3
|
|||
|
|||
Access data Input
I have a data base where information is constantly updating. ie A Po has
many records some are received, I need to enter the date for all items received. Some items maybe shipped, I have to put in the date shipped for all items -- JohnM Deepwater "Rick B" wrote: More details please. You could use the default value for controls in your form, you could use an update query, you could use an append query. Lots of options. Generally, you should not be entering the same information into many records. This can sometimes be accomplished with a properly designed relationship between two tables. For example, if you are entering a company name and address in every invoice record, then you have not designed your database properly. Please explain exactly what you are trying to accomplish. -- Rick B "JohnM" wrote in message ... How do I input the same information into many records -- JohnM Deepwater |
#4
|
|||
|
|||
Access data Input
It seems to me that each item on the PO could ship at a different time.
Same for receive. If that is not the case, then move those fields out of the PO detail table and put them as part of the PO summary table. Then it will only be one entry for the dates per PO, instead of one entry per line item on the PO. -- Rick B "JohnM" wrote in message ... I have a data base where information is constantly updating. ie A Po has many records some are received, I need to enter the date for all items received. Some items maybe shipped, I have to put in the date shipped for all items -- JohnM Deepwater "Rick B" wrote: More details please. You could use the default value for controls in your form, you could use an update query, you could use an append query. Lots of options. Generally, you should not be entering the same information into many records. This can sometimes be accomplished with a properly designed relationship between two tables. For example, if you are entering a company name and address in every invoice record, then you have not designed your database properly. Please explain exactly what you are trying to accomplish. -- Rick B "JohnM" wrote in message ... How do I input the same information into many records -- JohnM Deepwater |
#5
|
|||
|
|||
Access data Input
On Wed, 8 Feb 2006 05:55:43 -0800, "JohnM"
wrote: I have a data base where information is constantly updating. ie A Po has many records some are received, I need to enter the date for all items received. Some items maybe shipped, I have to put in the date shipped for all items Just to amplify Rick's suggestions, you can also consider running an Update query with criteria which identify the set of records which need to be affected. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Microsoft Office should use an advance data crosslinking model | m_jurrens | General Discussions | 0 | December 15th, 2005 07:33 AM |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
The "Right" web hosting for data access pages?? | Ron Ehrlich | General Discussion | 9 | May 6th, 2005 05:49 AM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |