bookmark variable

  • Thread starter Thread starter kari
  • Start date Start date
K

kari

is it possible to bookmark a recordset in a table in
excel, using a variable defined in excel?

what i'm trying to do is inter-relate information in our
company database with an excel spreadsheet. i want to
look up the phone # that is in the spreadsheet and using
that number display the appropriate access form,
displaying that customers contact information.

i've figured out how to open the access form in excel,
but am having trouble with the looking up part.
 
what i'm trying to do is inter-relate information in our
company database with an excel spreadsheet. i want to
look up the phone # that is in the spreadsheet and using
that number display the appropriate access form,
displaying that customers contact information.

i've figured out how to open the access form in excel,
but am having trouble with the looking up part.
Click to expand...

I cannot work out which application you are working in.

Do you have an Excel UserForm where you want to look up a phone number held
in an Access table? In that case, you can use CreateObject to make a
DBEngine object, open the database and use DLookUp or OpenRecordset to get
the information. This might even be one of those situations where ADO is
better than DAO, but you should use whichever you feel more comfortable
with.

On the other hand, is this an Access form and you want to look stuff up in
an Excel table? This is probably easier because you can use File| External
Data| Link to link to the excel stuff and do joins and queries just like
any other table. You cannot, for obvious reasons, impose any kind of
relational integrity between two separate files though.

Hope that helps


Tim F
 
Back
Top