Search results

Pat To devise and adhere to a naming system for Access VBA is an excellent idea that I will adopt and thank you for your post. As I wrote previously, it has been a valuable lesson to learn.

Josef P. Just an update. I was unaware of the use of Shift+F2 when searching for a function. When I carried out your suggestion, I found the culprit, just as you predicted. A Split function was found in a module, copied a long time ago from Stephen Lebans. You learn something new every day and...

Josef P., You are a genius! Placing VBA. before Split(LString) is the solution. I really appreciated your most valuable help. Thank you

Dear All Many thanks for your replies, which are much appreciated. Firstly, my first Split() example was a poor one as I hadn't included In the split statement the string to search for. Nevertheless, the code does work in a new database file with no other objects. I have amended the code to...

I have a very odd VBA error when using Split() in a VBA function. I’m using it within a database running on a Microsoft Virtual Desktop in Access 365 in 64 bit mode. No VBA error code number is produced except for the attached screenshot of a very simple Split() function used to Tuesday 15 April...