Open form/record in Microsoft Access from Outlook
- Thread starter Harris@Z
- Start date
Yes, but it's not easy. I think the only option is to implement "Deep Hyperlinks" to your Access application.
Access MVP TheSmileyCoder hat an article on his blog about that, but I can't find it anymore. However, here is a video of his covering the topic: Hyperlinking or Deep Linking in Microsoft Access
Access MVP TheSmileyCoder hat an article on his blog about that, but I can't find it anymore. However, here is a video of his covering the topic: Hyperlinking or Deep Linking in Microsoft Access
- Local time
- Today, 05:49
- Joined
- Feb 19, 2013
- Messages
- 17,816
assuming it can be done, would also think the hyperlink would need to be in the outgoing message as well which would be confusing to those recipients who do receive the email. Even if marked with a 'for office use only' type message, some curious souls will click it and although it won't 'work' it will still expose some of your data to the recipient.
Thanks for both your responses.
I did consider that the outgoing message may be confusing, but considered possibly 'hiding' the link by making the text white, or linking to a nondescript image.
I will see if the video has any guidance.
I did consider that the outgoing message may be confusing, but considered possibly 'hiding' the link by making the text white, or linking to a nondescript image.
I will see if the video has any guidance.
If this is better or not totally depends on the requirements. Reading the incoming emails is entirely different from providing the user a link in an email to click on to get to linked information in the Access database.
I don't think so.
This screenshot was taken right now in the most recent Access 365 version:
Thanks all for contributing to the discussion.
Sonic8 - your contribution recommending Hyperlinking or Deep Linking in Microsoft Access should have been very helpful but unfortunately the link the video supplied was to a site where the article was no longer available, and an email to the owner has not received a reply.
As the OP the rationale for my request is this:
I send an email generated by Access to a client regarding a specific order and asking for further information. I would like to embed the order number (record) and on receipt of the response, instead of searching for the order number to input the response, click on the embedded link which will automatically open an Access form already highlighting that record.
Sonic8 - your contribution recommending Hyperlinking or Deep Linking in Microsoft Access should have been very helpful but unfortunately the link the video supplied was to a site where the article was no longer available, and an email to the owner has not received a reply.
As the OP the rationale for my request is this:
I send an email generated by Access to a client regarding a specific order and asking for further information. I would like to embed the order number (record) and on receipt of the response, instead of searching for the order number to input the response, click on the embedded link which will automatically open an Access form already highlighting that record.
- Local time
- Today, 05:49
- Joined
- Feb 19, 2013
- Messages
- 17,816
found this link about using a hyperlink from outlook to open access to a specific form and record. Looks like a lot of work and not necessarily resulting in a workable solution. But plenty of links to ideas
Email with Hyperlink - Click to open specific record - Post.Byes
Hello, I am in a tough situation... I am working on a database and now I have a hard hurdle to finish my database. I have a form from which I am able to send a record for approval. Where approval will be through email reply. Now I want to change it to electronic way: - First send an email to...
bytes.com
Thank you!
This links through to the following url: https://bytes.com/topic/access/insights/873647-invoking-database-command-line
The last post includes a zipped Access example.
Essentially the author suggests linking a variable to the end of the command line, which when the database opens, recognises the variable and acts on that variable.
e.g. "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE" "C:\PathtoDatabase\OpenAuto.Mdb" ;myvariable
The database opens the form "Main" which has this code On Open
If Command() = "myvariable" Then
Call MsgBox("The database is opened automatically , " & _
"and will close as soon as you click on OK", _
vbOKOnly, _
"AutoMessage")
Cancel = True
End If
Now to work out whether one can a link that runs the command line
This links through to the following url: https://bytes.com/topic/access/insights/873647-invoking-database-command-line
The last post includes a zipped Access example.
Essentially the author suggests linking a variable to the end of the command line, which when the database opens, recognises the variable and acts on that variable.
e.g. "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE" "C:\PathtoDatabase\OpenAuto.Mdb" ;myvariable
The database opens the form "Main" which has this code On Open
If Command() = "myvariable" Then
Call MsgBox("The database is opened automatically , " & _
"and will close as soon as you click on OK", _
vbOKOnly, _
"AutoMessage")
Cancel = True
End If
Now to work out whether one can a link that runs the command line
Similar threads
