Automating Access 2007 with Excel Form

[ibro tj]

Hello,

I want to be able to control an access database objects from the excel front-end to do the following:

Create a dynamic query containing all or some of the fields in the access table using an excel form to select the parameters.. My user does not even want to interact with Access at all.

Thanks

Tj

[pod]

Look-wise, there is not much difference between a form in Excel and one in Access. I think it would be easier to work with a form in Access code-wise.


... but if it is what you want check out his link:
http://vbaexcel.eu/vba-macro-code/da...-using-vba-dao

[ibro tj]

Pod,

Thanks for replying. I check the site.It gives some insights. But is it possible to run an access macro that creates a query in excel. I want the creation of my query in the database to be dynamic. Thanks.

[pod]

whenever someone asked me if it possible to do this or that, I always say yes even if I don't know yet how to do it but I tell them it might take some researching if so ...


My suggestion to you is go in small steps:

• make a connection to the database from your Workbook

• create your SQL statement from the selected fields in Excel

• run the query ...