VBA Error

[S]

I have a database that I use on a desktop and everything works fine. When I
bring the database file to a laptop I get errors trying to open some reports.
Bot desktop and laptop are running Windows 7 64 bit operating system. IN VB
the highlighted code is:

Function Concatenate(pstrSQL As String, _
Optional pstrDelim As String = ", ") _
As String

Is there a specific reason this is doing that on the laptop?
Any help is greatly appreciated.

 

[Dirk Goldgar]

I have a database that I use on a desktop and everything works fine. When I
bring the database file to a laptop I get errors trying to open some
reports.
Bot desktop and laptop are running Windows 7 64 bit operating system. IN
VB
the highlighted code is:

Function Concatenate(pstrSQL As String, _
Optional pstrDelim As String = ", ") _
As String

Is there a specific reason this is doing that on the laptop?
Any help is greatly appreciated.

Often when databases don't work on one particular machine, it's because of a
broken or missing reference. See if the steps outlined here help:

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[Daniel Pineault]

Are any references missing?

From the VBE console
Tools -> References

Do any of them indicate that they are missing?

In your highlighted function, what is the next line of code?
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.