Solved

Access Macro

Posted on 2011-03-25
3
171 Views
Last Modified: 2012-05-11
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
Comment
Question by:Seamus2626
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 33

Accepted Solution

by:
jppinto earned 500 total points
ID: 35213729
Yes, put OpenQuery and put the name of the Make Table Query that you want to execute.

jppinto
0
 
LVL 33

Expert Comment

by:jppinto
ID: 35213736
Here's an example on how you can do it:

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

jppinto
0
 

Author Closing Comment

by:Seamus2626
ID: 35213740
Thanks Jppinto
0

Featured Post

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question