Access2000 converted to Access2007

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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

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

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

Thanks Pete,

Trust location is enabled anyway. Weird, ribbon was disabled, so can't enable
the action. Just found out why today that by right clicking the the marco and
select "Show All Action". Seems to work.
But there is still a problem, opening the marco in design the ribbon was
still disabled. It took more than 2 min for the button to enable.

Bizarre huh?

Pete D. wrote:
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.

--
Please Rate the posting if helps you

Message posted via http://www.accessmonster.com