open access form from outlook

[Cynthia]

I am sending the user an email from my form. Is there a way to pass
something to the user through the email so they can click on it to open the
form on the correct record?

I have tried a few things that work on the run command, but when I use
outlook it does not work. I'm not sure if it is virus protection stopping it
or what.

Thank you in advance for any help you can provide.
Cynthia

 

[Klatuu]

No, that will not work. You Access application which contains the form and
the data is running on your computer.

 

[Cynthia]

I have the access application and form on the server. If a user types the
items in the cmd run prompt it will open the db and form, but not from the
email.

 

[Klatuu]

Even if all the e-mail receipients are on your network and allowed to use the
application, it may be a challenge. You may try using a shell command to
open the application. You would have to create a parameter to direct the
user to the correct record and add code to your applicaton to read and use
the parameter.

There is no easy straightforward way to do this.

One other thing, if the application is to be used only for this function, it
would not hurt to put the application on the server, but in normal practice,
each user should have a copy of the application on their own computer.

 

[Cynthia]

Thank you for your help. I did get a shell command to work. It opened the
application and passed the parameter. My problem is that it does not work
through the outlook email. It works through my home email. Outlook must be
stripping out the code thinking it is a virus.
If anyone knows a better approach any help would be appreciated. I am using
this db for support problems.
User opens db from their desk top to post problem which is then emailed to
my group. Support answers problem which sends email back to user giving
ticket number
Would like the user to be able to pick something in the email that will take
them directly to that ticket in the access db. This is where my hangup is.
It will be tough getting the user to take the time to do 3 steps in place of
one. Open Email, Open DB, Select correct Ticket.
Thank you again,
Cynthia

 

[Klatuu]

You need to talk to your Exchange administrator and see how your code can be
transmitted through the email at work.

 

[Cynthia]

Thank you, I give that route a try

You need to talk to your Exchange administrator and see how your code can be
transmitted through the email at work.

 

[Cynthia]

Thank you again. I finally got it to work for me.