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.eggheadcafe.com/forumarchives/scriptingVisualBasicscript/Sep2005/post23662194.asp
Paul D
"PHisaw" <PHisaw@[EMAIL PROTECTED]
> wrote in message
news:2A365CF4-8040-4206-9CD0-E7EAF34949F7@[EMAIL PROTECTED]
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
:
: "PaulD" wrote:
:
: > 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
: >
: > "PHisaw" <PHisaw@[EMAIL PROTECTED]
> wrote in message
: > news:C1F11075-AB74-4E37-9935-C0A8A873D348@[EMAIL PROTECTED]
> : 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
: > :
: > :
: > : "PaulD" wrote:
: > :
: > : > 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
: > : >
: > : > "Pam" <pamnospam@[EMAIL PROTECTED]
> wrote in message
: > : > news:O6cyvThqIHA.4476@[EMAIL PROTECTED]
> : > : 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
: > : > :
: > : > :
: > : >
: > : >
: > : >
: >
: >
: >
|
