The Quick Access Toolbar (QAT) is located on the left side of the Word, Excel, PowerPoint or Outlook title bar. You can add commands, options and even symbols for easy and quick obvious access By default, the QAT only has Save, Undo, Redo and Touch/Mouse commands but you can cut down on unnecessary keystrokes by placing […]
Q: Susan H. writes that she has some standard code that creates a Word document and puts some Access data into it, using VBA Automation code. But sometimes the Word window is hidden behind other windows, either the Access window itself or some other window. A: This is a long-standing problem in Office Automation. Many […]
Q: Lou writes that sometimes when he clicks on a label in Design view, in order to change the caption, it displays with a dark back color, which is disconcerting. The Label control’s BackStyle property is set to Transparent, so it shouldn’t be displaying as a color. How can this be fixed?A: This can happen […]
Back in Access 2003, you could easily change the font name and size for a datasheet form by clicking the square in the upper-left corner of the datasheet (in datasheet view), and selecting the font and size from the selectors on the Formatting toolbar, or by selecting Font from the Format menu. But these features […]
If you need to create a filter string for filtering by a person’s name, or a city name, you may run into this error: This is because single quotes are used as the delimiter for Text strings, and there is a single quote in the city name. To get around this problem, make a calculated […]
