runapp q anthony

Forum home » Delegate support and help forum » Microsoft Access Training and help » RunApp Q for Anthony

RunApp Q for Anthony

resolvedResolved · Medium Priority · Version 2007

Timothy has attended:
Access Advanced course

RunApp Q for Anthony

Hi Anthony, Having a problem with opening files using RunApp. Opening the .exe file is fine. But what I am trying to do is have a control button open the attachment file that is shown on a form using an 'onclick' event.
I have tried to use the DLookUp alongside the exe. file path when filling out the command line in macro builder but to no avail.
How do you specify that the file opened should be the one showing and no other. Also, and I'm pretty sure this is why it's not working, but how precisely do I write it out. Am I writing it in SQL or VB or something else. The finer points of using square brackets and paretheses still evades me.
Cheers
Tim

RE: RunApp Q for Anthony

Hi Timoty, thanks for your query. You are not only in wanting to do this. Have a look at this example, before you attempt anything with SQL or VBA:

http://www.hitechcoach.com/index.php?option=com_docman& ;task=doc_details&gid=7&Itemid=28

Anthony

RE: RunApp Q for Anthony

Thanks Anthony,
It's taken me a few hours but I think I've just about got my head around the code to write what I need.


 

Access tip:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

View all Access hints and tips


Server loaded in 0.06 secs.