I’m trying to export data from a access form into an excel sheet when it is clicked by a particular button... but the VB code I’m using for the button will not work.
Here is my current code:
Private Sub Command12_Click()
DoCmd.OutputTo acOutputForm, "frmExport", acFormatXLSX, "h:\mydocu~1\exports\F_assignments.xlsx", True
Can somebody please correct my code for me?
I have attached a image of my form as well that may help