Re: Suggestion please
From: Michael Lam (kl_mis_at_pacific.net.hk)
Date: 02/07/04
- Next message: MT DOJ Help Desk: "Re: IF Statement in Validation Rule"
- Previous message: Michael Lam: "Re: Suggestion please"
- Maybe in reply to: Michael Lam: "Suggestion please"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 7 Feb 2004 12:36:07 +0800
Dear Sir
I have try to define those field not link to the table and default
value = Now()
So that the time and date shown on the MIS form will be exact the time
as computer clock
and create the follow event after update
Private Sub Date_AfterUpdate()
Dim rs As Object
rs = Me.Date.Value
rs = Now()
End Sub
It also dont work
any idea
"Michael Lam" <kl_mis@pacific.net.hk> ¦b¶l¥ó news: ¤¤¼¶¼g...
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" <j.mapSoN.nurick@dial.pipex.com> ¦b¶l¥ó
news:c328201krcignspebhc5bupmtbedmtqh5e@4ax.com ¤¤¼¶¼g...
Hi Michael,
Comments inline.
On Fri, 6 Feb 2004 12:11:36 +0800, "Michael Lam" <kl_mis@pacific.net.hk>
wrote:
>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.
-- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email.
- Next message: MT DOJ Help Desk: "Re: IF Statement in Validation Rule"
- Previous message: Michael Lam: "Re: Suggestion please"
- Maybe in reply to: Michael Lam: "Suggestion please"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
