HYPERLINK ON FORMS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using hyperlinks on my mainfor
I dont want the user to be able to open a empty report so i have placed a Msg in the On NoData event of the Report
Now when you click on the Hyperlink the msg appears :great: then a default msg from Access appear
"Microsoft cant follow hypelink to Report, Please verify destination" it does not have an error
Can anyone advise how i might avoid this error from appearin
 
Add this to the Forms "On Current" Procedure: -

Me.ReportNameID.Enabled = True
If Me.ReportNameID = "" Then Me.ReportNameID.Enabled =
False

I have name your "HyperLink" field in the above example
to "ReportNameID": -

HTH

Tony C.
-----Original Message-----
I am using hyperlinks on my mainform
I dont want the user to be able to open a empty report so
Click to expand...
i have placed a Msg in the On NoData event of the Report.
Now when you click on the Hyperlink the msg
Click to expand...
appears :great: then a default msg from Access appears
"Microsoft cant follow hypelink to Report, Please verify
Click to expand...
destination" it does not have an error #
 
Sorry this does not wor
Enabled is not recognised by acces


----- Tony C wrote: ----

Add this to the Forms "On Current" Procedure:

Me.ReportNameID.Enabled = Tru
If Me.ReportNameID = "" Then Me.ReportNameID.Enabled =
Fals

I have name your "HyperLink" field in the above example
to "ReportNameID":

HT

Tony C
-----Original Message----
I am using hyperlinks on my mainfor
I dont want the user to be able to open a empty report so
Click to expand...
i have placed a Msg in the On NoData event of the Report
Now when you click on the Hyperlink the msg
Click to expand...
appears :great: then a default msg from Access appear
"Microsoft cant follow hypelink to Report, Please verify
Click to expand...
destination" it does not have an error
 
Back
Top