Talk About Network

Google





Software > Access Data Access Pages > Re: OnClick Hel...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 5 of 7 Topic 1715 of 1851
Post > Topic >>

Re: OnClick Help

by =?Utf-8?B?UEhpc2F3?= <PHisaw@[EMAIL PROTECTED] > May 7, 2008 at 09:05 AM

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
> : > :
> : > :
> : >
> : >
> : > 
> 
> 
>
 




 7 Posts in Topic:
OnClick Help
"Pam" <pamno  2008-04-29 11:27:33 
Re: OnClick Help
"PaulD" <nos  2008-04-30 14:15:55 
Re: OnClick Help
=?Utf-8?B?UEhpc2F3?= <  2008-05-06 11:50:02 
Re: OnClick Help
"PaulD" <nos  2008-05-07 10:45:08 
Re: OnClick Help
=?Utf-8?B?UEhpc2F3?= <  2008-05-07 09:05:01 
Re: OnClick Help
"PaulD" <nos  2008-05-07 17:18:13 
Re: OnClick Help
=?Utf-8?B?UEhpc2F3?= <  2008-05-08 11:35:04 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Wed Jan 7 17:39:40 PST 2009.