Exporting form and subform in one swoop

[rainman89]

Hi all,
ive been messing with the different output to excel functions in access, and want to keep it really simple, so i decided on the OutputTo function.

question is can i output both form and subform at once?

DoCmd.OutputTo acOutputForm, "frmDAR" &"frmDARSubform", acFormatXLS, , True

Not gonna do it!!

 

[boblarson]

Ray:

I don't think it's really possible to use the normal Access methods to do that. However, all is not lost as you can use the Excel Object Model to do the work. It's a little more work up front but you have more control over everything.

Check out my sample here, even though it isn't doing what you want, it may give you ideas. You would just think in recordsets and move through them.

http://www.access-programmers.co.uk/forums/showthread.php?t=125039&highlight=excel

 

[rainman89]

Bobbo,
Thanks again for your guidance!
i was hoping this would be a simple solution, because i dont want/need to spend a lot of time on it. we currently have our emps fill out excel files for review by the admin, was just gonna use them as a parallel to my new system while we test it. not a big deal though since they can just print their reports and turn them in. only thing that would be missing from the excel file is the user name, so ill just put that in the subform query that way its not a huge fix.
thanks again!