User makes an entry in a field (type 'memo') on an access form
Whenever a each character that is typed, the entry (so far) needs to be looked up in a table
When a match is found, the text is autofilled.
When a match is (not yet) found, nothing happends
When the user decides that the match is OK the key 'enter' will add the matched text
So far, a standard function.
Now the user continues with the next entry in the SAME(!) memo field.
The next entry is marked by the character ':' or ';' or ',' or '('.
When the user types in this one of the characters, the autofill and lookup procedure starts again.
When word is entered, before the character ':' or ';' or ',' or '(', and the lookup did not found a match, the entry is inserted in the lookup table as a new row. So the next time this text can be autofilled.
The word is entered without any punctuation characters (except ' and ")
- MS Access 2010 32 bit
- Windows 7 32 and 64bit
- clean code
- functions in seperate modules
4 фрилансеров(-а) в среднем готовы выполнить эту работу за €30
I am very proficient in dealing with word, ppt, access, excel files, and good at VBA programming, I have exceed 6 years of VBA programming experience [login to view URL] trust me, and let expert do it.