[Year 12 IPM] Potts Text IPM Access db Sample

[Chris Valmadre]

Sorry James - I'm probably showing my level of ignorance here but I didn't use a query to build the form.

The Main form can be edited through Design View. If you need more control, go to Tools/Startup and change the settings.

Hope this is helpful.

Chris

-----Original Message-----
From: ipm-bounces at edulists.com.au [mailto:ipm-bounces at edulists.com.au]On
Behalf Of Lawson, James
Sent: Tuesday, 12 July 2005 3:11 PM
To: Year 12 Information Technology Processing and Management
Teachers'Mailing List
Subject: RE: [Year 12 IPM] Potts Text IPM Access db Sample


Looks great, Chris.

Just a helpful tip for validation in the Table for those using Access.
You can use plain language to define the range.  

So instead of say >=0 AND <=99 you could type     BETWEEN 0 AND 99
(it is inclusive of the 0 and 99)

I liked the Form switchboard, but is there a way to edit the query from
it?

James


-----Original Message-----
From: ipm-bounces at edulists.com.au [mailto:ipm-bounces at edulists.com.au]
On Behalf Of Chris Valmadre
Sent: Tuesday, 12 July 2005 2:40 PM
To: ipm at edulists.com.au
Subject: [Year 12 IPM] Potts Text IPM Access db Sample

Hi All 

I thought I'd try completing the Ralph's Roofs example database project
in Potts as a tutorial for the students. 

Download available at http://www.edulists.com.au/yr12ipm/tutorials.htm 

Please excuse any errors as I'm a bit of a novice with Access. 

Chris Valmadre 

St Joseph's College Geelong
Ph: (03) 52268142
Fax: (03) 52216983
email: chrisv at sjc.vic.edu.au
school web: www.sjc.vic.edu.au 

_______________________________________________
http://www.edulists.com.au <http://www.edulists.com.au> - FAQ,
resources, subscribe, unsubscribe IPM Mailing List kindly supported by
http://www.vcaa.vic.edu.au <http://www.vcaa.vic.edu.au> - Victorian
Curriculum and Assessment Authority and 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
IPM Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc