OnClick Help

OnClick Help

Post by Pam » Thu, 01 May 2008 01:27:33


Can anyone please tell me how to set up a command button on a data page to
open pdf in file to match what is listed in a field?
Pam
 
 
 

OnClick Help

Post by Paul » Fri, 02 May 2008 03:15:55

Create your command button, lets assume its name is btnPDF
then in the script editor you should have something like this for the
onclick event
<script language=vbscript for=btnPDF event=onclick
<!--
dim objShell
dim myFile
set objShell = CreateObject("Shell.Application")
myFile = yourfield.value 'yourfield value must be a full path and valid
filename
objShell.ShellExecute myFile, "", "", "open", 1
set objShell = Nothing
-->
</script>

Paul D



: Can anyone please tell me how to set up a command button on a data page to
: open pdf in file to match what is listed in a field?
: Pam
:
:

 
 
 

OnClick Help

Post by UEhpc2F » Thu, 08 May 2008 03:50:02

Paul D,

Thank you so much for your reply. I entered the code as you have it,
substituting yourfield.value for ItemNumber.value and received the following
error:

An error has occurred in the script on this page.
Line 181
Char: 1
Error: permission denied
Code: 0

When I go to line 181, it is this line "objShell.ShellExecute myFile, "",
"", "open", 1"

Do you know what the problem could be?

I have worked on trying to set up a command button or at least an
alternative for quite some time and believe this is the only thing holding up
posting dap for other users. Your time and help are greatly appreciated.
Thank you again,
Pam
 
 
 

OnClick Help

Post by Paul » Thu, 08 May 2008 23:45:08

I'm not sure exactly what could be the issue but here is a suggestions to
try.
When I tested this, I copied a pdf file I had to my C drive. My test code
had
myFile = "C:\test.pdf"
With the line above, when I ran the script it opened the file using Adobe
reader (the default app associated with .pdf files)
I would suggest you try something similar and see if it works and post back.
Paul D



: Paul D,
:
: Thank you so much for your reply. I entered the code as you have it,
: substituting yourfield.value for ItemNumber.value and received the
following
: error:
:
: An error has occurred in the script on this page.
: Line 181
: Char: 1
: Error: permission denied
: Code: 0
:
: When I go to line 181, it is this line "objShell.ShellExecute myFile, "",
: "", "open", 1"
:
: Do you know what the problem could be?
:
: I have worked on trying to set up a command button or at least an
: alternative for quite some time and believe this is the only thing holding
up
: posting dap for other users. Your time and help are greatly appreciated.
: Thank you again,
: Pam
:
:

:
: > Create your command button, lets assume its name is btnPDF
: > then in the script editor you should have something like this for the
: > onclick event
: > <script language=vbscript for=btnPDF event=onclick
: > <!--
: > dim objShell
: > dim myFile
: > set objShell = CreateObject("Shell.Application")
: > myFile = yourfield.value 'yourfield value must be a full path and valid
: > filename
: > objShell.ShellExecute myFile, "", "", "open", 1
: > set objShell = Nothing
: > -->
: > </script>
: >
: > Paul D
: >


: > : Can anyone please tell me how to set up a command button on a data
page to
: > : open pdf in file to match what is listed in a field?
: > : Pam
: > :
: > :
: >
: >
: >
 
 
 

OnClick Help

Post by UEhpc2F » Fri, 09 May 2008 01:05:01

Paul,

I changed the line "myFile = fieldname.value to myFile = "c:\bjm.pdf"
and I still get error msg "permission denied". Do you have any other
suggestions?

Thanks,
Pam
 
 
 

OnClick Help

Post by Paul » Fri, 09 May 2008 06:18:13

It appears permission denied is due to a security setting in Internet
Explorer. I have all my DAPs on a local server and have added that server
to a trusted zone so I am able to use shellexecute. If your DAPs are in the
default level security, then shellexecute is not allowed. Check out the
link below for a bit more information

http://www.yqcomputer.com/

Paul D



: Paul,
:
: I changed the line "myFile = fieldname.value to myFile = "c:\bjm.pdf"
: and I still get error msg "permission denied". Do you have any other
: suggestions?
:
: Thanks,
: Pam
:

:
: > I'm not sure exactly what could be the issue but here is a suggestions
to
: > try.
: > When I tested this, I copied a pdf file I had to my C drive. My test
code
: > had
: > myFile = "C:\test.pdf"
: > With the line above, when I ran the script it opened the file using
Adobe
: > reader (the default app associated with .pdf files)
: > I would suggest you try something similar and see if it works and post
back.
: > Paul D
: >


: > : Paul D,
: > :
: > : Thank you so much for your reply. I entered the code as you have it,
: > : substituting yourfield.value for ItemNumber.value and received the
: > following
: > : error:
: > :
: > : An error has occurred in the script on this page.
: > : Line 181
: > : Char: 1
: > : Error: permission denied
: > : Code: 0
: > :
: > : When I go to line 181, it is this line "objShell.ShellExecute myFile,
"",
: > : "", "open", 1"
: > :
: > : Do you know what the problem could be?
: > :
: > : I have worked on trying to set up a command button or at least an
: > : alternative for quite some time and believe this is the only thing
holding
: > up
: > : posting dap for other users. Your time and help are greatly
appreciated.
: > : Thank you again,
: > : Pam
: > :
: > :

: > :
: > : > Create your command button, lets assume its name is btnPDF
: > : > then in the script editor you should have something like this for
the
: > : > onclick event
: > : > <script language=vbscript for=btnPDF event=onclick
: > : > <!--
: > : > dim objShell
: > : > dim myFile
: > : > set objShell = CreateObject("Shell.Application")
: > : > myFile = yourfield.value 'yourfield value must be a full path and
valid
: > : > filename
: > : > objShell.ShellExecute myFile, "", "", "open", 1
: > : > set objShell = Nothing
: > : > -->
: > : > </script>
: > : >
: > : > Paul D
: > : >


: > : > : Can anyone please tell me how to set up a command button on a data
: > page to
: > : > : open pdf in file to match what is listed in a field?
: > : > : Pam
: > : > :
: > : > :
: > : >
: > : >
: > : >
: >
: >
: >
 
 
 

OnClick Help

Post by UEhpc2F » Sat, 10 May 2008 03:35:04

hanks, Paul, for your time and help. I looked at the link and did some more
research, but still have errors. Will try something at a later date.

Thanks again,

Pam

"PaulD" wrote: