Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

Access Macro

Hi,

I have an autoexec macro that i am looking to to a couple of things and one of them is to execute a make table query.

In the macro can i use OpenQuery to execute the make table?

Thanks
Seamus
0
Seamus2626
Asked:
Seamus2626
  • 2
1 Solution
 
jppintoCommented:
Yes, put OpenQuery and put the name of the Make Table Query that you want to execute.

jppinto
0
 
jppintoCommented:
Here's an example on how you can do it:

http://www.databasedev.co.uk/open-query-macro.html

jppinto
0
 
Seamus2626Author Commented:
Thanks Jppinto
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now