Help : Run Access Query From Excel

[DoraC55]

Hi there,

This is what I want to do :

I have a User Form in Excel. When a person enters an ID or a LastName (basically a primary key) and then clicks a 'GetInfo' Command button on the User Form, I want the records in an access database with the matching ID/LastName to populate in the Excel Sheet.

Now, any changes I make to these populated records in the Excel Sheet, should be updated in the access database as well.

Can someone please help me with a walk through? A step by step process? I'm willing to learn, but I'm slow. And I have barely any experience with VB and Access. So please teach me well, and I'll learn, I promise.

 

[Alansidman]

This blog from Mike Alexander should be helpful.

http://datapigtechnologies.com/blog...-access-parameter-query-from-excel/#more-1148

 

[DoraC55]

Heyy thank you, thank you, thanks a lot.

Yea that helps, but I'm having trouble with DAO.
I have Access 2010 and Excel 2010. And I set my 'Reference' to microsoft office 14.0 access database engine.

I get a Run Time error : Application-defined or object defined error
A little help, Please?

 

[Alansidman]

I think that has been an issue for a number of folks who tried it. Did you check out the comments of others on the DAO subject in the blog.

 

[DoraC55]

I think that has been an issue for a number of folks who tried it. Did you check out the comments of others on the DAO subject in the blog.

I did, nothing is exactly like my problem. And it fails with different errors despite trying their 'fixes'. I even posted my own comment to the blog regarding this issue.