Set Pathway

[DM - NPS]

I have a form with 2 unbound boxes called txtPlotLocn and txtDateTime. My
goal is to let the user push a command button that allows them to browse to
the location of 2 .dbf files (plotlocn and datetime). I then need the
pathway for each file stored in the unbound boxes above.

Any ideas on how to do this?

 

[Ken Snell [MVP]]

See the code at http://www.mvps.org/access/api/api0001.htm

You can use that code to get the file name and path, and then write the
result into the textbox on the form.

 

[DM - NPS]

Thanks, I had seen this code but I am pretty new to coding in access and
could not get it to work. I was hoping there was a simpler solution.

 

[Ken Snell [MVP]]

Post the code that you've tried and isn't working the way you want. We can
assist you with debugging it and making it work.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/