|  | Command Line Switch in a hyperlink? | | |
| | | Suzie H. |  |
|  Posted: Sun Aug 31, 2008 7:46 pm Post subject: Command Line Switch in a hyperlink? |  |
I have a submit button on my form that will send an Outlook email to a
person. I want the email to contain a link that will open the
database and pass the record ID back to access so I can open a form to
that record.
I know that I can use the /CMD switch to pass the record ID so that it
can be retrieved using the Command() function.
I have been successful in using the Start --> Run... box to manually
open the database using this syntax:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:
\Documents and Settings\User\Desktop\MyDatabase.mdb" /cmd 27
where the number 27 is the value I want to pass.
What is the syntax of a hyperlink in an email to do the same thing?
I am using:
<file://C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE C:
\Documents and Settings\User\Desktop\MyDatabase.mdb /cmd 27>
When I click on it I get a Can not find file error message.
Help!
Suzie H. |
| |
| | | Wayne-I-M | |
| | Posted: Sun Aug 31, 2008 7:46 pm Post subject: RE: Command Line Switch in a hyperlink? | |
| |  | |
/"X" cmd 27
"Without the quotes"
You may be better using an autoexec macro to the task - up to you though
--
Wayne
Manchester, England.
"Suzie H." wrote:
| Quote: | I have a submit button on my form that will send an Outlook email to a
person. I want the email to contain a link that will open the
database and pass the record ID back to access so I can open a form to
that record.
I know that I can use the /CMD switch to pass the record ID so that it
can be retrieved using the Command() function.
I have been successful in using the Start --> Run... box to manually
open the database using this syntax:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:
\Documents and Settings\User\Desktop\MyDatabase.mdb" /cmd 27
where the number 27 is the value I want to pass.
What is the syntax of a hyperlink in an email to do the same thing?
I am using:
LINK\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE C:
\Documents and Settings\User\Desktop\MyDatabase.mdb /cmd 27
When I click on it I get a Can not find file error message.
Help!
Suzie H.
|
|
| |
| | | Suzie H. | |
| | Posted: Mon Sep 01, 2008 3:11 am Post subject: Re: Command Line Switch in a hyperlink? | |
| | | |
On Aug 31, 4:01 pm, Wayne-I-M <Wayn...@discussions.microsoft.com>
wrote:
| Quote: | /"X" cmd 27
"Without the quotes"
You may be better using an autoexec macro to the task - up to you though
--
Wayne
Manchester, England.
"Suzie H." wrote:
I have a submit button on my form that will send an Outlook email to a
person. I want the email to contain a link that will open the
database and pass the record ID back to access so I can open a form to
that record.
I know that I can use the /CMD switch to pass the record ID so that it
can be retrieved using the Command() function.
I have been successful in using the Start --> Run... box to manually
open the database using this syntax:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:
\Documents and Settings\User\Desktop\MyDatabase.mdb" /cmd 27
where the number 27 is the value I want to pass.
What is the syntax of a hyperlink in an email to do the same thing?
I am using:
LINK\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE C:
\Documents and Settings\User\Desktop\MyDatabase.mdb /cmd 27
When I click on it I get a Can not find file error message.
Help!
Suzie H.
|
Thank you Wayne.
I understand, but even with a macro, i would need to pass a parameter
so the correct record would open. My main problem is simply with the
hyperlink syntax. Even when I use your suggestion, it still does not
work. I am stumped.
What is the correct syntax for an email hyperlink to open Access and
pass a value?
Suzie H. |
| |
| | | Wayne-I-M | |
| | Posted: Mon Sep 01, 2008 5:45 am Post subject: Re: Command Line Switch in a hyperlink? | |
| | | |
The cmd switch goes "at the end of the path"
There is lots of samples available (google) - it depends on what you need to
do after the app is opened.
X/cmd ......ect
a few tips here
LINK
Sorry no time this week - hope someone will jump in to the thread - off to
Rome in about 10 mins
--
Wayne
Manchester, England.
"Suzie H." wrote:
| Quote: | On Aug 31, 4:01 pm, Wayne-I-M <Wayn...@discussions.microsoft.com
wrote:
/"X" cmd 27
"Without the quotes"
You may be better using an autoexec macro to the task - up to you though
--
Wayne
Manchester, England.
"Suzie H." wrote:
I have a submit button on my form that will send an Outlook email to a
person. I want the email to contain a link that will open the
database and pass the record ID back to access so I can open a form to
that record.
I know that I can use the /CMD switch to pass the record ID so that it
can be retrieved using the Command() function.
I have been successful in using the Start --> Run... box to manually
open the database using this syntax:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:
\Documents and Settings\User\Desktop\MyDatabase.mdb" /cmd 27
where the number 27 is the value I want to pass.
What is the syntax of a hyperlink in an email to do the same thing?
I am using:
LINK\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE C:
\Documents and Settings\User\Desktop\MyDatabase.mdb /cmd 27
When I click on it I get a Can not find file error message.
Help!
Suzie H.
Thank you Wayne.
I understand, but even with a macro, i would need to pass a parameter
so the correct record would open. My main problem is simply with the
hyperlink syntax. Even when I use your suggestion, it still does not
work. I am stumped.
What is the correct syntax for an email hyperlink to open Access and
pass a value?
Suzie H.
|
|
| |
| | | Suzie H. | |
| | Posted: Mon Sep 01, 2008 2:27 pm Post subject: Re: Command Line Switch in a hyperlink? | |
| | | |
On Sep 1, 3:45 am, Wayne-I-M <Wayn...@discussions.microsoft.com>
wrote:
| Quote: | The cmd switch goes "at the end of the path"
There is lots of samples available (google) - it depends on what you need to
do after the app is opened.
X/cmd ......ect
a few tips here
LINK
Sorry no time this week - hope someone will jump in to the thread - off to
Rome in about 10 mins
--
Wayne
Manchester, England.
"Suzie H." wrote:
On Aug 31, 4:01 pm, Wayne-I-M <Wayn...@discussions.microsoft.com
wrote:
/"X" cmd 27
"Without the quotes"
You may be better using an autoexec macro to the task - up to you though
--
Wayne
Manchester, England.
"Suzie H." wrote:
I have a submit button on my form that will send an Outlook email to a
person. I want the email to contain a link that will open the
database and pass the record ID back to access so I can open a form to
that record.
I know that I can use the /CMD switch to pass the record ID so that it
can be retrieved using the Command() function.
I have been successful in using the Start --> Run... box to manually
open the database using this syntax:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:
\Documents and Settings\User\Desktop\MyDatabase.mdb" /cmd 27
where the number 27 is the value I want to pass.
What is the syntax of a hyperlink in an email to do the same thing?
I am using:
LINK\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE C:
\Documents and Settings\User\Desktop\MyDatabase.mdb /cmd 27
When I click on it I get a Can not find file error message.
Help!
Suzie H.
Thank you Wayne.
I understand, but even with a macro, i would need to pass a parameter
so the correct record would open. My main problem is simply with the
hyperlink syntax. Even when I use your suggestion, it still does not
work. I am stumped.
What is the correct syntax for an email hyperlink to open Access and
pass a value?
Suzie H.
|
Again, thank you Wayne for your reply!
My main problem is not with using the Command Line switches, but with
creating an **Email Hyperlink** that uses the command line so that it
can be clicked, Access opens and the software can read the /cmd value.
Suzie H. |
| |
|
|
