Discussion Locked

Comment Log - Access 2000

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a pre-existing Access 2000 database that allows me to log and maintain service records for the repair of several hundred PC's. When I create a work order, I want to be able to create a time-stamped comment on the progress of the repair. This way, when that progress changes, I can create a seperate time-stamped comment. This allows the process to be closely tracked and measured.

My problem is, I have no idea how to code that piece of it. If someone could assist me in that process, I would greatly appreciate it.

4 replies

by timwalsh

I think this might work for you as long as you aren't going to conduct any calculations off of the time stamp.

Create a separate table with the following fields (change field names to suite your purposes):
Time Stamp: formatted as simple text
Status: formatted as either text or memo
Work Order Number: formatted as either text or number (depending on your work order number format)
Log Number: formatted as AutoNumber and set as the Primary Key for the table

In Field Properties for the Time Stamp field, either use Expression Builder to build the following expression or simply manually enter it as the Default Value.

=Date() & " " & Time()

Notes:
1. No space between the (=) and Date.
2. In the Date() expression, thereis no space between Date and (). No space between (). Same for Time() expression.
3. 1 blank space prior to and after each (&).
4. The number of blank spaces between the quotation marks determines the seperation between the date and time.

By setting this expression up as the field default value, it will automatically be entered when a new record is created (whenever you create a new status entry).

Join this table to whatever other table you a use to enter other information relevant to the work order using the Work Order number field. Set the relationship as one-to-many (you will only have a single unique work order but can have many status entries relating to that work order).

Hope this helps.

by megashub

Your answer would work, however I was just informed that they'd like to find a way to make this work without creating a new table. Because I never stipulated that on my original request, I'm certainly willing to award you the points, however I thought I'd check with you to see if you might have some additional insight?

This discussion is closed to new replies.