Looking for Access combined with Excel functionality

[Eana]

Hi,

Hope someone can assist me with this question:

Let's say I have a Table with many Product IDs records..
Product ID (Number)
Hyperlink Field (with a Hyperlink to an external Excel file)

What I would like to do is to create a Hyperlink that not only will it open the Excel file but it will also search and select the Product ID (in Excel) of the record on which the Hyperlink was clicked in Access.

Is this possible or am I just wishing too much?

 

[pdx_man]

My first thought is to have a utility table that holds the value of the ProductID of the record that you selected. Then, in your Excel file, have code on the OnOpen Event query the Access database and get the value and do your search. You may want to put a timestamp on the record in the utility table so that if the Excel file is opened directly (not through Access) it does not search for the value.

 

[ajetrumpet]

hey PDX, how do specify an option in these forums to receive e-mail alerts for postings in my threads?

EANA - An "Auto_Exec" macro option might work for some of this, have to post appropriate code with it though, I'm not big on that yet. Sorry.

 

[boblarson]

hey PDX, how do specify an option in these forums to receive e-mail alerts for postings in my threads?

ajetrumpet: