Automated Query Using Macros in Access

[htran]

I create a query and would like to export it to Excel format. I would like to automate this process so it will run by itself.

I created a Macros so this can be done automatically.

While creating the query, the process needs to access two separate databases to gather the data. One is Oracle (using ODBC link) and the other is Foxpro (using ODBC link).

When I ran it manually, I can enter the passwords but when it is being automated, I can't seem to make it work using the "Sendkeys" action.

Can anyone please help me with this?

Thanks.....

 

[htran]

I found the solution for this anyway.

I had to load the Microsoft Access Utility Add-in. The "Sendkeys" command then works like a charm....