By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,574 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Advance Browse for Folders Dialog

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.