Contain link to access record in email

[evanscamman]

When something is wrong with an order, my database generates an email to the purchasing manager, saying: Such and such is wrong with this order, etc...

Is there any possible way to include a link in the email, that when user clicks will pop open access, load the correct form and goto the correct record?

If it is possible, I'm guessing that there could be security issues to deal with as well.

Thank you,
Evan

 

[Darth Vodka]

When something is wrong with an order, my database generates an email to the purchasing manager, saying: Such and such is wrong with this order, etc...

Is there any possible way to include a link in the email, that when user clicks will pop open access, load the correct form and goto the correct record?

If it is possible, I'm guessing that there could be security issues to deal with as well.

can you have the DB remember what issue are for a certain person and when they log in, check their NTID and display the relevant records for them?

your link in the email is just a link to the DB

 

[evanscamman]

Perhaps. They are already being sent an email, so I would just like the email to include a link to the record - that way 1 click will bring them to the correct spot.

 

[Mike375]

Just random thoughts

I suppose you could have a setup where you have a small separate DB and what triggers you email also sends that record to the small DB. Probably a combination of a Delete/Append query to a table in the main DB and CopyObject to the little DB

The email that is sent would attach the little DB and the little DB could have an Autoexec macro to open the other DB. The little DB has the record so the ID number is there.

The auto exec in the little DB coul export the one record table to the main DB. What you could coud then do is have a macro or code that uses the ID from that one record table to open a form at the appropriate record

Well, you get the idea.

It would be easy to have the persons ID number go into the body of the email you send. You just need Word doc going into the body and the ID has gone into Word bookmark but I don't know if you could do anything with that.