Dear John Nurick
Thank first
I have try to configure the event as you mention but the record seem dont
update everytime I edit the records
any idea?
All the date and time columns are contained in the same table.
Different portion of date ,time colums are accessed by two form (Request
Form and MIS Form)
Request Form is already automatically filled in time and date by define the
default value = Now()
and assigned autogen Ref No when create
The MIS Form will retrieve the record by Ref No
after create the event you mention. The MIS date , time portion will be
filled in
After I create several records, I try to retrieve the records in MIS form
and update it
The time record dont change
Any idea?
"John Nurick" <
[email protected]> ¦b¶l¥ó
¤¤¼¶¼g...
Hi Michael,
Comments inline.
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
Access Date/Time fields store a point in time (date and time together)
so you don't need one column for date and one for time.
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
Use an Autonumber field for the RefNo (it's best not to use spaces or
any special characters in the names of fields or other objects). Also in
Table Design view, set the Default Value of your RequestDateTime field
to
Now()
Every time you create a new record, Access will assign a RefNo (though
they won't always be sequential) and put the current date and time in
RequestDateTime.
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
You'll need to use a line of VBA code in the Form's BeforeUpdate event
procedure, something like this:
Me.ViewDate.Value = Now()
This assigns the current date and time to the ViewDate field each time
the current record is edited.
there is also a field I want to protect with password from change after
keyin the value
How the process ?
This can be done but it's not simple to do it in a way that cannot
easily be circumvented. If all you need is to prevent the data being
accidentally altered, forget about passwords and check out the Locked
property of the Textbox object and other controls, and the AllowEdits
and AllowAditions properties of the Form object.
If you need to protect the data against tampering, you'll need to learn
quite a lot more about Access first. If it is important to ensure the
integrity of the data (for legal reasons, for instance) it might be a
good idea to employ an experienced professional Access developer.
Is this possible for access to provide a calendar for date choosing?
if yes , how to
There's a sample database at
http://www.mvps.org/access/forms/frm0050.htm
new comers. Please advise in detail
Almost everyone who answers questions in these newsgroups is a
volunteer. We're happy to help with specific problems, but seldom
willing to provide a free consultancy service.
