Simply Interactive:
Miscellaneous

Miscellaneous Topics

These guides cover a variety of topics. Some, e.g. the Login System, are full scale mini-projects. Others, e.g. Playing Sounds or Counting Intervals are left-overs from other projects. Both can be useful procedures to incorporate into Access projects.

I have included them here because there was little to be found about them the web at that time. Counting Intervals is my own invention. There are probably better ways to do this!

The Flicker Book was just an exercise in seeing how fast an Access table would cycle through a list of records. Fast enough for some basic stop frame style animation. OLE fields mean that each frame can be individually edited so it really is a very simple animation editor.

All these activities can be fun. The exception may be the topic 'Disabling the mouse wheel' in Access which is a little technical. The source notes for this are provided here because the mousewheel can be a nuisance in some contexts. You may like to know how to turn it off in Access.

MS Access

  
  • General tip: set your databases to automatically compact on close. Access file sizes can become bloated. Set this option with Tools > Options > General > 'Compact on Close'

Nov 2004. Recently revised, Dec 2005. Useful project. Workshop notes tested by students.

Technique for getting better sound from your database. Workshop notes first draft 1/05.

  • Counting intervals -------------------

Sometimes you want a timer or interval counter. Here's one way to do it without using VBA.Workshop notes first draft 1/05.

  • Flicker Book --------------------------

Uses OLE fields with pictures to display frames rapidly. Uses a variant of counter. Feb 05

A minor nuisance in some situations, the mousewheel can be disabled with these materials. Local copy of resources from Web.