Help : Run Access Query From Excel

DoraC55

New member
Local time
Today, 15:28
Joined
Jul 23, 2013
Messages
3
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.
 
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?
 
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 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.
 

Users who are viewing this thread

Back
Top Bottom