Hyperlink hell

[Avinit]

Hi,

I am pretty new to access but have quite a good general knowledge of other office suite programs. However, I am having a mare as regards linking an excel table into access where a column contains Hyperlinks.

I have tried this 2 different ways and both arent giving me good results.

1. I can import a table into access from excel and get all hyperlinks working fine. However when I import a linked table the hyperlinks dont work because i cant change the dataset to hyperlinks.

2. It was suggested saving the excel spreadsheet as a webpage then linking it in to access. Now this works up to a point although when i go through the wizard i get a list of multiple tables (table1 , table2, table3 etc.) I select the one with the majority in but cannot get all my excel spreadsheet to appear, although the links for the ones that are present are working fine.

I am unsure which is the right method to go down, as both are nearly there but not quite.

Any help would be greatly appreciated.

Thanks



Ben

[pkstormy]

I might design a form based on the excel linked table (and show it as a datasheet). Then in the OnClick event of the hyperlink excel field (in the form's event for the hyperlink field), add code such as:

Dim strURL as variant
strURL = me!MyExcelHyperlinkFieldName
application.followhyperlink strURL