I am looking for a Access macro to save query form output through a button. Thanks in advance.
I am looking for a Access macro to save query form output through a button. Thanks in advance.
What do you mean by 'save query form output'? The data is already in table. Do you want to open a report or export the data?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I want to export the data through a button.
The data in table is query form output. Hope this is clear.
Export to where? Excel? PDF? Word? CSV?
There are several ways to accomplish.
Use the Import/Export wizard.
Report open in PrintPreview, right click on the report > Export > choose.
Use code (macro or VBA) with TranferSpreadsheet or OutPutTo methods.
Other options involve advanced VBA code.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Export to Excel. I need a VBA button to accomplish this task.
Explore the referenced methods. There are many examples available. Google or search this forum.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.