Search results

Attached is a dummy database with just the bare bones vba code that is causing the problem. Thanks for the help.

The query runs fine manually...I should mention that the SQL code for the query qBasic does not have the same SQL code as what is written in the QueryDefs portion of the vba code.

The jersey number is alpha numeric so that part should be ok. CurrentFolder is declared as a string with a drive path where the files should be exported. No error pops up when I run the code, but I added an msgbox at the beginning and end of the code and when that line of code is included...

I'm attempting to make your code work on a very basic level and then plan on expanding on it once I have it working. Right now it seems that I'm having an issue with the CurrentDb.QueryDefs line. Thank you in advance for any help. Dim rs as dao.recordset set rs =...

My issue is that the values in column A in excel (or in the 'Type' field in access) will change every month so I can't create a query that says group all "Type A" together then create report and export, because the criteria would need to be changed each month.

I am exporting from access to excel using the code below, but I'd like to edit the code so that it exports to excel for each original value in column A. For example, if column A contains the values "Type A", "Type B" and "Type C" then I'd like to export/save three different excel files (one for...