A presentation showing how to automate Excel and Word from Access was conducted by Ed Adamthwaite.
It was a bit complex, but showed how powerful the Office suite is.

Bob Powell followed with his first presentation for the gIt has a flat structure like Excel, but has very 
interesting methods for querying data.
This presentation was valuable for the members, showing a different approach to data.
We went overtime with the interest on this one. Well done Bob.

The question and answer session was conducted by Craig Evans:

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

Addressing/referencing records within a table.  Use a recordset to sort, locate & bookmark.

Formatting a field on a report based on the contents - eg background colour.  Place criteria in the Detail_OnFormat 
code of the report.

Conditional disable of buttons.  OnCurrent referred to the controlling field & dis/enabled.

Recordset description. Essentially an invisible query.  Good for behind the scenes interrogation as users have been 
known to destroy/edit visible queries.

Printing nothing when data is known to exist.  Single quotes were required within the SQL string retrieving the data.

Arrays.  Declare a variable : Dim MyVariable(1 To [n]) AS [Variant Type] : MyVariable(1) is always used to 
populate/calculate within the code & equals either MyVariable(2) or MyVariable(?) up to MyVariable(n) - store different values in each MyVariable(?) so essentially only one variable is declared instead of [n] variables.  One benefit is shorter code.

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.