open attachments using Button - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

open attachments using Button

Carol Herriot

5 years ago

I have taken Open Other Programs + Images Seminars.
I want to open attachments using a Button rather than from a subform within the Form.  One attachment is a .pdf (C:\Attachments) and the other a video (http:\\www .....)

Please see screen shots of how I am currently opening them.  I wish to replace these with Buttons.

I tried using a button and the Shell Function, but got this error (see screen shot)

thanks for your help.  Much appreciated.

	Carol Herriot OP @Reply 5 years ago
trying to upload screen shots

	Carol Herriot OP @Reply 5 years ago

	Adam Schwanz @Reply 5 years ago
My eyes aren't quite what they used to be... can you upload those as seperate images, and crop them before hand so I can read what you have there?

	Alex Hedley @Reply 5 years ago
ShellEx needs the extra lib info in the same module

	Richard Rost @Reply 5 years ago
Yeah I can't read that screen shot either. Upload the full resolution image so it's readable. Basically though, like Alex said, if you don't have the ShellExec function/sub available, it's not going to work. It has to be declared in a global module. It's all explained in the video. Watch again.

	Carol Herriot OP @Reply 5 years ago
My apologies. I didn't know how small it was until it was posted.

	Carol Herriot OP @Reply 5 years ago

	Carol Herriot OP @Reply 5 years ago

	Carol Herriot OP @Reply 5 years ago

	Carol Herriot OP @Reply 5 years ago

	Richard Rost @Reply 5 years ago
Yep. I can see 'em now. Read my comment above. Where's ShellExec declared?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View