Save as Query menu command (1 Viewer)

AdamAccess

New member
Local time
Today, 23:49
Joined
Oct 18, 2019
Messages
4
Hi all,


Another sticky problem...


I'm trying to invoke the "Save as Query"command from the "Advanced Sort and Filter" menu, in a macro. I can see the Ädvanced Sort and Filter"option in the RunMenuCommands macro statement, but don't know how to get to the next level...


Can anyone help with this? Or am I making some fatal assumptions about doing this at all in a macro?


Thanks in advance...
 

theDBguy

I’m here to help
Staff member
Local time
Today, 05:49
Joined
Oct 29, 2018
Messages
21,358
Hi. Macros are a bit limited compared to VBA. If you're trying to create an AdHoc query creator, you might want to switch to VBA.
 

Users who are viewing this thread

Top Bottom