Hi,
My goal is to create reports from Access that contain several different hyperlinks. I am using linked tables at this time as I am only testing the sytem as yet and still want it connected to the original data. I have four original tables from which I want data displayed. I have done the following as I understand that this is what I have to do.
1. From my original excel tables, I have created linked html tables.
2. I have imported the html tables and maintained the links to the original html (excel linked to html, linked to access).
3. When importing the htmls, I have indicated in the tables, which columns are hyperlinks and when I checked in the design view of the tables, all the appropriate columns are listed as hyperlinks.
4. Created a query to narrow down my list from my four tables, i have created a left join property for "Application Name" from each table. (so each table has the application name and that is what links them). I chose the column Application Name from the first table and add a hyperlinked column from each of the other three tables.
5. In the "Total" category of the query, I have selected Group by for the Application Name and have at separate times, selected either group or first for the other 3 columns and get either; (group by) first column of hyperlink working and gobbly goup for the next three that is blue hyperlink, but goes no where; or (first) the full name of the hyperlink in all columns, with no blue indicator and no actual link.
All I really want to do is make sure my hyperlinks appear in queries and reports as this is the point of most of the information coming out of these tables.
Also, I want to know if there is a site which offers advanced Access information as everywhere I search an explanation comes up and does not go far enough to tell me any real information other than that for a beginner.
My goal is to create reports from Access that contain several different hyperlinks. I am using linked tables at this time as I am only testing the sytem as yet and still want it connected to the original data. I have four original tables from which I want data displayed. I have done the following as I understand that this is what I have to do.
1. From my original excel tables, I have created linked html tables.
2. I have imported the html tables and maintained the links to the original html (excel linked to html, linked to access).
3. When importing the htmls, I have indicated in the tables, which columns are hyperlinks and when I checked in the design view of the tables, all the appropriate columns are listed as hyperlinks.
4. Created a query to narrow down my list from my four tables, i have created a left join property for "Application Name" from each table. (so each table has the application name and that is what links them). I chose the column Application Name from the first table and add a hyperlinked column from each of the other three tables.
5. In the "Total" category of the query, I have selected Group by for the Application Name and have at separate times, selected either group or first for the other 3 columns and get either; (group by) first column of hyperlink working and gobbly goup for the next three that is blue hyperlink, but goes no where; or (first) the full name of the hyperlink in all columns, with no blue indicator and no actual link.
All I really want to do is make sure my hyperlinks appear in queries and reports as this is the point of most of the information coming out of these tables.
Also, I want to know if there is a site which offers advanced Access information as everywhere I search an explanation comes up and does not go far enough to tell me any real information other than that for a beginner.
