At this meeting Ed Adamthwaite started with a presentation on the Access Object Model 
and how to use the object browser to help with properties and methods when writing 
code.  

John Bills-Thompson had more discoveries about ActiveX controls to share with us. His presentation 
was about the Treeview control. It is known to most computer users but few would 
recognize it by name. The places where this control could be used is only 
limited by one's imagination.

Craig Evans's problem solving covered many topics...


Greetings experienced programmers .... newcomers .... those in between .... 
at our last meeting we discussed :

Printing a single record from a form to a report.  Set the ControlSource of the report 
text boxes to reference each field on the form eg. =[Forms]![SampleForm]![tboRecordID]

Tidier code for moving between records.  This was emailed to interested parties & revolved 
around a subroutine structured as : Sub GoToRecord(oForm As Form, WhatRecord As AcRecord)

Code for working with Classes.

The main techniques for error handling.  Illustrative code was emailed to SIG users.

Most of the above was demonstrated on a fully active database.

For more solutions & amazing discoveries drop in to the Access S.I.G., second Monday of 
the month except January - 6:30pm to 8:30pm.
All problems readily accepted.  If you are not completely satisfied with our solutions 
we will happily return your problems with a smile & no questions asked :-)

You will benefit most if you are currently working on a database - but don't let that 
deter you from coming along. Bring your database with you and we'll probably fix it on 
the spot.

Remember : All the solutions are simple - some just take longer to figure out.