Berkley2020
New member
- Local time
- Today, 06:56
- Joined
- May 7, 2020
- Messages
- 4
Hi there,
I am new to this forum so hopefully I'm doing things right!
I have had lots of Access experience, although that was quite a while ago. Unfortunately, I'm pretty green to SharePoint. I have a feeling my question will be quite easy to answer given the vast experience everyone has on this forum.
I have an Access report which contains hyperlinks to a SharePoint site, specifically a SharePoint list. This list contains all the records from the Access table in question. The report is pretty basic that runs from an Access query with a date parameter to narrow down the rows returned. This query is based on the records in the Access table in question.
What I am trying to do is when the end user clicks on one of these links on the report, I want the user to be taken to that specific item on the SharePoint list based on the unique identifier.
I must be getting the syntax wrong or need to add some vb code to the 'Click' event procedure?
The steps I took are the following:
Any assistance would be greatly appreciated. Thanks!
I am new to this forum so hopefully I'm doing things right!
I have had lots of Access experience, although that was quite a while ago. Unfortunately, I'm pretty green to SharePoint. I have a feeling my question will be quite easy to answer given the vast experience everyone has on this forum.
I have an Access report which contains hyperlinks to a SharePoint site, specifically a SharePoint list. This list contains all the records from the Access table in question. The report is pretty basic that runs from an Access query with a date parameter to narrow down the rows returned. This query is based on the records in the Access table in question.
What I am trying to do is when the end user clicks on one of these links on the report, I want the user to be taken to that specific item on the SharePoint list based on the unique identifier.
I must be getting the syntax wrong or need to add some vb code to the 'Click' event procedure?
The steps I took are the following:
- Added all the fields needed on report.
- Selected the field in question, Category, changed the fields', properties to...
- "Is Hyperlink" to 'Yes'
- Added the link to Property "Hyperlink Target": https://applications.mysite.com/All Categories.aspx?ID=& [Category]![ID]
- Ran the report, clicked on a Category link on the report and was taken to the correct SharePoint list.
- So that's all good, except the link displayed all Categories on the SharePoint list; where as it should have taken me to the specific Category record based on the unique ID Access field.
Any assistance would be greatly appreciated. Thanks!