Search results

Many thanks for all of your thoughts, which are really helpful, reassuring and a further step in understanding more about Access.

Many thanks for responding and thank you for the reassurance.

Has anyone else experienced the VBA References "dropdown" stating the old name of the Access accdb file as the "title" after the name of the file had been renamed? The appropriate References continue to be marked as active as before. Is this simply an anomaly and does it matter? So far the...

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...