GetFileName / OpenFileName with a twist

[foxhound]

Hello,

I have a form called "frm_ChooseFileToSend" with a command button: cmd_getfile and a text box: txt_filetosend. I want to click the command button which will bring up the openfilename box where I can browse for a file (might be .xls, .pdf, .txt, or any other possible) then select that file. Once selected the complete path including file name and extension will be placed in the text box.

Any suggestions?

Foxhound

 

[SydneyGeek]

I don't have Access on this machine so can't check, but look for a GetFileOpen method. There is one in Excel. Once you run it you present the user with the standard Open dialog box. They can navigate and select files at will.

You will then need to capture the string and set it to the TextBox.
Something like:
MyPath=GetFileOpen(......) 'Check the syntax on this one in the Help files
[TextBox1]=MyPath

HTH

Denis