Splitting A Database

[jennilewis]

I am trying to split my database but when i run the database splitter it comes up with the following error messages:

Subscript out of range

And

Invalid procedure call or arguement

Does anyone have any ideas what could be causing these or how to fix it?

Thanks

 

[KenHigg]

Hum...

Can you isolate the offending line of code deug/compiling the code?

 

[jennilewis]

How would I try and do that?

 

[KenHigg]

First, I would go into one of the code modules and do a Debug->Compile. This may raise an error in your code...

 

[jennilewis]

what should happen when i click on that?
Sorry can you tell i'm not really a computer person!

 

[KenHigg]

It converts the vba code into machine code (I think?), and in the process, some times, if there are errors in the vba code, the compiler routine will point them out.

 

[jennilewis]

nothing noticable (i.e. error messages) happens but the menu option is greyed out until i change something.
I assume this means there are no errors?

 

[KenHigg]

Hum... Sorry, Not sure what to recommend next...

 

[KenHigg]

Hum... Sorry, Not sure what to recommend next...

 

[jennilewis]

Thank you anyway, you've been really helpful!
Am Currently trawling through all of the past posts hoping for some clues!

 

[RuralGuy]

Try Allen's sugestions: http://allenbrowne.com/ser-47.html

 

[jennilewis]

Sadly still no luck