Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
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
|Word 2016 - Spelling/Grammar Check - Inconsistent behavior upon completion||7||40|
|Aceess 2016 - Variable Data Fields?||12||44|
|Very interesting Access query problem.||13||43|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!