[Year 12 IT Apps] An access query question...

Tue Feb 19 17:32:54 EST 2008

Hi Kent

Tried adding a column to your table and call it ‘Age’, and format it as a
number. Create a form and add the relevant columns to the form. In the ‘Age’
text box, double click on it and type in the following formula:

=DateDiff("d",[DOB],[CurrentDate])

Where DOB is the date of birth field and current date is the current date.
If you run it, it should work.

Kind regards

Allan Barnes, CEO

Australian Institute of Education and Training

P.O. Box 171

Brunswick West 3055

Ph: (03) 9387 2051

FAX: (03) 9387 3470

Mobile: 0409 428 221

   _____  

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
On Behalf Of Kent Beveridge
Sent: Tuesday, 19 February 2008 4:32 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] An access query question...

Ok folks, can I seek your help please about an on topic question?

Currently working through a sample database which many are probably familiar
with. The Simco sample task.

My problem is that I am struggling to get from a query the 'Age' figure. ie
DOB subtracted from current year via a query is the method I've tried. Used
the method from the Microsoft help site but that uses a form...great, but
not quite what I need and yes, I got that one to work.

I have set up a table with DOB of the type date/time using 'short date' but
just cant quite get a query to calculate an age using the above info.

Would it be simpler if I just added a column to my tables and tried via a
validation statement although having tried that without success I am
beginning to wonder..

Ok..so I aint no genius...I know what I am trying to do...just falling a
little short here..

Any ideas folks?

HOWS ZAT?  Completely ON TOPIC...woohooo..

Kent.

Kent Beveridge,

I.T. co-ordinator

St. Brigids Catholic Sec. College

Horsham

email.. HYPERLINK
"mailto:kbeveridge at stbc.vic.edu.au"kbeveridge at stbc.vic.edu.au

|<3|\|7  b3\/3r1D93 ?  ;-)

Wishes and Eggs, one you make and one you break!  A bit like promises.....

“This email and any attachments may be confidential.  You must not disclose
or use the information in this email if you are not the intended recipient.
If you have received this email in error, please notify us immediately and
delete the email and all copies.  The School does not guarantee that this
email is virus or error free.  The attached files are provided and my only
be used on the basis that the user assumes all responsibility for any loss,
damage or consequence resulting directly or indirectly from the use of the
attached files, whether caused by the negligence of the sender or not.  The
content and opinions in this email are not necessarily those of the School.”

   _____  

From: itapps-bounces at edulists.com.au on behalf of Bane, Janet A
Sent: Tue 2/19/2008 3:17 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: RE: [Year 12 IT Apps] problems with access switchboard

Thanks so much Nick and Richard.  This is why I love this list!

Janet Bane
Patterson River SC

   _____  

From: itapps-bounces at edulists.com.au on behalf of Lumsden, Richard G
Sent: Tue 19-Feb-08 1:09 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: RE: [Year 12 IT Apps] problems with access switchboard

This happens when the Kids (logically) use cut and paste from the first
button they draw on the form.

Each Button must be drawn separately and named accordingly to prevent this
type of problem

   _____  

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
On Behalf Of Bane, Janet A
Sent: Tuesday, 19 February 2008 12:22 PM
To: ITA List
Subject: [Year 12 IT Apps] problems with access switchboard

Hi,

we are doing Access at the moment and some kids are having problems with the
switchboard form.

We know how to do it, it just seems that one minute the buttons are working,
and the next minute we get all sorts of error messages.  The messages are
not helpful in explaining what the problem is.  In fact they make no sense
at all, from what I can see. However, some kids sail through the switchboard
without a problem, and they are following the exact same procedure.

I am not strong in Visual basic, but the error messages seem to relate to a
problem when the click event occurs.  It seems to think all the buttons are
the same (or have an ambiguous name) even when they are linked to different
reports and forms (and the button names are all different and appear to me
to be quite sensible).  Is there a limit on the length of the button name or
some protocol I am not following?

Is there some trick to preventing this, or is it just "Access being
difficult"???? Any suggestions greatfully received.

regards,

Janet Bane
Patterson River SC

Important - This email and any attachments may be confidential. If received
in error, please contact us and delete all copies. Before opening or using
attachments check them for viruses and defects. Regardless of any loss,
damage or consequence, whether caused by the negligence of the sender or
not, resulting directly or indirectly from the use of any attached files our
liability is limited to resupplying any affected attachments. Any
representations or opinions expressed are those of the individual sender,
and not necessarily those of the Department of Education and Early Childhood
Development.

_______________________________________________ 
HYPERLINK "http://www.edulists.com.au/"http://www.edulists.com.au - FAQ,
resources, subscribe, unsubscribe 
IT Applications Mailing List kindly supported by 
HYPERLINK
"http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html%20"h
ttp://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html -
Victorian Curriculum and Assessment Authority and 
HYPERLINK "http://www.vitta.org.au/"http://www.vitta.org.au - VITTA
Victorian Information Technology Teachers Association Inc

Important - This email and any attachments may be confidential. If received
in error, please contact us and delete all copies. Before opening or using
attachments check them for viruses and defects. Regardless of any loss,
damage or consequence, whether caused by the negligence of the sender or
not, resulting directly or indirectly from the use of any attached files our
liability is limited to resupplying any affected attachments. Any
representations or opinions expressed are those of the individual sender,
and not necessarily those of the Department of Education and Early Childhood
Development.

_______________________________________________ 
HYPERLINK "http://www.edulists.com.au/"http://www.edulists.com.au - FAQ,
resources, subscribe, unsubscribe 
IT Applications Mailing List kindly supported by 
HYPERLINK
"http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html"http
://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html - Victorian
Curriculum and Assessment Authority and 
HYPERLINK "http://www.vitta.org.au/"http://www.vitta.org.au - VITTA
Victorian Information Technology Teachers Association Inc 

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au - VITTA Victorian Information Technology Teachers
Association Inc
--
Message protected by MailGuard: e-mail anti-virus, anti-spam and content
filtering.
http://www.mailguard.com.au/mg

Click here to report this message as spam:
https://login.mailguard.com.au/report/1ut4WeBYmw/4UroNKPUJlKDG2n4mhIjYq/2.00
1

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.20.6/1282 - Release Date: 15/02/2008
7:08 PM

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.20.6/1282 - Release Date: 15/02/2008
7:08 PM

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 19634 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20080219/ce057c64/winmail-0001.bin