Problem with macros in Access 2000 on Windows XP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Meg - 29 Nov 2006 00:45 GMT

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

Reply to this Message

'69 Camaro - 29 Nov 2006 01:51 GMT

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.

>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
[quoted text clipped - 4 lines]
> Ideas????
> Meg

Reply to this Message