[Year 12 IT Apps] Access qn..

[Pamela Wright]

WARNING: This e-mail has been altered by MIMEDefang.  Following this
paragraph are indications of the actual changes made.  For more
information about your site's MIMEDefang policy, contact
Mail Administrator <postmaster at edulists.com.au>.  For more information about MIMEDefang, see:

            http://www.roaringpenguin.com/mimedefang/enduser.php3

An attachment named DOBTEST.mdb was removed from this document as it
constituted a security hazard.  If you require this document, please contact
the sender and arrange an alternate means of receiving it.

-------------- next part --------------
Hi Kent,
I've had a go and have managed to do something quickly in query. I've
zipped and attached. Hope it helps.

Pam
Pam Wright
Lecturer ICT
Faculty of Education
La Trobe University 

-----Original Message-----
From: Kent Beveridge [mailto:kbeveridge at stbc.vic.edu.au] 
Sent: Wednesday, 20 February 2008 12:43 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: RE: [Year 12 IT Apps] Access qn..

Thanks for all the ideas folks.
The common approach seems to be via a 'form'...that one works well in
its varying flavours as suggested on the list. And yes, I did get the
'form' version working even before I put the qn on the list.
Unfortunately, what I cant get to work is (if you can picture
this...)...
A column in a table is headed DOB
Another column in the same table is headed AGE Data from the sample
database sheet is entered which includes DOB field for all the records.
My so far unsuccessful attempts are to try to get the database to
'automatically calculate' the AGE, given the data in the DOB field via
the table.
I guess that since I also tried, again unsuccessfully, this via a query,
that is why most of the suggestions are query or form based.
 
I must be holding my jaw wrong!
 
But I aint giving up just yet..(knew there was a reason computers annoy
me!).
 
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 Hammond Kerrie
Sent: Wed 2/20/2008 11:01 AM
To: itapps at edulists.com.au
Subject: [Year 12 IT Apps] (no subject)


Hello folks
 
 
I was wondering if someone could forward me the SIMCO access example
that people have been referring to. I am new to teaching ITapps this
year and would be very appreciative of this or any other relevant
examples that I could use with my students. 
 
As a "silent" observer to the list I would like to thank the regular
contributors who are so generous with their resources and expertise.
 
Many thanks
Kerrie Hammond
Trinity College Colac
 
_______________________________________________
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