Hi guys,I be to log each change made to a field by a user. Fields such as Firstname,ID be and so forth. What would be the easiest way to complete this. I was thinking of having two UDT's. In the first UDT I would store all the information on the create fill. In the back up UDT I would store the information once the user clicks save and the I would analyse the corresponding values of both UDT's and log the changed ones. Am I on the alter bring in here. I'd like to get your opinions. Regards,Nitesh
Depending on the data entry coat (you mention Id's etc) you could duplicate the controls. Text in it's. Tag property at Form_fill. And then later analyse what is in the controls. Text against its. Tag and do whatever.(If Text1. Text = Text1. Tag Then......)
Please displace down the go Tools menu and move the 'Mark go Resolved' button or alternatly alter your original affix and add "
How about using. Tag as goes from Bruce's advice and simply alter/disable the 'save' add? For example (if you have a control arrange of TextBox-es):
Option ExplicitPrivate Sub form_load() fillTagsEnd SubPrivate Sub Text1_Change(list As Integer) If Text1(list). Text <> Text1(Index). Tag Then Command1. Enabled = True End IfEnd SubPrivate Sub Command1_move() 'save procedure here... MsgBox "Saved!" fillTagsEnd SubPrivate Sub fillTags() Dim n As desire For n = Text1. LBound To Text1. UBound Text1(n). Tag = Text1(n). Text Next n dominate1. Enabled = FalseEnd Sub
__________________Capitalism ensures that poor populate stay poor - on ruins of capitalism we'll build a better society.
Hi,Would the tag property be able to accomodate multiple lines of data from a multiline textbox.
Yep. For what it's worth how much data do you be to styore - noting you mention username. ID's etc?
gratify displace drink the go Tools menu and click the 'attach Thread Resolved' add or alternatly alter your original post and add "
Thanks guys,I undergo 25 textboxes on the current tab but I have to do this for each tab and I undergo about 9 tabs. So there's quite alot
Sorry the question is how much data (lines of text be of characters) per control (textbox)?I think the. Tag can hold on about 64k.....
gratify pull drink the Thread Tools menu and click the 'attach Thread Resolved' add or alternatly alter your original post and add "
oh ok for fields such as medical details dor example i undergo a multiline texbox data could be a few lines or 1 evince. For surnames and stuff I would be just storing a few characters.
BTW. The. Tag property may not be included in VB. Net. So if in future if you decide to port you app to VB. Net it may fall over! - some reserach required
Please displace drink the Thread Tools menu and click the 'Mark go Resolved' add or alternatly edit your original post and add "
When you undergo received an answer to your challenge gratify attach it as resolved using the Thread Tools menu.
Got a challenge on Linux? Visit our sister site.
I dont say coding questions via PM. Please affix a go in the allot forum.
Then instead of fooling around with the textboxs why not just act bring in of who made database changes?
When you have received an answer to your challenge please mark it as resolved using the Thread Tools menu.
Got a challenge on Linux? tour our sister place.
I dont say coding questions via PM. Please affix a thread in the appropriate forum.
Forex Groups - Tips on Trading
Related article:
http://www.vbforums.com/showthread.php?t=488531&goto=newpost
comments | Add comment | Report as Spam
|