Dana G Posted February 29, 2008 Share Posted February 29, 2008 Is there a way to set a tool tip to show the account name and date/time that the field was last changed? Link to comment Share on other sites More sharing options...
_henry_ Posted February 29, 2008 Share Posted February 29, 2008 Hi Dana, Firstly, you should have a field that contains information about "Last_Change_Date" for a record, then in Set tooltip, enter this: Get (AccountName) & " " & [TableName::Last_Change_Date] Hope it helps... Link to comment Share on other sites More sharing options...
Dana G Posted February 29, 2008 Author Share Posted February 29, 2008 Thanks Henry, I was trying to avoid creating a second field for every field in my layout. I was hoping that there was a custom function that could be created and added to each field that would note the modifications to only that field. Ex. Field 1 was modified and tooltip would read "John Smith 2/29/08." Field 2 was not modified and would show "Bob Johnson 1/1/08." Field 3 has never been modified so it would have a blank tooltip. Link to comment Share on other sites More sharing options...
_henry_ Posted February 29, 2008 Share Posted February 29, 2008 Hi Dana, Ex. Field 1 was modified and tooltip would read "John Smith 2/29/08." Field 2 was not modified and would show "Bob Johnson 1/1/08." Field 3 has never been modified so it would have a blank tooltip. So, will you actually save the "date" of modification into a field? I am not sure that the tooltip can actually save all your "modification_date" without having a field to keep their records... Link to comment Share on other sites More sharing options...
Dana G Posted February 29, 2008 Author Share Posted February 29, 2008 That's what I was crossing my fingers for. If it's not possible then I'll have to see if they would settle for a single field with the modification log. It's just something that an employee asked me about and I didn't have an answer as to whether or not a tooltip was capable of that. It's one of those "wants" but not necessarily a need. Link to comment Share on other sites More sharing options...
Lee Smith Posted February 29, 2008 Share Posted February 29, 2008 If is only a matter of knowing who changed the fields and when, look at the Audit Tracking files that have been discussed in the past. Check out this file Link to see what I mean. HTH Lee Link to comment Share on other sites More sharing options...
Dana G Posted February 29, 2008 Author Share Posted February 29, 2008 That may work. I'll have to take a look at in depth. I know that it will work for other areas that we need a history for the data. Thanks Lee. Link to comment Share on other sites More sharing options...
Newbies Searchengineoptimization Posted July 25, 2011 Newbies Share Posted July 25, 2011 hello friend thanks your good information for me this very helpfull for me Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4652 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now