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.