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
|Access 2010 db.Execute using dbFailOnError and dbSeeChanges||10||47|
|Most Consistent Performer||4||19|
|Excel VBA - reference a textbox on a userform using a variable dynamically||2||21|
|Excel "2016 error could not load some objects becuase they are not available on this machine.||7||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!