browse for file and entering the file path in a table

  • Thread starter Thread starter sadat
  • Start date Start date
S

sadat

Hi.
I am using browse button and the address bar in the form for the first time.
I found the vba code from this webstie:
http://www.mvps.org/access/api/api0001.htm
I want to select any file using browse button and then populate the address
of the file to a table.
My problem is when I use the address bar and the browse button as "Unbound",
it works. But when i try to populate the table using the browse button and
address bar, it says: Run time error '424'. What I am doing wrong here?
Please guide me so that I can get rid of this problem.

Thanks and regards,
Sadat
 
Hi.
I am using browse button and the address bar in the form for the first time.
I found the vba code from this webstie:http://www.mvps.org/access/api/api0001.htm
I want to select any file using browse button and then populate the address
of the file to a table.
My problem is when I use the address bar and the browse button as "Unbound",
it works. But when i try to populate the table using the browse button and
address bar, it says: Run time error '424'. What I am doing wrong here?
Please guide me so that I can get rid of this problem.

Thanks and regards,
Sadat
Click to expand...

you need this part...
GetOpenFile(strDirectory, strTitle)

as in ...

Dim strMyFile As string ' somewhere to stuff your filename

strMyFile = GetOpenFile("C:\", "Pick a file, any file!")

You could also assign the value of GetOpenFile to a control on your
form...
Me.txtFileName = GetOpenFile("C:\", "Pick a file...")
 
Back
Top