Problem with macros in Access 2000 on Windows XP

[Meg]

I am experiencing a problem with send object macro's in Access 2000
since my pc was upgraded to Windows XP. The macro runs but just stops
with no error. When this happens NO macro's will run in Access2000. I
must close Access2000 and re-open and then I can run the macro. This
happens even if I create a new macro, still can not run it until I
close out of Access and re-open....It's making me crazy....Any
Ideas????
Meg

 

['69 Camaro]

Hi, Meg.

The macro runs but just stops
with no error.

That's one of the problems with macros. There's no error handling. If you
convert this macro to VBA code with the wizard, error handling will be
included with the procedure, so you'll get an error message when something
goes wrong. To convert, select the macro in the Database Window, then
select Tools -> Macro -> Convert Macros To Visual Basic, then press the
"Convert" button.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.