Command Button Coding question

[Rich S.]

Hello,

I am pretty new to developing Access applications so pardon my "newbieness".

We are using Access 2002/XP to write a HelpDesk application. We're kinda
stuck right here.
Need to add a command button ("Close Ticket") to a form (done) such that
when the button is clicked-on, a Close_Ticket_date and Close_Ticket_Time
text boxes are populated with the current date and time. The respective
values in the database also need to be updated. We also need to set a
simple text value to indicate that the ticket is closed on the form and in
the table. Here is a pseudo-code example:

On-Click
Set Form.Ticket_Close_Date = current date
Change the field on the form
Set table..Ticket_Close_Date = current date
Change the value in the database
Set Form.Ticket_Close_Time = current time
Change the field on the form
Set table.Ticket_Close_Time = current time
Change the value in the database
Set Form.Ticket_Status = "Resolved / Closed"
Change the field on the form
Set table.Ticket_status = "resolved / Closed"
Change the value in the database
End

Also, on the command button, how do you set the property such that, for
example, <Alt-C> activates the button. That is, the "C" is underlined.

TIA,
Rich

 

[Tony]

Rich,

I developed a Trouble Ticket application using access.

First, the Underlined C is done on the button's Caption
property. &Close would insert an underline under the C.

Then, for your closing date and time, you should use the

txtDateCompleted.Value = Now