I am in the process of converting an Access 2003 Application to 2010.
Environment OS is Windows Pro 7. 64 Bit, Office 2010 Pro.
I have received from you the following 2010 code for DB management that I am using to replace the existing 2003 code.
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
Set RS_00_PROCESS_CTRL_nnn = Nothing
Set DB_nnn = Nothing
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.
This Event creates a MS Excel Workbook containing a Worksheet for each Table being exported.
Could you please advise what needs to be changed?