VBA script to open Access and go to called record

[mmattson]

I have an Access DB where I maintain the metadata for data maintained 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 the 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 that prompts me to enter my unique identifier for the Access record. I type it in, hit enter and Access will open and go directly to the record with this unique identifier

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

 

[Tim Ferguson]

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

TBH, I'd stick with Excel and do the whole thing with a UserForm. It's a
little bit more work than Access VBA, but your users will love you for it,
and it will slash your overall development time compared with trying to
OLE-Automate Access.

Best wishes


Tim F