gakiss2
Registered User.
- Local time
- Today, 10:29
- Joined
- Nov 21, 2018
- Messages
- 168
I found this answer by DBGuy from a few years ago:
Works great. Now I would like to remove the time stamp and/or change the date/time format so that it is shortened up. I love the feature, just don't want to use up all that real estate. I had tried doing surgery on it with Mid text string operator but got an error. I could try to recreate what I did if anyone thinks it should work and I had just made typo. Also, I don't like doing all this inside a property window and would rather do it in vba code if that is a possibility. So Much Thanks to theDBguy for getting me almost there. Some background. I made a function to AddHistory which I use vba to put a message in the Note field. I use AfterUpdate on all the important fields to call this function. the end result is that I end up with a pretty good form change history. This is recording a lot of good stuff, the 'tagline' for the version history is way too long and unwieldy IMHO. Who needs seconds?? Who has SWAY with B. Gates? Someone should look at making this more customizable. Appreciate any help.
Works great. Now I would like to remove the time stamp and/or change the date/time format so that it is shortened up. I love the feature, just don't want to use up all that real estate. I had tried doing surgery on it with Mid text string operator but got an error. I could try to recreate what I did if anyone thinks it should work and I had just made typo. Also, I don't like doing all this inside a property window and would rather do it in vba code if that is a possibility. So Much Thanks to theDBguy for getting me almost there. Some background. I made a function to AddHistory which I use vba to put a message in the Note field. I use AfterUpdate on all the important fields to call this function. the end result is that I end up with a pretty good form change history. This is recording a lot of good stuff, the 'tagline' for the version history is way too long and unwieldy IMHO. Who needs seconds?? Who has SWAY with B. Gates? Someone should look at making this more customizable. Appreciate any help.