Cannot find VBA definition in XP Only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are experiencing a problem with our Access code on only XP machines
running Office XP. We are developing in Access 2000 and have a new PC
running XP Service patch 2 and Office XP Service Pack 3.

We are experiencing problems with the VBA Reference even though the Visual
Basic for Applications is a selected referenced. One example is with
CHR$(13). When we right click to find the definition, it cannot find it?
The error we receive is:

“Function is not available in expressions in query expression
‘[tblCustomers].[Address1] & “,†& Chr$(13) & Chr$(10) &
[tblCustomers].[City] & “,†&[tblCustomers].[State] & “,†&
[tblCustomers].[ZipCode] & “,†& Chr$(13) & Chr$(10) &
[tblCustomers].[Phone]’.â€

We have reviewed the references many times. The main difference we can see
is that previous version has a reference of Microsoft Access 9.0 Object
Library vs. Microsoft Access 10.0 Object Library on the newer machine.
However, we are at a loss as to why this should be a problem as the issue is
with a VBA Reference.

The VBE6.DLL we are using on both machines is the identical version.

We are at a loss on why these definitions are not working and would like to
see if anyone else has any ideas?
 
We are experiencing problems with the VBA Reference even though the
Visual Basic for Applications is a selected referenced. One example
is with CHR$(13). When we right click to find the definition, it
cannot find it? The error we receive is:
Click to expand...

You are quite right that this is a References problem. Look in the
References list in the VB Editor and look for *any* missing reference.
Either uncheck it or remove it altogether. If it's a library you need
then you'll have to find it manually or check the installation etc; if
it's one you don't need then don't worry any further.

The point is that VBA is really sensitive to a missing reference anywhere
in the environment, and the commonest symptom is for plain VB functions
(such as Date() or Chr$() etc) to fail, regardless of which library is
broken.

Hope that helps


Tim F
 
Hi Robert,

This should help:
http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html

We are experiencing a problem with our Access code on only XP machines
running Office XP. We are developing in Access 2000 and have a new PC
running XP Service patch 2 and Office XP Service Pack 3.

We are experiencing problems with the VBA Reference even though the Visual
Basic for Applications is a selected referenced. One example is with
CHR$(13). When we right click to find the definition, it cannot find it?
The error we receive is:

“Function is not available in expressions in query expression
‘[tblCustomers].[Address1] & “,” & Chr$(13) & Chr$(10) &
[tblCustomers].[City] & “,” &[tblCustomers].[State] & “,” &
[tblCustomers].[ZipCode] & “,” & Chr$(13) & Chr$(10) &
[tblCustomers].[Phone]’.”

We have reviewed the references many times. The main difference we can see
is that previous version has a reference of Microsoft Access 9.0 Object
Library vs. Microsoft Access 10.0 Object Library on the newer machine.
However, we are at a loss as to why this should be a problem as the issue is
with a VBA Reference.

The VBE6.DLL we are using on both machines is the identical version.

We are at a loss on why these definitions are not working and would like to
see if anyone else has any ideas?
Click to expand...
 
I just wanted to get back to you guy's and tell you your advice was right on!
This information was really excellent and I encourage anyone else having
these problems to take these great words of advice.

Thansk Again!

John Nurick said:
Hi Robert,

This should help:
http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html

We are experiencing a problem with our Access code on only XP machines
running Office XP. We are developing in Access 2000 and have a new PC
running XP Service patch 2 and Office XP Service Pack 3.

We are experiencing problems with the VBA Reference even though the Visual
Basic for Applications is a selected referenced. One example is with
CHR$(13). When we right click to find the definition, it cannot find it?
The error we receive is:

“Function is not available in expressions in query expression
‘[tblCustomers].[Address1] & “,†& Chr$(13) & Chr$(10) &
[tblCustomers].[City] & “,†&[tblCustomers].[State] & “,†&
[tblCustomers].[ZipCode] & “,†& Chr$(13) & Chr$(10) &
[tblCustomers].[Phone]’.â€

We have reviewed the references many times. The main difference we can see
is that previous version has a reference of Microsoft Access 9.0 Object
Library vs. Microsoft Access 10.0 Object Library on the newer machine.
However, we are at a loss as to why this should be a problem as the issue is
with a VBA Reference.

The VBE6.DLL we are using on both machines is the identical version.

We are at a loss on why these definitions are not working and would like to
see if anyone else has any ideas?
Click to expand...
Click to expand...
 
Back
Top