Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command and pass value to Acces from Excel
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 . Who can help me solve this problem? my regards, look -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Front end Acces Back end | Excel Discussion (Misc queries) | |||
Can I use Excel to make Inventory without using Acces? | New Users to Excel | |||
How to: Pass Command Line Parameter ??? | Excel Worksheet Functions | |||
Working betwen excel and acces | Excel Discussion (Misc queries) |