I am trying to now connect my form to vba through a button. What I hope to do is click on a button and have the query transfered into a prexisting sheet on a prexisting workbook. However when I click on the button I get an error saying Too few parameters, Expected 9. does this have to do with my...
Thanks for the advice The_Doc_Man. Just want to add that I do regular exports from access to excel and as a result I use a form to automate the transfer into excel. I want to be at the point where I can just click on a button and transfer the spreadsheet. Would transferspreadsheet.cmd work better?
Hi All I am trying to export a query to an pre-existing spreadsheet. I am new to VBA and when I implement the following code nothing happened. Please let me know what I am doing wrong Thanks!
Option Compare Database
Public Function Sheet(strTQName As String, strSheetName As String)
Dim...