Microsoft Access Help - GM Forum - Buick, Cadillac, Chev, Olds, GMC & Pontiac chat


Lounge For casual talk about things unrelated to General Motors. In other words, off-topic stuff. And anything else that does not fit Section Description.

Reply
 
 
 
Thread Tools Search this Thread
Old 12-12-2004, 04:06 PM   #1
Senior Member
True Car Nut
Thread Starter
 
Join Date: Feb 2004
Location: Pennsylvania
Posts: 5,177
Thanks: 0
Thanked 0 Times in 0 Posts
Twister97 is on a distinguished road
Default Microsoft Access Help

In Access (Office XP) I want to be able to have seperate tables with information which I will call tables, A, B, C, D. Then I will have a master table that combines all the records into one table called ALL. I can do this allright, but my main goal is to be able to enter a record into table A, then have that record show up in the ALL table automatically without having to copy and paste it. Is there any way I am able to do this? I thought relationships would be able to, but it didnt work or I did not do it right.
Twister97 is offline   Reply With Quote
Old 12-12-2004, 05:22 PM   #2
Senior Member
True Car Nut
 
Join Date: Feb 2004
Location: Western MA
Posts: 2,708
Thanks: 0
Thanked 1 Time in 1 Post
randman1 is on a distinguished road
Default

I've done similar things with macros. For instance, using the On Update event, you can have it copied to the All table automatically whenever a field is changed.

Typically though, the information only needs to be in one table. Through the relationships, the info can be manipulated to display on the forms and reports.
randman1 is offline   Reply With Quote
Old 12-13-2004, 03:36 AM   #3
Senior Member
True Car Nut
Thread Starter
 
Join Date: Feb 2004
Location: Pennsylvania
Posts: 5,177
Thanks: 0
Thanked 0 Times in 0 Posts
Twister97 is on a distinguished road
Default

I tried playing around with it, but still no luck. Im thinking about having just one master table, then having queries for each seperat categorie that i have my contacts in, which is seven categories. But im still unsure if it will let me input the info like i want it to. Im not to familiar with macros either, so that was a problem for me.
Twister97 is offline   Reply With Quote
Old 12-13-2004, 03:45 AM   #4
Senior Member
True Car Nut
Thread Starter
 
Join Date: Feb 2004
Location: Pennsylvania
Posts: 5,177
Thanks: 0
Thanked 0 Times in 0 Posts
Twister97 is on a distinguished road
Default

Got it, worked out fine. And using a Form is the easiest way and sorts and inputs everything for me into the tables and queries automatically, just as long as the group title is inputted, and the query is sorted by that field and that field only.
Twister97 is offline   Reply With Quote
 
 
Reply

Related Topics
Thread Thread Starter Forum Replies Last Post
Remote Keyless Access - I will have to engineer my own - need help PaulBennett Buick 8 12-22-2010 02:03 AM
need microsoft office.. can anyone help.? thanks 88bonnsse Lounge 22 01-30-2008 10:31 PM
Microsoft Word help tallbump Lounge 5 07-18-2007 02:52 PM
Microsoft Word HELP!!!!!!!!!!!!! bonnie94ssei Lounge 14 06-15-2005 12:15 PM


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 08:31 PM.


We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.