Macros in Access

[Guest]

I created two new macros to pull from two make table queries. We have one
macro to run all of the macros. The only way that the two new macros pull
information is if I run the two make table queries first. The one macro to
run all macros was created, so we wouldn't have to run each make table query.
I don't know what could be the problem. Can you help?

 

[Guest]

Hi Marlo
I'm not sure what are you asking.Are you running two make table queries? One
after another? Maybe you want Append queries? Could you explain in more
detail what is it that you're doing?

Thanks
Barb

 

[Guest]

We have different Make Table Queries in one of our Access databases. We run
the Macros in this database to bring the data from the Make Table queries
into regular tables in another Access database. Whenever I run any of the
Macros, the regular tables in the other database are not updated. It could
be a query problem. I hope this explanation is less confusing. Thank you.

 

[Guest]

Are you getting any error message? Did you move the second database (one that
you trying to populate), maybe you renamed the folder it's in. In this case
Access would not know "where" to put the data.

Let me know
Barb

 

[Guest]

No, I did not move the second database. The folder still has the same name.
I even double checked to make sure the file path is correct.

 

[Guest]

The tables that you replacing with make table queries. Are they in any
relationships? In that case you may not be able to delete them. Make table
query will first delete existing table then create a new one. Again: any
error message? How do you know that data is not transfered? Are the tables
empty?.. just shooting in the dark...
Barb

 

[Ken Snell [MVP]]

Can you change the maketable queries to normal SELECT queries, and then use
them as the data source "tables" in your "master" query?

Maketable queries cannot be used as data sources in a query; you must run
them in order to create the data tables from them, then you can use the
tables as data sources. However, in many / most cases, the maketable queries
can be changed to normal queries and then can be used directly.