Running Access 2003 programs in in Access 2007 and Windows 7

  • Follow


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. 


0
Reply Utf 2/16/2010 9:29:02 PM

MamaGrubb wrote:

> Clients for whom I have developedAccess 2003 programs ...
> 1.	In Access 2003 ...
> 2.	My forms are not all working as they should ...

And how is anything of your Access macros have to do with Outlook which is
the topic of THIS newsgroup?  Ask in a newsgroup that discusses MS Access.
0
Reply VanguardLH 2/17/2010 1:31:56 AM


1 Replies
431 Views

(page loaded in 0.043 seconds)

Similiar Articles:
















7/26/2012 6:23:11 PM


Reply: