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

how to activate command button or hyperlink in access reports

P: 1
hi All!!!!!!!!!!
i m trying to place command button on reports in access but it doesnt show the onclick event to connect it with macro or procedure.
secondly,i tried to place hyperlink on report ,to show another report but it doent work.........
pls tell me if there is any solution to this problem
or any other way.........
it's urgent!!!!
thanx and regards,
Shalaka.
Feb 5 '08 #1
Share this Question
Share on Google+
8 Replies


mshmyob
Expert 100+
P: 904
Don't know. If it is showing the other events such as Double Click, Focus, etc. It should show the On Click event. Does it show all the other events when you select the button?

hi All!!!!!!!!!!
i m trying to place command button on reports in access but it doesnt show the onclick event to connect it with macro or procedure.
secondly,i tried to place hyperlink on report ,to show another report but it doent work.........
pls tell me if there is any solution to this problem
or any other way.........
it's urgent!!!!
thanx and regards,
Shalaka.
Feb 5 '08 #2

Minion
Expert 100+
P: 108
Shalaka,

The reason that you cannot see the OnClick event is that reports are non-dynamic in that once they are generated the information is pretty much set. There is a limited amount of coding you can do to the report itself, but it is nearly all run at generation. I'm not sure exactly what you are trying to do here with the command button, perhaps if you were more specific with you requirements we could lend an hand.

As for the hyperlink issue. Again reports themselves are static once they are generated inside of Access. However, if you export them to say a word document then you're hyperlinks will work when clicked. But be mindful that if they are linking to other reports in the database that it will be necessary for the database to be open for them to be able to access these reports.

I have a feeling that none of this really accomplishes what you are looking for, or maybe it does. Either way let us know and if you need more please further outline what you are trying to accomplish.

Hope this helps.

- Minion -

hi All!!!!!!!!!!
i m trying to place command button on reports in access but it doesnt show the onclick event to connect it with macro or procedure.
secondly,i tried to place hyperlink on report ,to show another report but it doent work.........
pls tell me if there is any solution to this problem
or any other way.........
it's urgent!!!!
thanx and regards,
Shalaka.
Feb 5 '08 #3

mshmyob
Expert 100+
P: 904
You can put a command button in a report. I do it all the time for certain functions. But I have never seen it that all events are viewable but not the just the Onclick event.

I use it so a user can view the report on screen and then has 2 buttons - one to close the form and 1 to print. Obviously I open in Form view. You also need to set the property to only see the buttons on the screen and not during print or you will see the buttons when you print the report. of course in Form view you do not have all the print preview functionality but I set all that before hand.
Feb 5 '08 #4

jaxjagfan
Expert 100+
P: 254
You can layout a form to look like a report to some degree and keep all of the functionality of the form. Reports pretty much have no interaction after they are generated.
Feb 5 '08 #5

mshmyob
Expert 100+
P: 904
I meant to say create a report and open it in report view. My mistake (replace the word form with report)

You can layout a form to look like a report to some degree and keep all of the functionality of the form. Reports pretty much have no interaction after they are generated.
Feb 5 '08 #6

P: 4
Hi

CAme accross this discussion since I too am trying to put buttons on a report - one to print and one to close report/return to menu. I have absolutely no events showing under properties.

mshmyob - how are you achieving this, could you possibly provide a copy of your code?

Thanks
Mar 27 '08 #7

missinglinq
Expert 2.5K+
P: 3,532
I see no mention here of Access versions. While you can place buttons on reports in any version of Access (at least from 2000-2007) they are only functional in version 2007! Don't really know why they even appear in the earlier versions; suspect it was just a case of someone being too lazy to remove them.

Welcome to TheScripts!

Linq ;0)>
Mar 27 '08 #8

P: 4
I see no mention here of Access versions. While you can place buttons on reports in any version of Access (at least from 2000-2007) they are only functional in version 2007! Don't really know why they even appear in the earlier versions; suspect it was just a case of someone being too lazy to remove them.

Welcome to TheScripts!

Linq ;0)>
Thanks - good to have this info. Any advice as to how I can ahieve what I am trying to do?
Mar 27 '08 #9

Post your reply

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