<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
address
{mso-style-priority:99;
mso-style-link:"HTML Address Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
font-style:italic;}
span.HTMLAddressChar
{mso-style-name:"HTML Address Char";
mso-style-priority:99;
mso-style-link:"HTML Address";
font-family:"Calibri","sans-serif";
font-style:italic;}
span.emailstyle20
{mso-style-name:emailstyle20;
font-family:"Arial","sans-serif";
color:navy;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-AU link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi Kent,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Try this in the query<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Age: DateDiff("yyyy",[DOB],Now())<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Regards<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Julie<o:p></o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Kent Beveridge<br>
<b>Sent:</b> Tuesday, 19 February 2008 4:32 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> An access query question...<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div id=idOWAReplyText10418>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'>Ok folks, can I seek your help please about an on topic question?</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Currently
working through a sample database which many are probably familiar with. The
Simco sample task.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>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.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>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.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>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..</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Ok..so
I aint no genius...I know what I am trying to do...just falling a little short
here..</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Any
ideas folks?</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>HOWS
ZAT? Completely ON TOPIC...woohooo..</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Kent.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
</div>
<div id=idSignature67914>
<div>
<div style='margin-left:42.55pt'>
<p class=MsoNormal><strong><i><span style='color:blue'>Kent Beveridge</span></i></strong><i><span
style='color:blue'>,</span></i><span style='color:black'><o:p></o:p></span></p>
</div>
<div style='margin-left:42.55pt'>
<p class=MsoNormal><i><span style='color:blue'>I.T. co-ordinator</span></i><span
style='color:black'><o:p></o:p></span></p>
</div>
<div style='margin-left:42.55pt'>
<p class=MsoNormal><i><span style='color:blue'>St. Brigids Catholic Sec.
College</span></i><span style='color:black'><o:p></o:p></span></p>
</div>
<div style='margin-left:42.55pt'>
<p class=MsoNormal><i><span style='color:blue'>Horsham</span></i><span
style='color:black'><o:p></o:p></span></p>
</div>
<div style='margin-left:42.55pt'>
<p class=MsoNormal><i><span style='color:black'>email.. <a
href="mailto:kbeveridge@stbc.vic.edu.au">kbeveridge@stbc.vic.edu.au</a></span></i><span
style='color:black'><o:p></o:p></span></p>
</div>
<div style='margin-left:42.55pt'>
<p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p>
</div>
<div style='margin-left:42.55pt'>
<p class=MsoNormal><strong><span style='color:black'>|<3|\|7
b3\/3r1D93 ? ;-)</span></strong><span style='color:black'><o:p></o:p></span></p>
</div>
<div style='margin-left:42.55pt'>
<p class=MsoNormal><i><span style='color:black'>Wishes and Eggs, one you make
and one you break! A bit like promises.....</span></i><span
style='color:black'><o:p></o:p></span></p>
</div>
<div style='margin-left:42.55pt'>
<p class=MsoNormal><i><span style='color:purple'>“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.”</span></i><span
style='color:black'><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=2 width="100%" align=center>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> itapps-bounces@edulists.com.au on behalf of
Bane, Janet A<br>
<b>Sent:</b> Tue 2/19/2008 3:17 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> RE: [Year 12 IT Apps] problems with access switchboard</span><o:p></o:p></p>
</div>
<div>
<div id=idOWAReplyText31329>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'>Thanks so much Nick and Richard. This is why I <strong><span
style='font-family:"Arial","sans-serif"'>love</span></strong> this list!</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
</div>
<div id=idSignature93924>
<address><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:purple'>J</span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:yellow'>a</span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:red'>n</span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:fuchsia'>e</span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:lime'>t </span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:green'>B</span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:maroon'>a</span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:blue'>n</span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:aqua'>e</span><o:p></o:p></address>
<address><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:purple'>Patterson River SC</span><o:p></o:p></address>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=2 width="100%" align=center>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> itapps-bounces@edulists.com.au on behalf of
Lumsden, Richard G<br>
<b>Sent:</b> Tue 19-Feb-08 1:09 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> RE: [Year 12 IT Apps] problems with access switchboard</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>This happens when the Kids (logically) use cut and paste from the
first button they draw on the form.</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Each Button must be drawn separately and named accordingly to
prevent this type of problem</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN-US>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Bane, Janet A<br>
<b>Sent:</b> Tuesday, 19 February 2008 12:22 PM<br>
<b>To:</b> ITA List<br>
<b>Subject:</b> [Year 12 IT Apps] problems with access switchboard</span><o:p></o:p></p>
</div>
<p class=MsoNormal> <o:p></o:p></p>
<div id=idOWAReplyText34845>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'>Hi,</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>we
are doing Access at the moment and some kids are having problems with the
switchboard form.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>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.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>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 <strong><span style='font-family:"Arial","sans-serif"'>are
</span></strong>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?</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Is
there some trick to preventing this, or is it just "Access being
difficult"???? Any suggestions greatfully received.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>regards,</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
</div>
<div id=idSignature86940>
<address><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:purple'>J</span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:yellow'>a</span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:red'>n</span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:fuchsia'>e</span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:lime'>t </span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:green'>B</span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:maroon'>a</span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:blue'>n</span><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:aqua'>e</span><o:p></o:p></address>
<address><span style='font-size:13.5pt;font-family:"Verdana","sans-serif";
color:purple'>Patterson River SC</span><o:p></o:p></address>
</div>
<p><b>Important - </b>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.<o:p></o:p></p>
<p class=MsoNormal>_______________________________________________ <br>
<a href="http://www.edulists.com.au/">http://www.edulists.com.au </a>- FAQ,
resources, subscribe, unsubscribe <br>
IT Applications Mailing List kindly supported by <br>
<a
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html%20">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
</a>- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au/">http://www.vitta.org.au </a>- VITTA
Victorian Information Technology Teachers Association Inc<o:p></o:p></p>
<p><b>Important - </b>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.<o:p></o:p></p>
<p class=MsoNormal>_______________________________________________ <br>
<a href="http://www.edulists.com.au/">http://www.edulists.com.au </a>- FAQ,
resources, subscribe, unsubscribe <br>
IT Applications Mailing List kindly supported by <br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
</a>- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au/">http://www.vitta.org.au </a>- VITTA
Victorian Information Technology Teachers Association Inc <o:p></o:p></p>
</div>
</div>
</div>
<p></p><p><b>Important - </b>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.</p>
</body>
</html>