Search results

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

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

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

I've been stuck on one small item for awhile and it's driviing me nuts. In short, I want to run a delete query in VBA to delete records containing a billing month that's greater that a precalculated current month. The source data from another system has the dates in text format, shown as...

Hi, not sure if this is a Form or Query issue. I'm using Access 2003 and I have several processes that run off a main form. Data is being taken in, moved around, deleted based on dates, exported to Excel spreadsheet etc. I'd like to show metrics on the main form, if possible, that would populate...

Hi folks, new to the community hear. My name is Ed. I live in the States, about 40 miles south of Boston. I work for a large financial services firm based out of Boston, with my office being in historic Quincy, Massachusetts. My MS Access and VBA skills range from novice to intermediate...