Rich_Lovina
Registered User.
- Local time
- Today, 22:16
- Joined
- Feb 27, 2002
- Messages
- 225
I'm still very new at macros, but here's the problem. I have created TOPUP table with no records, but with all fields matching the source data's table.
In Transfer Database for the destination name I have TOPUP, but the Macro creates a new table called TOPUP1, then for the 2nd transfer TOPUP11, then TOPUP2 through to TOPUP4. Why does it avoid my nicely created table?
Also, I then have queries to append all tables to TOPUP, but this query relies upon the newly created table, TOPUP2 to commence. The macro tells me it can't recognise this query, that the name is spelled wrongly, etc. Can this only work as a nested macro?
Any help very much appreciated.
In Transfer Database for the destination name I have TOPUP, but the Macro creates a new table called TOPUP1, then for the 2nd transfer TOPUP11, then TOPUP2 through to TOPUP4. Why does it avoid my nicely created table?
Also, I then have queries to append all tables to TOPUP, but this query relies upon the newly created table, TOPUP2 to commence. The macro tells me it can't recognise this query, that the name is spelled wrongly, etc. Can this only work as a nested macro?
Any help very much appreciated.