Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

RunApp Q for Anthony

Resolved · Medium Priority · Version 2007

Reply Fri 27 Jan 2012, 11:23Delegate Timothy said...

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

For upcoming training course dates see: Pricing & availability

Reply Fri 27 Jan 2012, 13:46Trainer Anthony said...

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

Reply Mon 30 Jan 2012, 17:21Delegate Timothy said...

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 articles

· Keeping Your Access Database Updated
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Why a Microsoft Access Course Could Change the Way You Do Business
· MS Access can promote teamwork
· Making Figures Talk For Themselves Thanks To Access

Please browse our web site to find out more about
training for microsoft access and other Microsoft training courses.

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips