Crosstab Query Help

[ksmith]

I have database written in Access 2010. I need to split the database. The database has a couple of crosstab queries.

When I attempt to split I get the Message: Subscript out of Range.



Is this because of the crosstab queries?
If so How can I get this to work?

Can you 'Split a Database' and then build the crosstab queries?

Thanks for ANY help.

K Smith

[ajetrumpet]

have you compiled the vba project?

[ksmith]

No I have not complied the Vba, Will that help?

KSmith

[ksmith]

I compiled the code. Got the Same result.

What is subscript out of range?

Thanks for the reply.

K Smith

[ajetrumpet]

subscript out of range refers to a variable or code line that's out of scope. running the compiler should highlight the line for you. goto it and fix it.

"out of scope" means many things, but the best example is something like:

dim i as single

i = 1000000000

you will get the same error there because a 'single' data type cannot handle a number that large. only longs and doubles can.

[ksmith]

Thanks for the help.

I re-ran the the compile function. It's ok, or it did NOT find any mistakes in the VBA code.

I'm at wits end with this thing. I need to spilt the database a I can't find whats wrong.

Can you split a database that has a crosstab query in it?

Again many, many thanks for the help.
I need to get this working today.

KSmith

[ajetrumpet]

I'm sure you can ks. Crosstabs are nothing special. just objects.

still getting the same error? also, see: http://www.pcreview.co.uk/forums/sho...68&postcount=4

the problem has a history. I'm guessing corruption. It's common.

[ksmith]

Thanks for the help. I will try some things and see what happends.

Again many thanks,

KSmith