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

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" <(E-Mail Removed)> wrote in message
news:1A2169C8-163A-48A0-AE91-(E-Mail Removed)...
> 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
>

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." wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:1A2169C8-163A-48A0-AE91-(E-Mail Removed)...
> > 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
> >
>
>
>

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.

"Luka" <(E-Mail Removed)> wrote in message
news:0411157C-159B-4F60-BAC9-(E-Mail Removed)...
> 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." wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:1A2169C8-163A-48A0-AE91-(E-Mail Removed)...
>> > 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
>> >
>>
>>
>>

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.

"AccessVandal via AccessMonster.com" <u18947@uwe> wrote in message
news:8ca13092ffd99@uwe...
> As for the macros, A2007 does not support SetValue and Echo. I believe the
> warnings are normal, should be ignored if you know what you're doing.
>
> Luka wrote:
>>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
>
> --
> Please Rate the posting if helps you
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...ccess/200811/1
>