Auto enter date or time on double click

[Steve Lenaghan]

I am building a taxi dispatch application around Access 2K

I need to have the date and time auto entered when the call taker enters
the dispatch information. This can be either double click the time/date
fields or display when the record is saved.

Is there a format to have date and time as one files, i.e. "Nov. 28,
2004, 1:16 pm"

I also require the ability to change the date and time manually in the
case of calls scheduled to be done at a later date. I don't have a
problem with inserting a field strictly for future bookings.

I would like to lock the time/date field once the record has been saved.

"However" I also need to have a completed time field that the dispatcher
can double click once the trip is done.

TIA

Steve L.

 

[John Spencer (MVP)]

How about setting the Default value for the DateTime field to NOW()?

That should automatically fill in the current date and time when the record is
being created. It will be editable.

Assuming that you are using a form for data entry, you can lock individual
controls in the on current event of the form based on whether or not the record
is a new record.

AIR CODE in the form's current event.

Private Sub Form_Current()
Me.fID.Enabled = Me.NewRecord
End Sub

 

[Crumb]

Here's some pictures that may help...

http://www.sitcomsonline.com/photopost/showgallery.php?cat=740&password=&page=1

 

[Steve Lenaghan]

That worked fine except... In my practice table, date, time and from.
When I enter any data in the from field a new record is created.

??? I'm at a loss. I haven't done anything in Access for a few years so
I'm rusty

Steve L.

 

[John Spencer (MVP)]

Obviously, I don't understand what you are saying.

Whenever you enter data into a blank record, Access automatically creates a record.

 

[aTp]

G'day Steve - I am doing the exact same thing - trying to set up a
database in Access for a small Taxi company.

And I looking for the exact same solution to the autodate/time and then
locking that field for a new record when the client calls.

How did you go ?

I would like to see your database to see what you've done if thats OK
with you.

Cant see a way to do a PM here so i'll send you my email addy if you
reply.

Regards Tony.