New comer Please advise

[Michael Lam]

I need to design a database for services request

I have designed a table which contain two date date columns and time columns
and two forms
One for recording the user request date and time automatically
One for recording the view date and time of technical staff automatically

User request form will generate Ref No and request date and time
automatically

Tech form will search the request by Ref No and update the view date and
time after click save or update(but I cant)
Please teach me

there is also a field I want to protect with password from change after
keyin the value

How the process ?

Is this possible for access to provide a calendar for date choosing?
if yes , how to

new comers. Please advise in detail
Much Thx
Michael

 

[James Goodman]

The easiest way to do this is probably as follows:
Add controls to your form which are bound to the ViewDate & Time columns.
Make the controls hidden.

Next, in the BeforeUpdate event for the form add the following:
Me.txtViewDate = Date()
Me.txtViewTime = Time()

N.B. I assumed you named the controls txtViewDate & Time. You will need to
substitute your control names here.

 

[Michael Lam]

THX
"James Goodman" <j a m e (e-mail address removed) k> ¦b¶l¥ó
¤¤¼¶¼g...
The easiest way to do this is probably as follows:
Add controls to your form which are bound to the ViewDate & Time columns.
Make the controls hidden.

Next, in the BeforeUpdate event for the form add the following:
Me.txtViewDate = Date()
Me.txtViewTime = Time()

N.B. I assumed you named the controls txtViewDate & Time. You will need to
substitute your control names here.