Save as Query menu command (1 Viewer)

AdamAccess

New member
Local time
Today, 09:51
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
Local time
Yesterday, 16:51
Joined
Oct 29, 2018
Messages
10,827
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 (Users: 0, Guests: 1)

Top Bottom