My Top 10 Allen Browne Posts

I have a four-year computer science degree from the US Military Academy at West Point, but the bulk of my foundational Access knowledge came from one man: Allen Browne.

While Allen's site has not been updated in over ten years, I still feel it is the best one-stop shop on the internet for people of all abilities, with curated tips for "Casual Users", "Serious Users", and "Programmers."

Every article on Allen's website is top-notch, but these ten are my favorites:

1. Problem names and reserved words in Access
2. Common query hurdles / Why is my query read-only?
3. Common Errors with Null
4. Subquery basics / Surviving Subqueries
5. Extended DLookup() / Extended DCount()
6. Intelligent handling of dates at the start of a calendar year
7. Soundex - Fuzzy matches
8. Reports: a blank line every fifth record
9. Failures caused by Name AutoCorrect
10. Why I stopped using Yes/No fields

What about you?  What are your favorite Allen Browne articles?  Let me know down under in the comments (pun intended–Allen's an Aussie).

External references

Microsoft Access help, tutorials, examples

Free help and tutorials for Microsoft Access. Tips for beginners and database developers. Downloadable examples and utilities. Flaws, bugs, traps, code, design, queries, forms, reports, version and upgrade information.

Seeking the kingdom

What is God’s kingdom? . . . How do we seek it?

Seeking the kingdomAllen Browne