News, links, downloads, tips and tricks on Microsoft Access and related
Wednesday, November 30, 2011
Wednesday, November 23, 2011
Multi-value Fields - Appending / Updating with query
Access 2007 introduced Multi-value fields (MVF), some people like it, some – hate it. I personally like UI for MVF in Access, but don't like realization in table level – you can't get access to junction table of MVF. Anyway - any Access developer have to learn working with it, sooner or later, and here something your can look at.
A.D. Tejpal, Access MVP, has published Multi-value Fields - Query Based Solution For Bulk Appending / Updating sample database, which shows several techniques to work with MVF.
Tuesday, November 15, 2011
Convert linked table to local
DoCmd.SelectObject acTable, "Company", True RunCommand acCmdConvertLinkedTableToLocal
Command is mentioned in Office Help, but not really documented. Thanks to fellow MVPs for pointing to it!
Thursday, November 03, 2011
Access source control software