same code - differing dbases - different errors!

[iankerry]

Hi All

I am using Access 2010

I have two similar databases for tracking LIve events and Film Events. They both reside on my computer.

I have some code that works in one, but i recently copies it into the other and received error messages.

I check the References and both were exactly the same.

Two lines for instance:

Dim arrSummaryData() As SUMMARY_DATA
(gives me COMPILE ERROR user-defined type not defined )

If OpenConnection Then
(gives me Argument not optional)

How come these work in one Database file, but not the other!!

Any clue anyone, please?

Thanks
ian

 

[vbaInet]

You haven't copied the SUMMARY_DATA Type enumeration. There's a module that holds this Type. Perform a search for it and copy it over into the right place.

As for the second one, you will need to search for where OpenConnection was used and apply the correct parameters.

 

[iankerry]

Ah, thanks VbaInet. Both were in a Public Function which i should have moved over too. Silly me.

thanks for replying.

Ian

 

[vbaInet]

No problemo!