« How do you create charts in Microsoft access 2000?
i hav visual std 2005 and i know ms access i want to use it as data base plz help me with good tutorial? »

Can you create a Macro in Access 2007 to create a number of queries for you.?

Trying to automate the creation of 121 queries, any way to do this in a macro or just by hand?

Can you create a Macro in Access 2007 to create a number of queries for you?

Do you mean run queries? If so, yes using the ‘OpenQuery’ command.

If you want create queries, I assume you mean generate SQL? then you need to know how to write SQL (via the SQL View) whioch can be called by the same command in a macro.

What is it you actually want to do?

There are SQL commands that can create tables, fields and change data using the SQL syntax language see http://www.about-access-databases.com/sql-query-syntax.html

This entry was posted on Monday, February 8th, 2010 at 6:56 am and is filed under access queries. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Can you create a Macro in Access 2007 to create a number of queries for you.?”

  1. Ben Says:
    February 8th, 2010 at 12:21 pm

    Can you create a Macro in Access 2007 to create a number of queries for you?

    Do you mean run queries? If so, yes using the ‘OpenQuery’ command.

    If you want create queries, I assume you mean generate SQL? then you need to know how to write SQL (via the SQL View) whioch can be called by the same command in a macro.

    What is it you actually want to do?

    There are SQL commands that can create tables, fields and change data using the SQL syntax language see http://www.about-access-databases.com/sql-query-syntax.html
    References :
    Ben Beitler – Access database trainer and developer.
    http://www.about-access-dataabases.com
    http://www.access-database.com
    http://www.excel-spreadsheet.com
    http://www.trainingpartnership.biz

Leave a Reply