Access2000 converted to Access2007

[Luka]

Hello,
I converted Access2000 database to Access2007. And it does not work properly.
The directory with Database is Trusted. I rewrite Option settings from
version 2000.

First I cannot get rid of yellow triangles (with exclamation) in the
beginning of macro rows for some actions like: Echo, SetValue, Close……
The row with Condition (IsNull()) also has triangle. It does not execute
right. It returns False for empty field.

Module, when running:
If (IsNull(.Ctl1kom)) Then
it does not recognize empty space

Compailing executes OK with no massage anything is wrong.

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.

Can you help me?

VBA references from Access2000: (Everything is working 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

Luka

 

[Pete D.]

I access database options open trust center. Select message bar and select
show message bar in all applications where content has been blocked. Close
access and reopen data file. See if you have option button at top and
enable content.

 

[Luka]

Mr. Pete,
I have already activated option "Show message bar in all applications where
content has been blocked".
I have also activated option “Enable all macrosâ€
I am sorry, but I do not understand your last two sentences.

Let me say some more about my problem.
Macros and codes run with no Action Failed or Error massage to the end.
They run to the end with some of actions not executed.
Just some of actions written, fail.
Result in macro is wrong data or infinite loop.
Let’s say, because code condition failure condition executes, and produces
wrong action.
At the end it exits with no ErrMsg. It ends as everything is OK.

I wrote:
If (IsNull(.Ctl1kom)) Then
does not recognize empty space.

And if I write:
If (.Ctl1kom) Is Null Then
The same thing happens.

I am not VB expert, but I assume wrong execution is result of missing some
library in VBA references.

Luka

 

[Pete D.]

Is it always the isnull or a null action your having problems with or are
there other actions that fail? Is it possible the field has a space in it
instead of null? The Icon tells you if it will run without macros being
enabled or not. It is a warning that macros must be enabled.

 

[Pete D.]

You must select show all actions button to see SetValue and Echo both of
which will not run if macros/code isn't enabled by using trusted location or
signing the project and depending on your network admin it still may prompt
with the option to enable codes like if the wizard directory is removed from
trust.