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

Tue Feb 19 16:31:48 EST 2008

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.. 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.

_______________________________________________ 
http://www.edulists.com.au <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/infotechindex.html <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html%20> - Victorian Curriculum and Assessment Authority and 
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.

_______________________________________________ 
http://www.edulists.com.au <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/infotechindex.html <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html> - Victorian Curriculum and Assessment Authority and 
http://www.vitta.org.au <http://www.vitta.org.au/> - VITTA Victorian Information Technology Teachers Association Inc 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 12680 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20080219/0a6db2f5/attachment-0001.bin