how to activate command button or hyperlink in access reports

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?

Quote: Originally Posted by shalakap 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.

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 -

Quote: Originally Posted by shalakap 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.

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.

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.

I meant to say create a report and open it in report view. My mistake (replace the word form with report)

Quote: Originally Posted by jaxjagfan 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.

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

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)>

Quote: Originally Posted by missinglinq 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?