Q: Jane writes that when she makes a new form by clicking the Form button in the Create tab of the Ribbon, all the controls are the same width, and she can’t resize them individually, as in older versions of Access. A: This is a “feature” of recent versions of Access. It is called Layout, […]
Access Archon Column #237 By Helen Feddema Access versions: 2007-2013 Level: Intermediate The Problem Back in Access 2003 and Windows XP, it was easy to make a shortcut to open a specific Access database – just right-drag the database from an Explorer pane to the Quick Launch area of the taskbar. But if you try […]
Q: Andy Walter writes: I have been using your Function BackupBackend () for a few years now (Many many thanks) but recently I have had to password protect the backend of my database to stop Mr Sticky Fingers. Unfortunately with the Password in place, I get the following Error. Not only does it not create […]
By Helen Feddema Access versions: 2007-2013 Level: Intermediate Introduction Word has a sophisticated Table of Contents feature that automatically creates a table of contents from designated headings in a document. Access reports don’t have such a feature, but I managed to create one using VBA code, custom database properties and some Word features. The Orders […]
Q: Arne Johnston writes that he has four phone number fields in a table, but that is not enough. How can he handle this better? A: For phone numbers, emails and other IDs, a separate linked table is best. I have one with just three fields: CompanyID (links to the main table), Description, and IDOrPhone. […]
