Prompt for Inserting OLE Objects

S

SCHNYDES

Good morning all.

I'm looking for some help in automating the inputting of an attachment into
my access database. Currently I am using Access 2000 format with Access 2003
with the newest Jet version. I have a form which serveral individuals are
using to make requests for technology enhancements and I'd like to add a
button so individuals can go out and grab a document from there drives and
insert it with their submission.

I have the table set up with a field for OLE objects, I think I'm on the
right path. Now all I need is the button on my form to prompt for file
insertion.

Anyone have any suggestions how I might be able to do this with a macro and
not with code? Or is there basic code that can be used for this that you
might have to share?

Thanks for the help.
 
Top