Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-18-2019, 01:39 PM   #1
AdamAccess
Newly Registered User
 
Join Date: Oct 2019
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
AdamAccess is on a distinguished road
Save as Query menu command

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...

AdamAccess is offline   Reply With Quote
Old 10-18-2019, 01:41 PM   #2
theDBguy
I’m here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,489
Thanks: 58
Thanked 1,419 Times in 1,400 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Save as Query menu command

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.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
command bar sub menu problems stuartam Modules & VBA 11 01-23-2018 12:23 PM
How do I call a menu command in VBA? odin1701 Modules & VBA 2 02-29-2008 03:34 AM
Launching menu command from code roypython General 5 05-22-2007 05:36 PM
Menu Item or Command Button Navyguy Reports 5 04-01-2004 08:50 PM
Command Bar with menu and button in Access micsak Modules & VBA 5 10-09-2003 02:21 AM




All times are GMT -8. The time now is 06:39 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World