OldManRiver
Registered User.
- Local time
- Today, 09:02
- Joined
- Jan 29, 2009
- Messages
- 49
All,
Have working code at:
http://www.access-programmers.co.uk/forums/showthread.php?t=176485
which creates and opens a query. The original query was an append query and I need the same from this query or way to save into table "tblMODfnr".
All HOWTOs and helps I've read, do not show a way to do this and when I click "File" + "SaveAs" with the query open, table is not an option.
How do I get this done?
Do I need to change my SQL to "INSERT INTO" and then "DoCMD.RunSQL"?
Any help appreciated!
Thanks!
OMR
Have working code at:
http://www.access-programmers.co.uk/forums/showthread.php?t=176485
which creates and opens a query. The original query was an append query and I need the same from this query or way to save into table "tblMODfnr".
All HOWTOs and helps I've read, do not show a way to do this and when I click "File" + "SaveAs" with the query open, table is not an option.
How do I get this done?
Do I need to change my SQL to "INSERT INTO" and then "DoCMD.RunSQL"?
Any help appreciated!
Thanks!
OMR