I currently have the attached 2003 code that is running without errors. However I would like to adjust it as necessary to bring it up to 2010 standards. i.e. Like the code above.
Dim DB_nnn As Database Set DB_nnn = CurrentDb Dim RS_00_PROCESS_CTRL_nnn As DAO.Recordset Dim CMD_00_PROCESS_CTRL_nnn As String [CMD_00_PROCESS_CTRL_nnn] = "SELECT Key_1, Field_1 " & _ "FROM 00_PROCESS_CTRL " & _ "WHERE Key_1 = '" & PARM_nnn & "';" Set RS_00_PROCESS_CTRL_nnn = DB_nnn.OpenRecordset([CMD_00_PROCESS_CTRL_nnn], dbOpenDynaset) [WRK_PRIMARY_DB_LOCATION_nnn] = RS_00_PROCESS_CTRL_nnn!Field_1 RS_00_PROCESS_CTRL_nnn.Close Set RS_00_PROCESS_CTRL_nnn = Nothing DB_nnn.Close Set DB_nnn = Nothing
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.