Re: Suggestion please
From: John Nurick (j.mapSoN.nurick_at_dial.pipex.com)
Date: 02/06/04
- Next message: John Nurick: "Re: displaying form data from 2 tables"
- Previous message: pack: "Protecting records"
- In reply to: Michael Lam: "Suggestion please"
- Next in thread: Michael Lam: "Re: Suggestion please"
- Reply: Michael Lam: "Re: Suggestion please"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 06 Feb 2004 21:56:31 +0000
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: John Nurick: "Re: displaying form data from 2 tables"
- Previous message: pack: "Protecting records"
- In reply to: Michael Lam: "Suggestion please"
- Next in thread: Michael Lam: "Re: Suggestion please"
- Reply: Michael Lam: "Re: Suggestion please"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
