Answer Complete!!
Thank you so much!!
User Profile
Collapse
-
Thank you very much TheSmileyOne.
I am having further issues because not every record in my table has a hyperlink path.
I have been working with a If statement, but i cannot get it to work. I am unsure what I am commanding the if statement to do, but I receive the Msgbox everytime (I changed "tbl_doc" to my table name):
If strPath = DLookup("InfoPD F", "CompanyInf o", "FileID="...Leave a comment:
-
On the form
ComboBox: CompanyName
Controlsource value: CompanyName
Row Source value: SELECT CompanyInfo.Fil eID, CompanyInfo.Com panyName FROM CompanyInfo ORDER BY CompanyInfo.Com panyName;
On the table:
Autonumber: FileID
Text Column: CompanyName
Hyperlink Column: InfoPDFLeave a comment:
-
How to have a button open a hyperlink?
I have a form with a Combo box and a button.
I want the user to be able to choose an option in the combo box, click the button, and a related .pdf is opened.
The Combo box has a control source in a table. Within the same record as the control source, a 2nd column contains a hyperlink with a file path to a related .pdf.
What I am struggling with is the code associated with the clicking of the button.
How...
No activity results to display
Show More
Leave a comment: