×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Open file dialogue to embed a file in an Access record

Open file dialogue to embed a file in an Access record

Open file dialogue to embed a file in an Access record

(OP)
First, the scenario...

An Access table with a field data type of "OLE object".  You can simulate what I'm trying to do by creating a simple table with a key field and an OLE field, then generating an autoform. This will be a form with a blank bound object frame. To embed a file (a scanned PDF document, for example) the user has to right click the frame, select "insert object", then select "create from file",then browse to the file, then click "OK", then click "link", then "display as icon, then "OK".  This is too many steps for the average user.  It's just too hard to miss a step, or otherwise screw it up.  As anyone with training experience can tell you, most people blank out after about step 4 of any complicated computer operation, especially if they aren't great with computers.

The (hopeful) solution...
Make a form with a command button that does all the extra steps besides browsing and selecting the file/object.  Most people can manage to pick the right file when presented with the open file dialogue.  The frame can be hidden if it is empty for the current record, thus further simplfying the display.

Does anyone know how to do this?

RE: Open file dialogue to embed a file in an Access record

(OP)
Heh, that took some searching, but I found it buried deep in the help.  For anyone interested, Use the [fieldname].Action = acOLEInsertObjDlg as the code for the button. You can specify linked, embedded, or either in the properties box on the bound object form control. I'm still working on the way you automate the "create new" or "create from file" choice. There doesn't seem to be a way.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources