Command and pass value to Acces from Excel

L

Looko

I have an Access DB where I maintain the metadata for data maintaine
within Excel spreadsheets (I have good reasons why it stays in Excel)
I would like to be able to open the Access DB and go directly to th
record associated with this piece of data using a VBA input box.

For example...if I am working in Excel, I want to call a module tha
prompts me to enter my unique identifier for the Access record. I typ
it in, hit enter and Access will open and go directly to the recor
with this unique identifier.

Does anybody have a module already designed for this type of activity


I'm not a programmer, but I'm trying something .:confused:

Who can help me solve this problem?

my regards,

look
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
How do I clear a form? 0
recordset vs collection 2
search column for duplicate value during data entry 3
Excel 2003 - VBA to get a list of Module names in the project 4
VBA script to open Access and go to called record 1
Pass Parameter from Excel to SharePoint 1
Exporting data with vba from Excel to an Access 2007 db with password 8

Top