Home | About | Resources | Contact | Partners
MUST Logo

Support Articles and Published Papers Discussing General Access Development Issues

Techniques
  • Highlight Current Record in an Access Continuous Forms
    This article shows how to create a coloured bar which highlights the current record being display in a continuous form.

  • Query By Form & Query By Where
    This is one of the classic techniques which made Access a Killer Application, you start with Query By Form and then with a sprinkling of VBA code move on to programming the result using a where clause.

  • Recordsets & QueryDefs
    Recordsets and querydefs are the bread and butter method of Access programmers, the simplicity and power of these techniques are awesome, this is where you start to realy appreciate the phenomenal power of Access.

  • Creating Tables using DDL, DAO and ADOX
    This article discusses the use of several different techniques which can be used to create tables; DDL, DAO and ADOX.

  • Domain Functions
    Domain functions are a double edged sword in your arsenal of techniques, when used correctly they enable the quick retrieval of data, used incorrectly they can cause performance overheads.


Application Administration


Access 2010 Web Databases