[Year 12 IT Apps] Access qn..

Thu Feb 21 08:43:17 EST 2008

Hey Jock,
you may have just answered my problem by that snippet of info! 
My form version works, still battling with the query version but tiring of it.

You know its tough when a kid says(with a smile on his face).."Hey Mr.B..If you cant solve it, how are we supposed to? "  ah, ya gotta luv it!   

Mind you, I have in the last 72hrs I've learned a lot about the expression builder in access!!

Kent.
Again, to all who tried for me, thanks for the ideas guys and gals..

til the next qn...

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 Jock Garnsworthy
Sent: Wed 2/20/2008 8:24 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] Access qn..

Kent,
As far as I know, and have ascertained over the years, Access will not allow a calculated field in a table. Hence it must be done via a form or a query. Must admit I haven't had this confirmed or denied by an Access Guru as yet !

Cheers,

Jock
__________________________
Jock Garnsworthy
Pasco St. 
Williamstown High School
(03)93971899

On 20/2/08 12:42 PM, "Kent Beveridge" <kbeveridge at stbc.vic.edu.au> wrote:

	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/>   <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> <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/>   <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 Williamstown High School._______________________________________________ 
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: 10694 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20080221/babbeb0c/attachment.bin