Split Function Wrong Number of Arguments

[Albert S.]

Hello,

I am using the split function to create some arrays in two different mdb's
on the same PC. In one mdb, I am getting a "wrong number of arguments" error
when I try to complile the code. When I retype the split function, it will
only accept the initial string, and no delimiter.

I checked all the references and they are identical. Both mdb's are pulling
the data from a SQLServer backend. Access 2003, SQLServer 2005.

Thanks for any help!

 

[Albert S.]

Sorry about this post...

Some idiot, (can't imagine who), created a custom function named "split"...

A good lesson in giving my functions better names...

 

[Dirk Goldgar]

Sorry about this post...

Some idiot, (can't imagine who), created a custom function named
"split"...

<g>

 

[PieterLinden via AccessMonster.com]

Sorry about this post...

Some idiot, (can't imagine who), created a custom function named "split"...

A good lesson in giving my functions better names...

Hello,

[quoted text clipped - 7 lines]

Thanks for any help!

no, it was just such an intuitive name that someone thought of it before you
did.

 

[ChrisO]

You don’t need to rename or throw away the Split Function that {some idiot,
(can't imagine who)} created. If you wish to force the use of the Access
version of the Split Function simply use VBA.Split when calling it.

 

[Albert S.]

Ok, thanks for the info. I'll keep that in mind in the future...