Export from a form

[Ryan Tisserand]

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?

 

[Ryan Tisserand]

Nevermind, I figured it out. I guess it helps to keep reading the help
files!!!
This was my solution
DoCmd.RunCommand acCmdExport

 

[Klatuu]

FYI, DoMenuItem is an outdated method only available for backward compatibiity.