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.

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





Steve Lenaghan wrote:

>

> 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.

Here's some pictures that may help...



http://www.sitcomsonline.com/photopo...ssword=&page=1







Steve Lenaghan <lenaghan@mts.net> wrote in message news:<FIpqd.3600$Yf5.15512@news1.mts.net>...

> 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.

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) wrote:

[vbcol=seagreen]

>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

>

>

>Steve Lenaghan wrote:

>

> 

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



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



Steve Lenaghan wrote:[vbcol=seagreen]

>

> 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) wrote:

> 

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.








	
Quote:
	

	

		

			
				Originally posted by 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.