Links on ms access reports

[IGPCS]

Can anyone help if its possible that if i click on a line or field in a report it should open the acctual form with that data

Thank you

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[CharlieT302]

You can use the "Command Button" to initiate a wizard that will guide you through the process. You have the choice of opening a relational form to display records pertaining to the record value you are currently on, or open an unrelated form.

The "Command Button" is on the Toolbox toolbar.

 

[IGPCS]

Thank you charlie i like that point and i did it but my boss wants me to make the acctual PO number clickable so he cliks in the report it self and it opens the PO form

Thank you

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[straybullet]

Have tried both Insert -> Hyperlink and creating a button. Wasnt able to click on either when viewing the report?

Let them hate - so long as they fear... Lucius Accius

 

[IGPCS]

i know is there a way to chage that or all i will need is calling MS to put this option in the next version ?

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[CharlieT302]

Attach the following code to the P.O. number field:

On Error GoTo Err_Command84_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Form to be opened"

stLinkCriteria = "[PONumber]=" & "'" & Me![PONumber] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command84_Click:
Exit Sub

Err_Command84_Click:
MsgBox Err.Description
Resume Exit_Command84_Click


[PONumber] assumes this is your field name. Substitute the actual name.

1.Right-click the field
2.Choose Properties
3.ON the Event tab, select the "On Click" event'
4.Click the "Build" button (3 dots)
5.Choose Code
6.Enter the code

 

[IGPCS]

charlie i dont need this in a form i need this option but in a report is it possible i am almost sure its not but i am sure someone here could give me a clue

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[CharlieT302]

My apologies. I didn't understand the question. I am not aware of any such thing as Access does not allow interactivity with reports in the same manner as say: "Crystal Reports."

Is it an absolute necessity that it be a report.

For example, if the report is a basic report (no grouping, etc), you can create a form that mimics it in appearance. In a header, you could have a button called "Printable Version" or some such thing that, when pressed, prints the actual report.

This way you could have your link and a printable report as well. The end user does not need to know (nor should they care) that what they have pulled up is actually a form.

However, if the report is beyond basic functionality this will not work.

 

[IGPCS]

Thank you

i thought about that doing it in a form just the problem is it is a very comlicated report in designing and for me to redo it i am too lazy

and i hope my dosnt see this thread

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY