Hi,
I really need to get this problem resolved fast, so any help that you give will be appreciated.
Steps I took:
1) I created a simple table about a product and its options.
2) Then created a data access page in the design view.
3) Created a Pivot Table in the design view that listed all of the information from the database.
Problems encountered.
-One of the columns in the table is a hyperlink column (it was linked to different web pages regarding a "product" in a separate column). As soon as the Pivot table came up in the data access page, the column that was a hyperlink column looked messed up. The column is no longer a hyperlink column in the pivot table, but instead, just showed the name of the hyperlink, with the linked page in between two number signs.
All the listings in the hyperlink column looked like this:
Joe Schmo Company#test contact.htm#
When I clicked on the column that was hyper linked, I was not transferred to the targeted web page. I went back to the table with the information to see if I had done something incorrectly, but it seemed fine.
Is there a way to keep the Hyperlink column the way it is? I was trying to set up the page so that after someone filtered the page by using the pivot table, all they would do is just click on the name of the product and they would be taken to the product's web page.
Thanking you in Advance
Murry234
I really need to get this problem resolved fast, so any help that you give will be appreciated.
Steps I took:
1) I created a simple table about a product and its options.
2) Then created a data access page in the design view.
3) Created a Pivot Table in the design view that listed all of the information from the database.
Problems encountered.
-One of the columns in the table is a hyperlink column (it was linked to different web pages regarding a "product" in a separate column). As soon as the Pivot table came up in the data access page, the column that was a hyperlink column looked messed up. The column is no longer a hyperlink column in the pivot table, but instead, just showed the name of the hyperlink, with the linked page in between two number signs.
All the listings in the hyperlink column looked like this:
Joe Schmo Company#test contact.htm#
When I clicked on the column that was hyper linked, I was not transferred to the targeted web page. I went back to the table with the information to see if I had done something incorrectly, but it seemed fine.
Is there a way to keep the Hyperlink column the way it is? I was trying to set up the page so that after someone filtered the page by using the pivot table, all they would do is just click on the name of the product and they would be taken to the product's web page.
Thanking you in Advance
Murry234