Opening files from listbox

[prometro]

Hi, I did database where is a Form with Listbox.
In this listbox there are names of files (*.doc, *.xls) and some more information about each file.
My idea is when Iam creating new data record that i put 1) name of file, 2)some information about and then I click on button "explorer" where I can set up the path (eg. c:\abc\document.doc). Everything will be writed to table.
I find some explorer on this forum ( http://www.access-programmers.co.uk/forums/showthread.php?t=97787 ) but I have to modificate it and Iam not understand code well so I have to write every path by hand meantime.

Next problem is when somebody from net group want to run and use my database from my computer, the file path (c:\abc\document.doc) is incorrect for him.
The way how to solve it is to select relative path "\abc\document.doc" - this is the next thing I dont know how to write in code.
If somebody knows how to help me I will be very happy.
Thank you
Jirka

 

[Robert88]

Hi prometro

http://www.access-programmers.co.uk/forums/showthread.php?t=101435

This will help with getting folder path and file info into table, hope this reference helps?

Robert88

 

[prometro]

Thank you very much for your reply! After long time I met my old friend, which is now professional programmer and he helped me with your code and with other problems (I never studied code before, everything i tried to do with macro). Now it is perfect application for me - when i finish all, I will place it into this forum for look-in. Thank you and bye j.

 

[Robert88]

Hi prometro,

I hope the link helped. Good to hear you got it going. I find there is plenty of helpful people on this site and in turn I try and help as much as possible as I myself am learning. This site is fantastic for learning.

Be good to see you final product.

Robert88