Generate link (for e-mail) to specific form in Access

[artursg]

Hi guys,



I will shortly try to explain my idea.

We have a register of non-conformities in Access, so I wonder if there is any way to get a link to a specific form (in our case a report) that can be emailed?
At the moment we just send a database link that opens the whole file, which is inconvenient from the user's point of view.

Is there any way to set this up?

Thank you very much.

[Welshgasman]

Care to show the link?

[xps35]

I wonder if there is any way to get a link to a specific form (in our case a report) that can be emailed?

If it is a report, why don't you email the report?

[artursg]

If it is a report, why don't you email the report?

The person is informed that he/she has to deal with an NC (report) and it is important that he/she can open that particular form and continue to complete it.

[Micron]

Consider providing a list of issues that require their attention when they open the db. That is, the list is specific to them. They can then open the form to the item they choose from the list. You could also email that data in the notification email where you want to put this link. If there is a way to open a specific form filtered to the user by way of an email link I've never heard or read of it. I doubt it can be done.

[Gicu]

Have a look at this thread dealing with the same question, it looked that they were getting close:
https://www.access-programmers.co.uk...tabase.314505/
EDIT:
another older link:https://www.access-programmers.co.uk....279024/page-2
Cheers,

[Micron]

Makes me wonder if you can create a shortcut command line (like what you see in Target field of shortcut properties) in vba and email it. The shortcut could contain a command line switch that the db can read and act on when it opens. I can drag a shortcut itself into an email, but Windows demands that the file be saved to disk and won't actually open it. So either idea seems to not be viable. Given how simple other suggested methods can be, I see no real benefit for the time that would be spent figuring this out, assuming it is doable at all.