This is a quick and easy one for someone (I hope!)
I'm allowing the user to export some data from access via a button on a form. All I want to do when the button is clicked is display the "Save As" file box that all Microsoft products display. The the user can select the path and filename and see if a filename exists etc.
In excel I write this..
' display the open file dialogue box
filt = "All files (*.*),*.*" & _
"Excel files (*.xls),*.xls," & _
"Text Files (*.txt),*.txt," & _
"Comma Separated files (*.csv),*.csv,"
filterindex = 5
Title = "Select output file"
fullfile = Application.GetOpenFilename(filefilter:=filt, _
which displays the box for the user.
How do i do this in access? is it the same? Do I have to reference anything?