Can someone help with this Code ?

[ciskid]

Hi Guys n Gals

I was hopin for some code help on a database that I have ?


I have a simple database where I have a field called information_log (see attached)


This filed is a memo type of field and it basically is a log of information about a specific fault.

So every day someone puts new information in this field like so

-----------------------------------------------------------
Updated by Jimmy on 08/9/2006 at 15:23

Blah Blah Blah
-----------------------------------------------------------

-----------------------------------------------------------
Updated by Tom on 04/9/2006 at 16:00

Blah Blah Blah
-----------------------------------------------------------
-----------------------------------------------------------
Updated by Sam on 03/9/2006 at 10:23

Blah Blah Blah
-----------------------------------------------------------

So rather than the user have to type out the above every time he has new information , I wanted him to click a box where it would append this information into a field.

So I asked a friend of mine to help and he gave me the following :-

Private Sub button_OnClick()


Me.Further_Info2 = Me.Further_Info2 & "----------" & vbNewLine & Me.Cross_References2 & vbNewLine & "*Update by Jimmy Guilfoyle on " & Date & " at " & Time & "*" & vbNewLine


End Sub

I dont understand the references to "Me.Cross_References2 "

Im having problems getting this to work and I was hoping someone can help me with the code and maybe an explanation.

My friend is on holiday otherwise I would ask him.

Im pretty desperate

Ive attached a sample version (very cut down) of what Im trying to do , look at the form and look at the 1st record in form view.

Can anyone help ?

Many thanks

Jimmy

 

[FoFa]

Me.Cross_References2 would be another control on your form.

 

[Uncle Gizmo]

It is not a good idea at all, storing your information in a memo field like that. There is an "Audit" example demo database by of all people Microsoft that stores information in a memo field. I know of at least one person who is having problems with it! You are much better off setting up another table to store this information.

 

[GaryPanic]

I would listen to old Uncle Gizmo
Set up a seperate table and form to go with it
it depends on the size of the D/base and what you are going to do
If we are looking at Very large project and you need to audit your messages
you might want
ref id (auto number)
id to x ref to the id on your main table- enquiry/client number
Name (person who updated) txt
Message - probably memo field
date update

option date resolved
resolved by

name and resolved by could then be tied to a combo box drop down of persons
this would give a very simple table
you can then query based on id and see status by whom resolved by days to resolve and all the other completly boring stuff that people in management think they need you may even want a completed tick box on the form so if tick it will enable/lock/grey out the screen