Problem: the note section of a flat database is located about 17 columns from the name of the item being looked up. The notes sometimes get placed in the wrong file and to mitigate this I need something that will be as close to fool proof as possible.
I was thinking something simple that would take the selected cell (the item being looked up)(any cell in column C in the picture below) and through the macro a box or form would appear asking you to add a note to the file... the trick is that I do not want to erase any of the notes currently in the notes cell for that particular record; also a date stamp of when the note was entered would be much appreciated as everybody seems to use their own formatting and it gets really annoying.
Example:
Thanks for your help.![]()




Reply With Quote
