L
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
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