Hello There!
I'm a VBA novice programmer and I'm more familiar with designing Access applications. However, I am having a few problems linking Excel and Access together.
What I am trying to achieve is when a users enters a value inside a cell/textbox in Excel, it is looked up in my Access tables and inserts some of the fields into certain cells in Excel. For example, if a user enters a StoreID in Excel, the ID is looked up in the tables and the relevant information is filled in in Excel, such as StoreName etc. I am using Access/Excel 2000.
Any ideas? I hope there's a lot of clever people out there (although i'm sure it's easy). Is it even possible? Thanks for any help you guys/gals!
Scoobey
I'm a VBA novice programmer and I'm more familiar with designing Access applications. However, I am having a few problems linking Excel and Access together.
What I am trying to achieve is when a users enters a value inside a cell/textbox in Excel, it is looked up in my Access tables and inserts some of the fields into certain cells in Excel. For example, if a user enters a StoreID in Excel, the ID is looked up in the tables and the relevant information is filled in in Excel, such as StoreName etc. I am using Access/Excel 2000.
Any ideas? I hope there's a lot of clever people out there (although i'm sure it's easy). Is it even possible? Thanks for any help you guys/gals!
Scoobey
