Advance Browse for Folders Dialog

[DD]

Hi
Ok, i have loaded the appropriate code to call the Browse Save As
dialog box

I click a Btn from my Access form then the Dialog box appears i can
choose any file However i want to pass the file i choose to a text box
on the form
Any assistance would be great

DD

[JSand42737]

In article <14*************************@posting.google.com> ,
da**********@bigpond.com.au (DD) writes:

Hi
Ok, i have loaded the appropriate code to call the Browse Save As
dialog box

I click a Btn from my Access form then the Dialog box appears i can
choose any file However i want to pass the file i choose to a text box
on the form
Any assistance would be great

DD

David

If the function that you are using is called TestIt, then you can have some
code like this:

Private Sub cmdOpen_Click()
Dim strFile As String
strFile = TestIt
If Len(strFile) > 0 Then
Me!txtFile = strFile
End If
End Sub
--

Jon

www.applecore99.com - Access Tips and Tricks

[Uwe Range]

Try the Acces Web page:

http://www.mvps.org/access/api/api0001.htm

Hope that helps

Uwe

da**********@bigpond.com.au (DD) wrote in message news:<14*************************@posting.google.c om>...

Hi
Ok, i have loaded the appropriate code to call the Browse Save As
dialog box

I click a Btn from my Access form then the Dialog box appears i can
choose any file However i want to pass the file i choose to a text box
on the form
Any assistance would be great

DD

[David Neagle]

da**********@bigpond.com.au (DD) wrote in message news:<14*************************@posting.google.c om>...

Hi
Ok, i have loaded the appropriate code to call the Browse Save As
dialog box

I click a Btn from my Access form then the Dialog box appears i can
choose any file However i want to pass the file i choose to a text box
on the form
Any assistance would be great

DD

Behind the Btn that browses for the file put this code.

Me![YourTextBoxName]=(FunctionName that returns the string path, name
and extension of the file selected)

DN