S
sulemanzia
i have created a database with reports based on my queries. i have 3
buttons for viewing reports in the form.
1) reports all
2) reports not resolved
3) reports resolved
what i really want is if a user clicks on any of these 3 buttons it
should give an option to transfer the reports which are based on my
query to Excel spreadsheet. well i have succeeded in everything as for
one final part.
I have created a VB procedure which is this :
Private Sub reports_resolved_Click()
DoCmd.OutputTo acReport, "reports resolved", acFormatXLS
End Sub
This procedure works fine for all my buttons. it will export the report
to excel spreadsheet but the whole formatting is bad. the cell
formatting is not alligned properly. anyone please tell me a code
procedure to do something that when a user clicks on my button it
should transfer the spreadsheet in perfect formatting. this is my last
hope. Thanks alot guys.
buttons for viewing reports in the form.
1) reports all
2) reports not resolved
3) reports resolved
what i really want is if a user clicks on any of these 3 buttons it
should give an option to transfer the reports which are based on my
query to Excel spreadsheet. well i have succeeded in everything as for
one final part.
I have created a VB procedure which is this :
Private Sub reports_resolved_Click()
DoCmd.OutputTo acReport, "reports resolved", acFormatXLS
End Sub
This procedure works fine for all my buttons. it will export the report
to excel spreadsheet but the whole formatting is bad. the cell
formatting is not alligned properly. anyone please tell me a code
procedure to do something that when a user clicks on my button it
should transfer the spreadsheet in perfect formatting. this is my last
hope. Thanks alot guys.