Validating ISBN
  • A function to check whether an ISBN number is valid.
Checking security group membership
  • Pass this function the name of a security group and it will return whether or not the current user is a member.
Counting the number of weekdays between two dates
  • ...because Access 97 and below doesn't have the NetworkDays() function you might recognise from Excel.
Calculating the median of table data
  • A function to determine the median of a field in a table, something the MEDIAN() function doesn't do.
Sending an e-mail from Access
  • Forget using SendObject or Microsoft's alternative - here's a feature-rich alternative, using Outlook.
Running parametised queries
  • How to supply a parametised query with a parameter value when calling it from code.
Faster recordset iterations
  • How to loop through recordsets and do something with the contents 20+ times faster than you thought possible!
Control Access options at start-up
  • Enforce your preferences on users! How to set options for tracking changes and showing multiple taskbar windows with VBA.
Changing the default printer
  • Changing the default printer in code (and changing it back again!).

Great Tea will power anything!

Site requires Javascript and IFRAME support.
Visitors:
© Accessory 2001-.
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 2.5 License.