Updating information into a field automativcally ?

[ciskid]

Hi Folks

I’m a newbie here, so as usual it’s always followed by a plea for help.

I’m From Scotland (live in Engerland)

I used to dabble with access in 95 and I can see it’s changed quite a bit.

I need a logging system for keeping details of faults that we have passed to various departments/

When we send an email I want the guys in my team to update the database with what ever they have sent. (This willbe a cut and paste action)

I want the database to have each entry with the following format


=============================
Updated by Jimmy at 19:33 on 27/7/06

I email John the following information:-

BLAH BLAH BLAH
BLAH BLAH BLAH


=============================

So everything in red above , is what will be pasted by the NEW Update buton, It will put the username , date and time of the update in between some other charaters (============) so that when we print the record as a report we can easily see all the updates as they will be between the dotted lines etc

So they are just update the same field all the time, appending data to the top of the record.

So maybe when the database starts it will ask the user his name, so that if makes any updates, it will use this name that he entered in. The date and time ect are the date and time, at the time of the new entry.

I made an example database and you can see a screenshot below:-

My problem is, that I unsure how to complete this task?

Can anyone help me with this?

I’m no good at programming, so it needs to be simple for this simple user

Many thanks for any assistance or pointers you can give me

Ive also attached a sample databse.

Many thanks folks

Jimmy

 

[elbweb]

while this code is realativly easy, imgoing to hold off on telling you how to do it, and this is why:

my understanding is that there is say, an issue that has multiple updates at multiple times, and then you want to have a user put in these updates, and then when you print out a report you get the information in a predefined format.

they would be linked, in this instance by a 'ticketID'.

Im gonna throw a db together real quick of what i think you are looking for, hopefully its right

 

[elbweb]

well here it is, i hope thisis what you were looking for, if its completely wrong, let me know and ill try and help you get the right way, if its almost right feel free and we can work with that too, if you dont know how to do it on your own.

good luck

frmTickets is the main entry form, and then the report is what prints it out in the format you wanted.

 

[ciskid]

Hi Elweb

Thats great, i have used subforms before and I would like to thank you for the time and effort.

Again manty thanks for this, It will do nicely

Cheers

Jimmy

 

[elbweb]

another satisfied customer, great to hear!