Hello
I've been given the task of migrating an old access database which was originally written in access97 but runs now in client PC's using access 2003. I'm not sure if whoever 'converted' it to 2003 made any form/code changes. My plan is to migrate it to 2007 and 2010 (we have mixed client PC's) but some forms, when opened in access 2007, just appear as a white blank page. They work fine on access 2003 but nothing in any newer version. I thought that all the versions use the same VB code but after having a search on the web and reading this I've learned about the changes:
http://allenbrowne.com/Access2007.html
One form in particular opens fine when the user selects the option to essentially add a new record. When they select the option to view/edit an existing record, which uses the same form but with criteria set to ID_Number = 'whatever number' all they get is a blank page.
There is quite a lot of VB code behind this form, disabling certain fields depending on values for example, so I'll have to trawl through it but is there anything I should be looking out for?
I've been given the task of migrating an old access database which was originally written in access97 but runs now in client PC's using access 2003. I'm not sure if whoever 'converted' it to 2003 made any form/code changes. My plan is to migrate it to 2007 and 2010 (we have mixed client PC's) but some forms, when opened in access 2007, just appear as a white blank page. They work fine on access 2003 but nothing in any newer version. I thought that all the versions use the same VB code but after having a search on the web and reading this I've learned about the changes:
http://allenbrowne.com/Access2007.html
One form in particular opens fine when the user selects the option to essentially add a new record. When they select the option to view/edit an existing record, which uses the same form but with criteria set to ID_Number = 'whatever number' all they get is a blank page.
There is quite a lot of VB code behind this form, disabling certain fields depending on values for example, so I'll have to trawl through it but is there anything I should be looking out for?