Creating a log using text boxes.

[Bergja]

Hello all,

Please forgive my inexperience with access as im sure there are much better and easier ways to do what I am attemting...

That being said my issue is as follows:

I have two main forms in my database, Helpdesk and IMO. Helpdesk is available to all users in my organization via linked tables, it is basically a form for inputing trouble tickets. IMO is a form used by my staff to view and changed the tickets submitted by the users. Everything works perfectly at the moment, however I am looking for a way to create a work log control (or set of controls). What I am looking at is using two text boxes, one to display what is already stored in the table and the other to update it. That is easy enough, but the part I cant seem to wrap my head around is whether it is possible to display the data in the display text box with the date and time it was posted, and to add spaces so that it would display as such:



2008 July 11 - HDD Overheated, replacing and reimaging - username

2008 July 12 - replaced and reimaged HDD, PC ready for use - username



if anyone has any ideas please pass them on.

Thanks!

 

[SrPuma]

i would recomend u to add a new collum to the "tickets table" (or whatever is the table where u put the tickets) with whatever name u want...next put a new textbox and make it not visible....and in teh code do

Me.*textbox name here*.value= Format(NOW(), "HH:MM","DD-MM-YYYY")
H->Hour
M->Minutes
Y->Year
M->Month
D->Day

at the time the "record/ticket" is saved to the table the text box value will write the time and date that the record was created
For example
A user makes a new record and its 12:01 from some day..
as the record is safed the value for that will be 12:01 of that day

 

[Bergja]

Re:

The way my database works is a user has a computer problem and submits a ticket via the "Helpdesk" Form. All the data they submit is stored in the "IAHelpdesk" Table. Now once this done my techs view the record on a seperate form called IMO. This is where my techs view the record and make changes if necessary. On this form I need to do a worklog allowing my techs to post their progress on fixing whatever problem the user is having. Everytime a tech updates the worklog I want the there the date and time the update was made to display first after being posted as such:

2008 July 11 - HDD Overheated, replacing and reimaging - james.riley

As the ticket is being worked on there may be several updates to the worklog, if there are more than one update I want to automatically add a space between the previous entry as such:

2008 July 11 - HDD Overheated, replacing and reimaging - username
SPACE
2008 July 12 - replaced and reimaged HDD, PC ready for use - username

This is only one field in the table that is being updated with the current time and date. the entire record could be changed because a user put the wrong info in but if the worklog isnt updated I dont want to automatically add a date and time somewhere. so most if not all of the code making this happen would go into a seperate command button.

I am not sure how else to explain what I am trying to do but for now I am experimenting with using two text boxes on the main form and using a subform to do this, each way im having the same problem of adding a space and the date and time before the worklog entry.

Any help would be greatly appreciated.

Thanks!