Search results

Again you'll have to forgive me-I don't know how to write the code to do that. In all honesty, it's probably going to be easier to just create a form with 200+ buttons-one for each error. I had thought it would be fairly simple to run the SQL string, but apparently it's not. Thanks for the...

I apologize, but all I seem to return is the SQL string, not the recordset. Clearly I'm missing something, but I don't know what.

You'll have to forgive me-I'm not a VBA programmer and this project was passed on to me some time ago. So you're saying that I can't programmatically pass the SQL string into VBA and return the recordset? I have the SQL string listed in a table called DATA_SCRUB_SQL. There are 200+ SQL...

Hi Bob, That still gets me at the same point I'm at-the SQL field comes up in the query. I'd actually like the SQL to run and return a recordset rather than just showing me the SQL string. Thanks for the help though!

All, Some time ago I posted a question and received assistance (many thanks). However I need to tweak the code some. Here is what I have. Private Sub btnGetErr_Click() Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim strSQL As String strSQL = "SELECT SQL FROM DATA_SCRUB_SQL " &_ "WHERE...

I have a table populated with several thousand records-one field is a date field in the format of 5/5/2006. I have to change the data so that it is 5/05/2006 in order to import it into a SQL table. I'm sure there has to be an easy way to do it, but I can't come up with it. Changing the imput...

Hello, I'm working with an existing Access database trying to do some automation. Fair warning-I know very little about VBA-I usually work with SQL. The Access database has a table in it called Data_Scrub_SQL. There are 124 rows, one of the fields (called SQL) is a SQL query SELECT string...