Access2000 converted to Access2007

L

Luka

Hello,
I sent question to general questions, but perhaps this is more a macro and
code problem.
So I write about my problem again, this time to macro column.
I converted Access2000 database to Access2007. And it does not work properly.
The directory with Database is Trusted.
Activated is option "Show message bar in all applications where content has
been blocked".
Activated is option “Enable all macrosâ€
Activated is Show all actions in macro Design.

First I cannot get rid of yellow triangles (with exclamation) in the
beginning of macro rows for some actions like: Echo, SetValue, Close……
SetValue row (with yellow triangle) is not executed.
The row with Condition (IsNull()) also has triangle. It does not execute
right.
It returns False for Empty field.
Macros and codes run with no Action Failed window or Error message, to the
end.
Rewriting condition to a new row in this macro, triangle appears
immediately. And it does not work.
Rewriting condition row in NEW macro, it works OK.

VBA references set from Access2000: (Everything is working there OK)
-Visual Basic For Application
-Microsoft Access 9.0 Object Library
-OLE Automation
-Microsoft DAO 3.6 Object Library
-Microsoft Excel 9.0 Object Library
-Microsoft OLE DB Error Library
-Microsoft ActiveX Data Object 2.5 Library

I read on:
http://www.accessmvp.com/TWickerath/articles/adodao.htm
that Access2007 uses DAO libraries.
In a table with the “References appropriate to your version of Accessâ€
is default location for Access Object Library:
C:\Program Files\Microsoft Office\Office12\msacc.olb
But I cannot place it to Reference window.
Compailing database executes OK with no massage anything is wrong.
I am not VB expert, but I assume wrong execution is result of missing some
library in VBA references.
Is there any basic set of references that make Access2007 working OK.

Can you help me?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top