Blog

Learn Access collects the tutorials and these posts in one list.

• Many-to-Many Is the Future

  A tenuous link between the news and your Access tables: one-to-many broadcasting, many-to-many communication, and why the junction table is the part to own.

• The Combo Box That Taught Me VBA

  A gravel company, Pythagoras and a combo box sorted cheapest first. How changing a RowSource got me writing VBA, plus three small combo box wins to try.

• The First Database

  Why a firm still needs books even when the clerk is an AI. Writing began as bookkeeping. Stonebraker, Wissner-Gross, invoice 1042.

• CallCalled class module

  Popup caption from the calling control, Simulated After Update, and the full clsCallCalled VBA. Product page — listed here so you can find it.

• Advanced Message Box

  Built-in Access MsgBox with Yes / No / Cancel labels in the message, and Select Case that drives the next step. Product page — listed here so you can find it. On-site PDF walk-through.

• Nifty Switchboard Builder

  VBA, table-driven Microsoft Switchboard plus Tony's Builder UI. Open forms, reports, queries, macros, and VBA; reorder items; add pages. Product page — listed here so you can find it. Browser twin: Switchboard builder demo. Not the short runtime menu demo.

• Many to Many Relationship

  Students, hobbies, the junction table and a main form / subform walk-through. Product page — listed here so you can find it.

• Charity donor register (CCRM)

  A small UK charity CRM: who gave, Gift Aid CSV, help they will give, and how they want material sending. Treasurer language. Working demo next to the article.

• One lookup table, many drop-downs

  One tlkpInfo table, combo stores the ID, Edit, Hide Me, and a download of LookupCombo.accdb.

• Links

  Other Access developers' blogs, logs, and samples. Starts with George Hepworth, A Self-Graded Build.