Pass parameter to Access Form through Hyperlink in email

Question

Hi,

Is it possible to pass parameter to a Access Form through Hyperlink in email to search a record?

The target From is a Start up from, opens automatically when database opens. I want to display specific record.

Regards

Atif

Answer 1

I'm pretty sure you will have to add the path to msaccess and the /cmd argument like I suggested. Did you try enhancing your <a> tag with this extra syntax?

Answer 2

Hi Tom,

Thank you for your reply.

When user creates a new record. Access sends an email message with a hyperlink to database and record ID in Subject line.

"<a href=""" & "C:\Users" & GetLogOnUser & "\Documents\NC Reports\NonConformanceReport_v1.3.accdb" & """>" & _

"Click here to access the NCR Database" & "</a > "

The recipient clicks on the Hyperlink, it opens the database and start-up Form.

What I want is to include Record ID i.e. OrderID in hyperlink and sent it back to database as search criteria. So, when the recipient click on the Hyperlink in email it not only open the Form but also display that record.

Regards

Atif

Answer 3

What kind of hyperlink are you thinking of? The only one I can think of is an Access command line, like this:

[path_to]msaccess.exe [path_to]your.accde /cmd OrderID=123

In your startup code you can then check Command$ and get "OrderID=123" which you can use to open your form to that record.