How to use progress bar

[marianne]

not really.

[RuralGuy]

Private Sub exporting_click()
docmd.OutputTo acOutputQuery ,"Accounts",acformatxls,"C:\Account.xls",true
End Sub

this is as simple as it can get. I am just wondering where to insert the progressbar coding.

As long as this is the method you are using to export the data, no ProgressBar will help because it will never have any CPU time to update.

[marianne]

so what would be your suggestion so I can use the progressbar.

[RuralGuy]

Can you try this where you are now to see if there is any difference in the time taken?

Private Sub exporting_click()
   docmd.OutputTo acOutputQuery ,"Accounts",acformatxls,"C:\Account.xls",False
End Sub

[RuralGuy]

Have you looked into the TransferSpreadsheet Method yet? It can export.
Something like:
DoCmd.TransferSpreadsheet acExport,,"Accounts,"C:\Account.xls"