Rich_Lovina
Registered User.
- Local time
- Today, 13:10
- Joined
- Feb 27, 2002
- Messages
- 225
Okay...in the past I used a Macro for this action. Now I want to learn to do it in Code.
I've weekly data coming in...there are 25 tables in the Access db, I want to select 5 of the 25 same named tables each week; just the .mdb name changes. My queries are:
1. Where do I put the code? In a command button on my MainInputForm? or some other button on my main object screen?
2. How do I get a message to popup allowing me to change the pathname each week?
3. each of the 5 tables have varying fldnames which I append together (Can I code these append queries so they all go into the one table called TRANSMAST?)
Ive done my homework in the Forums searchengine, but nothing covers this exact situation.
Thanks in advance any guidance.
I've weekly data coming in...there are 25 tables in the Access db, I want to select 5 of the 25 same named tables each week; just the .mdb name changes. My queries are:
1. Where do I put the code? In a command button on my MainInputForm? or some other button on my main object screen?
2. How do I get a message to popup allowing me to change the pathname each week?
3. each of the 5 tables have varying fldnames which I append together (Can I code these append queries so they all go into the one table called TRANSMAST?)
Ive done my homework in the Forums searchengine, but nothing covers this exact situation.
Thanks in advance any guidance.