gjk92
01-03-2013, 09:45 PM
Hi,
I am trying to improve one of my databases.
I need some assistance in writing a Custom Abbreviator program in VBA to go trough a table with custom abbreviations and then search another table with a strings like "East Emergency Exit 0123" and when i run the abbreviator it should save "E/EME/EX 0123" to a new table. I would like to use this for labeling purposes.
Abbreviation Table
EAST - E
WEST - W
EMERGENCY - EME
EXIT - EX
etc.
Currently my code sucks and is not working - what a surprise.
Any help would be appreciated.
THANKS
I am trying to improve one of my databases.
I need some assistance in writing a Custom Abbreviator program in VBA to go trough a table with custom abbreviations and then search another table with a strings like "East Emergency Exit 0123" and when i run the abbreviator it should save "E/EME/EX 0123" to a new table. I would like to use this for labeling purposes.
Abbreviation Table
EAST - E
WEST - W
EMERGENCY - EME
EXIT - EX
etc.
Currently my code sucks and is not working - what a surprise.
Any help would be appreciated.
THANKS