Hi guys.
Using the /cmd switch when opening Access, I've managed to make it so a user can open a specific record on a specific form automatically when they open my database.
Emails are automatically generated that notify the user that they have a new record to view and the idea is that the user will click a hyperlink to be taken to that record.
The problem I'm having is that when the user receives the HTML email, the forward slash that preceeds cmd is replaced by a backslash, even though it's a forward slash in my code. Any suggestions?
Using the /cmd switch when opening Access, I've managed to make it so a user can open a specific record on a specific form automatically when they open my database.
Emails are automatically generated that notify the user that they have a new record to view and the idea is that the user will click a hyperlink to be taken to that record.
The problem I'm having is that when the user receives the HTML email, the forward slash that preceeds cmd is replaced by a backslash, even though it's a forward slash in my code. Any suggestions?
Code:
& "<td bgcolor='#CCCCCC'><font face='Calibri' size='2' color='black'><a href='c:\dean\master\dean.mdb /cmd discrepancy_reports_new|discrepancy_id|" & str_dr_reference & "'>" & str_dr_reference & "</a></td>" _