I have 2 excel spread sheets that are directly linked to Access 2003. These two spread sheets are put through a query to enable the data from both of them to be displayed on one sub form located on a main form.
There are columns in each spread sheet that contain hyperlinks. I have the text boxes in the form set to Hyperlink, and have the hyperlink address in the excel spread sheet set with #at the front and end of the address.
Before I had the spreads sheets joined through the query the hyperlinks worked fine.
Due to the spread sheets being directly linked to access I cannot change any of their properties in the table tab.
Is there any way to get the hyperlinks working again.
There are columns in each spread sheet that contain hyperlinks. I have the text boxes in the form set to Hyperlink, and have the hyperlink address in the excel spread sheet set with #at the front and end of the address.
Before I had the spreads sheets joined through the query the hyperlinks worked fine.
Due to the spread sheets being directly linked to access I cannot change any of their properties in the table tab.
Is there any way to get the hyperlinks working again.