Upload button in form to save pdf

[doobybug]

Hi,

I have 2 tables
tblCaseInfo
ScanNo - Integer



tblScans
ScanNo - Integer
Scan - OLE object

In a form I have an Upload button to be able to upload a pdf and save it in tblScans but with a link using ScanNo to be able to access it. Any ideas how I can code this? Haven't found much on forums

[June7]

You want to embed pdf in an attachment field? Embedding objects can really chew up Access 2GB limit. Why not leave the pdf external and just save the path in a text field?

[doobybug]

Good idea...didn't think about it...can you still use a browse window to get the path of the file so that it would be user friendly? If so how?

[Micron]

Check out msoFileDialogFilePicker
There is also a folder picker, but I'm not sure you want that unless you want to pick a folder to store a file in that you're outputting. Or you can pick a folder and append a file name to the location string and use the entire string as the location to that file, whereupon you store the path in a table as June7 suggested.
You can find tons of examples on how to use them if that link doesn't help you enough.