M
MamaGrubb
Clients for whom I have developedAccess 2003 programs are now starting to
move them into the Windows 2007 and Office 2007 environment – and there are
problems. Having been through this with previous such transitions I have made
sure the code is compiled before trying to use the application in Office
2007. My applications tend to be code heavy, and menu driven using the
Switchboard for user convenience.
Recently I acquired a new PC running Windows 7. The PC came with a trial
copy of Office 2007 installed. I did not use it and immediately uninstalled
it. Then I installed Office 2003 followed by an installation of Office 2007 –
following the tradition of installing versions of Office in the order in
which they came out.
Here are problems I have encountered:
1. In Access 2003 when I try to edit a code button on a form using the right
click “Build event†feature an automatic backup for the mdb starts up. I can
get into the code immediately by choosing “code “f from the view menu,
however.
2. My forms are not all working as they should in 2007. For instance, I have
a form that allows the user to select the records in a subform. The code
appears to run just fine – the last line in the code is a requery of the
subform – which runs without an error – but the form does not actually
requery – it sows empty without any records.
move them into the Windows 2007 and Office 2007 environment – and there are
problems. Having been through this with previous such transitions I have made
sure the code is compiled before trying to use the application in Office
2007. My applications tend to be code heavy, and menu driven using the
Switchboard for user convenience.
Recently I acquired a new PC running Windows 7. The PC came with a trial
copy of Office 2007 installed. I did not use it and immediately uninstalled
it. Then I installed Office 2003 followed by an installation of Office 2007 –
following the tradition of installing versions of Office in the order in
which they came out.
Here are problems I have encountered:
1. In Access 2003 when I try to edit a code button on a form using the right
click “Build event†feature an automatic backup for the mdb starts up. I can
get into the code immediately by choosing “code “f from the view menu,
however.
2. My forms are not all working as they should in 2007. For instance, I have
a form that allows the user to select the records in a subform. The code
appears to run just fine – the last line in the code is a requery of the
subform – which runs without an error – but the form does not actually
requery – it sows empty without any records.