Recent content by edsac64

Hi Sean, thanks for the quick reply. Here's a synopsis of what I'm trying to accomplish. My database runs several processes performed throughout the course of the month, one of which is this "PreCutoff" process. This process spans over a three day period, similar to an accounting closing period...

Hello again, I think we're getting closer, but I'm still getting the number of query values and destination fields are not the same error message. Could it relate to the fact that I'm trying to pass a string variable that's not part of the Selected table to the table in the Insert statement? Do...

@Beetle - thanks for your response. Sorry about being so nebulous in my previous post. I've cleaned it up a bit and hopefully you can understand what I'm trying to accomplish.

Hi, Thanks Rookie. I seem to be running up against another issue. I'm now receiving an error stating that the number of query values and destination fields are not the same. I've tried to simplify the query and made some changes based on additional needs. Is this issue being cause by my...

Hi, I'm trying to get the following SQL code to run in VBA, but I'm receiving an error message stating "Query Input must contain at least one table or query" mySQL = "INSERT INTO tblUnbilled_PreCutoff_Counts ( LOB, [Import PreCutoff Count] ) " & _ "SELECT impUnbilled_PreCutoff_Temp.LOB...

Hi Bob, Once again, thanks! Unfortunately, I couldn't get your solution to work, so I ended up creating a macro and converting it to VBA. Here it is, in case someone can benefit from it. DoCmd.OutputTo acOutputTable, strTable, "ExcelWorkbook(*.xlsx)", strSourceFile, False, "", ...

Hi, Can someone please provide some badly needed assistance? I'm using Access 2010 and would like to transfer a table to Excel 2010 (.xlxs). I was using Access 2003 and was able to successfully transfer to older .xls formats. Using the .xlsx extension in the file name with the following...

A million thanks Bob! I see where my misguided intentions would have resulted in me reinventing the wheel! We will leave it as is and move forward, only using the SQL statements in VBA when needed for rarely used events.

Hi, I could really use some help here. I'm trying to tighten up a DB that has lots of queries that are fired in VBA by using some like this: strQuery = "the query to be run" DoCmd.OpenQuery strQuery I might be wrong, but this seems rather inefficient and I'd like to use more SQL statements...

Hi, is there a way to have both Access 2010 and 2003 exist peacefully on the same desktop. My company uses Office 2010, but my department has an Access 2003 application. As a result, I have to have A2003 on my desktop and use it quite frequently for this one application. I have some small...

Re: HELP-VBA SQL error! "Expected: Line number or label or statement or end of statem Thanks for your help so far. I've run into another wall at this point where I'm getting that nefarious Syntax error (comma) in query expression. In the message box that comes up, it seems to start after the...

Re: HELP-VBA SQL error! "Expected: Line number or label or statement or end of statem Thanks! That worked for the first line, but now I'm getting the same error for the second line. What are the conventions for using the line separators such as "_" and "& _" ? I'd love to compact the lines so...

HELP-VBA SQL error! "Expected: Line number or label or statement or end of statement" Hi, this one has got me going in circles. I created the query in design view and took the SQL code, but I just can't seem to get it cleared up! mySQL = "INSERT INTO tblUnbilled_BegMonth_ExcludedData (...

Thanks for the heads up on this. About an hour later: I'm so glad you pointed out that I wouldn't need the # marks. When I left them in and the code ran, it deleted everything from the table. Fortunately, I always create backup tables. I removed the # marks and it ran as expected. I am...

Thanks lagbolt. I ran across another suggestion. First, you need to refer to your variable as a variable outside the string, otherwise, Access VBA thinks its a string. Second, you need to surround date paramaters with the # sign. This is what ended up working: mySQL = "DELETE * FROM...