Attendence-system

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Blackstar - 31 Jan 2006 11:36 GMT

Hi,

For an attendence system I use a form which first asks for a date and then
takes names and that date to a new table.
That gives me the possibility to fill out the attendance for that day.

Because the question for the date is made by ACCESS itself, it is not really
userfriendly, if one does just types numbers without slashes the date is not
entered correctly, theirefore I thought it would be interesting to use a
calender-object.
Can anyone help me on how to make that work?
Or would it be better to use a small form that asked for the date with a
preformated date-entry?

Signature

Didier Van Acker

Reply to this Message

RD - 31 Jan 2006 17:04 GMT

>Hi,
>
[quoted text clipped - 9 lines]
>Or would it be better to use a small form that asked for the date with a
>preformated date-entry?

You don't make it clear what form you are using to ask for the date. If the
form uses a simple text box for the date you can use the Input Mask property to
force input into the proper format. See Help for InputMask Property.

You can use a calendar object but I have found them to be more trouble than the
flash is worth. That being said, here's a cool one based on an Access form so
you don't need an ActiveX object.
http://www.glump.net/dokuwiki/software/microsoft_access_date_picker

HTH,
RD

Reply to this Message

vvariety - 31 Jan 2006 18:22 GMT

Why not just format the field on the form as a short date which would
allow the users to just enter the numbers and the slashes are filled in
for them. i.e. 01312006 would be reflected as 01/31/2006

Reply to this Message

Blackstar - 31 Jan 2006 19:01 GMT

I'm prompted by access, it's the query that asks for the date.

Sorry

Signature

Didier Van Acker

> Why not just format the field on the form as a short date which would
> allow the users to just enter the numbers and the slashes are filled in
> for them. i.e. 01312006 would be reflected as 01/31/2006

Reply to this Message