Creating a "history" textbox on a form

[GFM]

Hi guys,

I'm hoping for a bit of help please as my VBA "knowledge" is getting me nowhere!

I'd like to create what I had hoped was a fairly simple bit of code to add the new value input into any textbox on my form, into a second textbox, along with a user and date/time, adding to the existing text in that second box each time to create a change log.

Sadly it turns out I'm a moron, I wonder therefore if someone could explain to me how to achieve this please.

Many thanks

 

[namliam]

You are best off creating a log TABLE, instead of trying to log changes into a single text box.

 

[GFM]

You are best off creating a log TABLE, instead of trying to log changes into a single text box.

 

[GFM]

Thanks yes I had considered this but I can't see how I'd make it work when bringing the data back as I'd like the detail to be accessible to users at the same time as the rest of the form in a single scrollable textbox if this is achievable.

 

[theDBguy]

Thanks yes I had considered this but I can't see how I'd make it work when bringing the data back as I'd like the detail to be accessible to users at the same time as the rest of the form in a single scrollable textbox if this is achievable.

I would still recommend using a table and then you can use this simple function, if you really want to combine all the records into a long textbox.

Code Snippets

 

[Pat Hartman]

What you are attempting to do will rapidly become unwieldly. If you want to create history, we can provide links to code you can incorporate. Doing this for ONE field might be helpful but mushing all changes into a single field will become useless in a hurry but it is easy to do. Use the AfterUpdate event of each control you want to log.

Me.MushedField = "SomefieldName =" & Me.SomeField & ":" & Format(Date, "Short Date") & ":" & Me.MushedField

Each procedure will use a different value for "somename"

 

[GFM]

Thanks Both,

Given the records are only in use for a short period and I expect minimal changes the above will work well!

Your help is greatly appreciated

G

 

[theDBguy]

Thanks Both,

Given the records are only in use for a short period and I expect minimal changes the above will work well!

Your help is greatly appreciated

G

Hi. Good luck with your project.

 

[GFM]

Hi. Good luck with your project.

Thanks, it marches on! If I were a real developer I’d know not to let things grow arms and legs and just deliver what is needed and no more but I can’t help myself!! Hopefully will be done soon.

Thanks again.

G