Need to run or execute query to perform my vb code

  • Thread starter Thread starter g
  • Start date Start date
G

g

Hi Experts,

This button in my form should execute this on click event but the problem is
it is not happening. I'm thinking that I need to run this query first before
this event happen.
If I use OpenQuery it will open the query & I don't wan't that, I only need
to export to excel what ever the result of this query.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "MyQuery",
"C:\Temp\MyQuery", True

Thank you in advance
 
Works fine now, actually the only thing I did is recreate the code. Actually
the code is working fine but when I change the query it running that problem
started. Thanks for replying.
 
Back
Top