Access Report to Excel format

[mar_t]

My code below works perfectly. I select a client in my combo box and click the command button and it will open the report with all the fields I wanted. Now, I want to export the report to Excel format based on the combo box value but there is now "WhereCondition" in DoCmd.Outputto... Any tips and codes are greatly appreciated.

DoCmd.OpenReport "ClientReport", acViewPreview, , "[Client]= '" & Me.Combo0 & "'"

[kennejd]

I'm on Access 2007, but I remember there's an easy way to export to Excel from the print preview mode of a report....here's a link that shows you how: http://www.howtogeek.com/howto/micro...l-spreadsheet/

If you want a more automated method, you could create a separate query that uses your desired criteria....then use your transferspreadsheet code.

[mar_t]

Kennejd,
Do you have sample mdb file or vba codes perhaps that you could share? Don't know where to place the "WhereCondition".

[kennejd]

When you start typing your DoCmd.OpenReport method, the syntax of the method will appear (intellisense)...and you should be able to see where to put your 'Where Condition'....should be the 3rd argument.