Search results

I have created a parameter query but it does not show up when I try to connect using MailMerge in a Word Document. I am using Access and Word 2010

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...

Anyone else have suggestions?

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...

Hello Looking forward to learning more about access database and its unique set of tools :banghead: