Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • 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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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