Macro not executing all actions everytime 1

[fidlstix]

I have consolidated a few macros within a macro and don't know if this is causing my problem. Or perhaps some sort of memory problem? The issue is that there is a make table query within the macro that doesn't execute everytime I run the macro.

The make table query links a local table to an oracle table using an oracle odbc driver.

I am having a hard time finding the pattern for failure. It runs the first time I open the database.

On successive tries it may run two times in a row - however then it stops running.

I have left the warning messages in - so I know it is trying to execute the qry (it warns me my table will be deleted), but it doesn't actually pull records or create a table after that.

It will even get to the point where if I try to execute the mk tbl qry manually (outside the macro - just clicking on the qry to execute) - it won't run.

Since I am currently the only person running this process - I know what to look for - however - I know something isn't working correctly and it feels a bit sloppy to leave it this way...

Thanks in advance for your help.

p.s. not so much a programmer, more of a technical user - don't want to look like i might know more than i do - selected the wrong thing at registration...haven't yet figured out how to fix that...i humbly ask your patience. : )

 

[ZmrAbdulla]

Macros are always pain. It doesn't have error trap that causes many problem. Suggesting to convert them into VBA. If you are using Access2000 or higher you can do it from the menu
While you are at the design view of the form

TOOLS > MACRO > CONVERT FORM'S MACRO TO VISUAL BASIC

Don't forget to keep backup of your db

Zameer Abdulla
[sub]Jack of Visual Basic Programming, Master in Dining & Sleeping[/sub]
Visit Me

 

[fidlstix]

Thanks Zameer - I will give it a go..

 

[fidlstix]

Zameer,

I have converted the macros. Interestingly enough - while there are no error messages being thrown - the macros are executing every time.

Thank You

Laura