getting a file path name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there, (Window and Access XP)

I am in the process of building a form for my current application which is
bound to tblDetails. On this form, I would like to create a cmd button that
will allow the user to open windows explorer and find a specific picture
file.

Once they choose the file they are looking for, I would like to be able to
write that path to tblDetails in the ImagePath field.

From there, I can load the images on the form with the image control.

Not sure if this is very difficult to do or not. I am familiar with VBA and
SQL. Any solution you could provide would be greatly appriciated!!!

Thanks in advance!!
 
I just set this up this morning using the methods in Northwind sample
database that comes with Access. Take a look at the Employee form.
 
TT said:
Hi there, (Window and Access XP)

I am in the process of building a form for my current application which is
bound to tblDetails. On this form, I would like to create a cmd button that
will allow the user to open windows explorer and find a specific picture
file.

Once they choose the file they are looking for, I would like to be able to
write that path to tblDetails in the ImagePath field.

From there, I can load the images on the form with the image control.

Not sure if this is very difficult to do or not. I am familiar with VBA and
SQL. Any solution you could provide would be greatly appriciated!!!
Click to expand...


http://www.mvps.org/access/api/api0001.htm
is commonly accepted as the most reliable way to provide a
file browse capabilty in you app.

Don't be intimidated by the code, it can be used "out of the
box".
 
Thank you both for you responses. I'll try these solutions and see what I
can come up with! Thanks for your help!
 
I converted the code from the Northwinds example to my app and it worked
great. Thank you very much. The one thing that I tried to do was send my
app to another computer to try it out and the Application.FileDialog member
doesn't seem to be available.

Is this new with 2002 and if so, is there similar functionality that can be
used for previous versions of Access?

PS - I built the app in Access 2000 format.

Thanks again!
 
TT said:
I converted the code from the Northwinds example to my app and it worked
great. Thank you very much. The one thing that I tried to do was send my
app to another computer to try it out and the Application.FileDialog member
doesn't seem to be available.

Is this new with 2002 and if so, is there similar functionality that can be
used for previous versions of Access?
Click to expand...


That's one of the reasons why the mvps.org API approach is
the preferred way to do this.
 
Thank you Marshall,

I've changed my code and everything seems to be working.

Thanks again!

Todd
 
Where is that method show Marshall. This is all new to me also and if there
is a better way point me to it please. g
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

File Dialog in access 2007 1
Listbox Query Help 7
editing .txt with VBA - importing format question 1
Look @ Code how can I clear the image;looks like image control retaining the value that it had from 1
file dialog in access 2007 3
enter 'afterupdate' into form text boxes (I think) 1
Create a search path 2
Saving from clipboard into file from ms access 0

Back
Top