How do I view a specific record in Access from an Excel link

A

Ashley Roe

I have a spreadsheet with data, and then the details of that data is stored
in an Access database. Both sets of data are stored by their unique record
number. I would like to click on the record number in Excel to view the
matching record in the Access form. Is this possible? Can I link Excel and
Access in a way that if I click record 2 in Excel, record 2 in Access opens?
Right now I have a hyperlink set up that opens up the Access form, but now I
am looking for the particular record.

Thank You,
Ashley Roe
 
S

smartin

Ashley said:
I have a spreadsheet with data, and then the details of that data is stored
in an Access database. Both sets of data are stored by their unique record
number. I would like to click on the record number in Excel to view the
matching record in the Access form. Is this possible? Can I link Excel and
Access in a way that if I click record 2 in Excel, record 2 in Access opens?
Right now I have a hyperlink set up that opens up the Access form, but now I
am looking for the particular record.

Thank You,
Ashley Roe
Click to expand...

You can do something very close to this. The link below walks through
how to set up a data connection from Excel to Access. You might well
have this part already covered:

http://www.dicks-clicks.com/excel/ExternalData.htm

The next link (same site) shows how you can set up a parameter query.
Such a query can be made to, say, fetch the row in Access that has the
unique record number in question. The parameter can be fed with a prompt
or a cell in Excel that automatically triggers the query to run when you
update the cell:

http://www.dicks-clicks.com/excel/ExternalData6.htm#Parameters

Hope this helps.
 
S

smartin

Ashley said:
I have a spreadsheet with data, and then the details of that data is stored
in an Access database. Both sets of data are stored by their unique record
number. I would like to click on the record number in Excel to view the
matching record in the Access form. Is this possible? Can I link Excel and
Access in a way that if I click record 2 in Excel, record 2 in Access opens?
Right now I have a hyperlink set up that opens up the Access form, but now I
am looking for the particular record.

Thank You,
Ashley Roe
Click to expand...

You can do something very close to this. The link below walks through
how to set up a data connection from Excel to Access. You might well
have this part already covered:

http://www.dicks-clicks.com/excel/ExternalData.htm

The next link (same site) shows how you can set up a parameter query.
Such a query can be made to, say, fetch the row in Access that has the
unique record number in question. The parameter can be fed with a prompt
or a cell in Excel that automatically triggers the query to run when you
update the cell:

http://www.dicks-clicks.com/excel/ExternalData6.htm#Parameters

Hope this helps.
 
Top