storing a file location and opening the file from a form

[roosn]

Hi

a few years ago, i had a database that allowed me from a form to store a file location for a record on a form, so i any time i could access the record, and then open the file, usually a pdf, it wasnt stored as a hyperlink, but as long text

i made the mistake of not copying the files for safe keeping when i got a permanent position

i am now back self employed, i need to recreate the database to assist me

however, i cant find the information that helped me so far, and i'm 4 hours into searching for it

i have tried searching for 'common dialog' and 'common dialog api' as recommended on some threads but to no avail for what i need

would really appreciate it if somebody could point me in the right direction,

many thanks in advance

ps. i am using access 2013 64-bit on windows 8.1 64-bit, not by choice btw

 

[llkhoutx]

Search for "Access 2013 common dialog," it's widely available.

 

[JHB]

Maybe your old thread can help you.
http://www.access-programmers.co.uk/forums/showthread.php?t=167469

 

[roosn]

thank you for your replies

i've tried my 2009 post, the links there won't open with access 2013,

i've tried searching "Access 2013 common dialog", but to no avail other than being aware of the "PtrSafe" edit to the declaration.

i've tried "http://www.avenius.de/en/index.php?Products:IDBE_Tools", but the tool i need limits at access 2010

am i missing something?

rgds

 

[llkhoutx]

Take a look at the following:

http://http://vbadud.blogspot.com/2007/06/visual-basic-common-dialog.html

or

http://http://stackoverflow.com/questions/1091484/how-to-show-open-file-dialog-in-access-2007-vba