Export from a form

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

Guest

I know there are several ways to programatically export, like
docmd.transferspreadsheet, but I want to export data from a form. I however
do not want the file button available to my users. I thought this might work
DoCmd.DoMenuItem , acfilemenu, acExport, , acMenuVer70
but it did not. Basically all I want to do is have a command button act
like what happens when you click file, export. I want the user to click the
button, and then select the location and the format to export to. Am I on
the correct track with the DoMenuItem?
 
Nevermind, I figured it out. I guess it helps to keep reading the help
files!!!
This was my solution
DoCmd.RunCommand acCmdExport
 
Back
Top