By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,105 Members | 2,620 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,105 IT Pros & Developers. It's quick & easy.

Creating active Hyperlinks with report print preview

P: 68
I would like to create an active hyperlink in my report that would allow me to open a form. Is there a way to accomplish this?
Jan 7 '09 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 2.5K+
P: 2,545
Hi KingKen. Reports are not interactive - there is no means I know of by which you can respond to a hyperlink field on a report.

Reports do not respond to user-related events such as on-click or on-mouseover, so you will need to find a different way to do so that does not involve placing a hyperlink on a report.

Jan 7 '09 #2

P: 68
Well how about creating a Menu bar that has the button and a combo box that would allow me to call another report.

Is it also possible to use the combo entry to set parameters for a query that would supply the new report that the button would open?

I have a report that evaluates the tasks that support staff had performed. It gives the number of tasks performed by each technician over a given period. I want to be able to see another report that gives the details of the tasks for a given technican. For example, If technician Harry performed 100 tasks for May then I may want to know the specifics of the tasks. it would be easy for me if i can go straight from that report to another that gives me this detail which after closing would return to the orignal report for viewing another if so desired

I have never created menu bars before so I am wondering if they can work like forms and how to get started.
Jan 8 '09 #3

P: 206
Have you tried using a form instead of a report? It seems to me that you would benefit by having a series of forms that are filtered by whatever command buttons and combo boxes you set up. Then if you need an actual "report" based on the info currently displayed on your screen, create a "print report" or "view report" button on the form.

The only reason that I can think of that you'd even desire to do this from a report rather than a form is if you like the way the report lists the data. If that's the case, you might try duplicating that look in a form, like with the form setting on "continuous forms" and have the shape of the form be long horizontally and short vertically, with just enough room to display the desired fields and have a button or two. Then each record would be displayed like a line in a report (though not as compactly), one after the other after the other in a list.

If I have it all wrong, let me know why it is you wish you could do it from the report itself. What do you like about the report that would work better for you than a form?
Jan 8 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.