Search results

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