Index and Hyperlinks

[Sancti0n]

I have a 65 page report. It lists 27 states, with various data per state. Some states are on one page, others take up 3 or 4 pages. Each page has the state name.

Thanks in large part to the help i've received on this forum, it's a great report and works perfectly. However i've been asked to tweak this report even more and as usual i'm stumped

1 - I need to create an index at the beginning of the report that lists the states I work with. Just a simple list, top-to-bottom. In Word I would just insert a blank page and make one, but i'm not sure on how to do it in access 2007 (maybe something to do with the report header?)

2 - Once this index is created, i need to hyperlink the states FROM the index TO the state name on the page. So if I click on Vermont, I go to the Vermont page. Since some states have multiple pages, I only need to go to the first page. HOWEVER, I then need to hyperlink every state to go back to the index.

ex: Vermont has 3 pages. At the top of the report, in the index, I click on Vermont and I go to the first page of Vermont's info. When done reading, I click on Vermont (first second or third page) and get sent back to the index at the top of the report.

Does anybody know if I can do what I want to? And if so how?

As always, thanks in advance for your time and your help.

 

[dkinley]

Here is an idea for (1). Supposing multiple assignments for states and such I further suppose each user is unique by some field (name, ID, etc).

You could use a subreport based on your user name (or ID or whatever method you use) and the state's assigned to you (or that ID). Then set the subreport at the beginning of this report and use the master/child fields on the user unique field. That is, if the main report is run filtered by the user unique field.

For (2), I have no idea but suspect Layout view (2007) would be required for the clicking action (I've never used layout views). Unsure if something like this could be done in previous versions.

-dK

 

[vbaInet]

This can only be done in Report View, Access 2007 and above. A report becomes interactive in Report View so for example it has Click events.

But here's another idea:

Think about how this works in webpages, you need MENU buttons. Just one in your case, BACK or HOME.

You use two reports, one that will load with all the records (Report 1) and the other to load with 0 records or 1 record (so it doesn't take long to load, call it Report 2). The second report will be hidden behind the first.

Menu-wise Report 1 wouldn't have any button. On the Click event of the State control, program it to hide this report and show the Report 2. Change the Record Source of Report 2 to show only that state.

Report 2 will have the HOME or BACK button so that when clicked, will hide this report and show Report 1.

 

[Sancti0n]

Thanks for the suggestions guys. MUCH appreciated!

 

[vbaInet]

No problemo. Let us know how you get on.