Microsoft Access vba code autofill in memo-field



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

Квалификация: Microsoft Access, Visual Basic

Показать больше ms lookup, vba time, microsoft vba, ms access 2010, vba word, ms access vba, ms access 2013, microsoft access vba, memo, clean code, ACCESS VBA, access microsoft, word autofill field, windows vba, word 2010 form access 2010, vba function, access form word, vba character word, text autofill, add code access vba

О работодателе:
( 12 отзыв(-а, -ов) ) Almere, Netherlands

ID проекта: #4875038



Dear, I can easily handle your project. Available right now. Please let em know. Regards, Fabrice

€29 EUR за 1 день
(6 отзывов(-а))

4 фрилансеров(-а) в среднем готовы выполнить эту работу за €30


[login to view URL] I have gone through your project requirements I will develop your function in separate module in your db within 2 days only It will function according to your suggestions for the data entry to memo fiel Больше

€29 EUR за 3 дней(-я)
(471 отзывов(-а))

Consider it done. I have something similar I can adapt for your needs.

€28 EUR за 1 день
(6 отзывов(-а))

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.

€34 EUR за 1 день
(1 отзыв)