Access VBA question
-
After converting my app from MSOffice 97 to MSOffice 2002 i get an error message 3021 "No current record" when opening a report. The attached query runs fine with no errors. The report opens after a few dozen 3021 errors with a few readable records and the rest #Fout (or #Error which means the same). Anyone? Grtz, Guus
-
After converting my app from MSOffice 97 to MSOffice 2002 i get an error message 3021 "No current record" when opening a report. The attached query runs fine with no errors. The report opens after a few dozen 3021 errors with a few readable records and the rest #Fout (or #Error which means the same). Anyone? Grtz, Guus
First you have to tell us whether your app is a Word Macro, Excel Macro, Access Project, VB or something else. If they are office application (especially Access), there has been major changes on the methods from Office97 to OfficeXP and most likely you have to debug and rewrite your application. I had to do this for many Word Macros and Access Projects. If you're lucky, you only need to make a minor modification. Good luck! :) Edbert P. Sydney, Australia. [EDIT]Doh! :doh: I didn't read the title. :-O Yes, you have to debug and rewrite your Access application.[/EDIT]
-
First you have to tell us whether your app is a Word Macro, Excel Macro, Access Project, VB or something else. If they are office application (especially Access), there has been major changes on the methods from Office97 to OfficeXP and most likely you have to debug and rewrite your application. I had to do this for many Word Macros and Access Projects. If you're lucky, you only need to make a minor modification. Good luck! :) Edbert P. Sydney, Australia. [EDIT]Doh! :doh: I didn't read the title. :-O Yes, you have to debug and rewrite your Access application.[/EDIT]