Cannot find VBA definition in XP Only

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?
 
T

Tim Ferguson

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:

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
 
J

John Nurick

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?
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top