Form Query for path & filename

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have some VBA code attached to a form that does some calcs then exports them as pre-named *.dbf files. Instead, I would like to query the user and allow him/her to specifiy his/her own path+filename. Does anyone have some already-existing code for this procedure that he/she would be willing to share? Thanks,

RichardA
 
Use the TransferDatabase action to export your query as a DBF file.

To let the user select a folder and file name, use the code in this link:
http://www.mvps.org/access/api/api0001.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

RichardA said:
I have some VBA code attached to a form that does some calcs then exports
Click to expand...
them as pre-named *.dbf files. Instead, I would like to query the user and
allow him/her to specifiy his/her own path+filename. Does anyone have some
already-existing code for this procedure that he/she would be willing to
share? Thanks,
 
Is this the most updated for Access 2002? Is it ADO specific, or does that not apply?

RichardA
 
Nothing Allen posted depends on ADO. TransferDatabase is provided by VBA,
and the API call has nothing to do with databases at all.
 
Back
Top