I've got some VBA code in an Access 2000 database that works fine. However, when I convert it to Access 97 one of the functions I've used (Split) fails.
The code is:
monthAndYear = "April 2003"
month = Split(monthAndYear, " "
This gives month a value of "April".
Is there a function or bit of code that would work in Access 97 (i.e. something that doesn't use Split) to do the same thing?
TIA
bishman
The code is:
monthAndYear = "April 2003"
month = Split(monthAndYear, " "
This gives month a value of "April".
Is there a function or bit of code that would work in Access 97 (i.e. something that doesn't use Split) to do the same thing?
TIA
bishman