How to create a simple Add-to Combo Box. Access archon #161 Introduction Back when my Access Archon column appeared in Office Watch (around 1998), and there were no code samples, in Access Archon #7 and #8 I described how to create add-to combo boxes that let users enter new
How to format text in a memo field using an Access add-in. Q: Michael Masson writes: I am re-working an existing SQL 7 database to MS Access 2003. The data translation etc is OK if a bit hairy at times. I am using this database as a model for a
How to preview reports when running a database on a laptop not connected to a printer. Q: Gregory Hoffman asks: Is it possible to view reports when running a database on a laptop not connected to a printer? A: Yes, so long as you have installed the printer driver on
A reader’s trying to add info to a query but keeps getting a message “Recordset Not Updateable”. Q: Roger Fisher writes: “I have an Access 2000 database that has a form that is based on a select query. When I try to type in a field on the form I
Here’s some Explorer-type interfaces for finding records in Access tables. Q: Tom Gerry asks: “Is there any way to create an Explorer style cascading folders user interface to find records in an Access Table?” A: The closest to this would be a TreeView control used as a record selector. I
Option Explicit – to use or not to use? Q: Matt Perelstein writes: “I was wondering what you thought about using Option Explicit? It used to be a default, included with each module, but I noticed that in Access 2003, it’s not any more. I’ve used it religiously for years,
How to customize menus/toolbars so the full menu always shows. Q: Bob R. writes “I just got a new computer with Office 2003 pre-installed, and when I open a menu in Access (or any other Office app, for that matter), I just see a few commands, and I have to
The meaning of the word “Me” in VBA code. Q: Stuart E. Wugalter asks what is the meaning of the word “Me” in VBA code? A: Me is an Access keyword that refers to the form (or report) from which the code is running. There is also a Parent keyword
How to use conditional formatting to change the color of the highlighted record in a tabular form. Q:Ashjan Al Mahmeed wants to know how to change the color of the highlighted record in a tabular form.A:This can be done with conditional formatting (a feature added to Access in Office 2000).
A reader’s having some problems after installing Access 2000 over Access 97. Q:Bob Timms wrote to say he was having problems after installing Access 2000 over Access 97. A:If you don’t need to use Access 97 any more, it is advisable to first uninstall it, then install Access 2000, but
A little ‘mistake’ by sales staff can cost the unwary serious money plus other Win7 buying tips. We don’t normally delve into the world of Windows but a visit to some big electronics stores revealed a nice little ‘earner’ for the store and Microsoft. Lot’s of people are heeding the promotions
One thing is difficult in the Apple Store – buying stuff I went to an Apple Store today to buy an iPod Nano but struck surprising difficulties. Apple Stores have gained a good reputation for bringing and keeping people in the Apple fold. There are knowledgeable people there who will
From: Certiport Kankawin Kowsrihawat demonstrates unparalleled prowess to top largest field of competitors ever in annual Worldwide Competition on Microsoft Office. Certiport today named Kankawin Kowsrihawat, 17, from Thailand this year’s World Champion in Word 2007 for culmination of the most prolific competition on Microsoft® Office to date. In its
A new ebook on using Microsoft Access to make great Word documents. Office Watch and Helen Feddema are delighted to announce the publication of a new Office Watch ebook especially for Microsoft Access users. Access Archon – Working with Word by Helen Feddema, editor of Access Watch. Like
More solutions to Access AutoNumber problems. I have received several more solutions to the AutoNumber problem discussed previously with the Access Archon article “Recovering from an AutoNumber Disaster.” With these solutions, and the ones in the last AW, you should be able to find some solution that works for you,
How to use the Outlook View Control on an Access form When Office 2000 was introduced, and the Outlook View Control first became available, I tried it out, but found it so buggy and difficult to work with that I set it aside as unusable. Recently, I decided to try
A look at the ribbons and menus in the next version of Access A look at the ribbons and menus in the next version of PPT. We’ve already looked at Word 2010, Excel 2010, OneNote 2010 and Outlook 2010 plus the new look Office button menu. These sneak peeks into the Office
From: ODF Alliance ODF Alliance Finds Substantial Improvements Needed for Real-World Interoperability The OpenDocument Format (ODF) Alliance today cautioned that serious deficiencies in Microsoft’s support for ODF needed to be addressed to ensure greater interoperability with other ODF-supporting software. “Support for ODF represents an important and ongoing test of Microsoft’s
How to put an UpDown control on an Access form, and use it to change the value of a number or date. Access Archon #175 Introduction The UpDown control (formerly called the SpinButton control) has been available since Access 97, at least if you bought the Developer Edition of Office.
Q: Dawn Crosier writes: I read through your “Access 2007 VBA For Data-Centric Microsoft Office Applications” and have questions about how to get formatted text out of the Access database into a Word Bookmark without bringing all the HTML code. A: I did some experimentation, using my Rich Text Demo
Several readers responded with more information on what causes this problem, and how to recover from it In response to AW 9.16, with the Access Archon article “Recovering from an AutoNumber Disaster,” several readers responded with more information on what causes this problem, and how to recover from it. Access
Helen Feddema of Access Watch fame has released a new version of her famous Time & Expense Billing Application for Office. The Time & Expense Billing application consists of an Outlook custom Journal form and five sets of Office version-specific documents; each set includes a Word setup document, two Word
From: Microsoft Microsoft Office Visio 2007, Every Picture Tells a Richer Story- a Microsoft Q & A Richard Wolf, general manager of the Microsoft Office Graphics Division, highlights new data visualization capabilities in the upcoming release of Microsoft Office Visio that will enable business and IT professionals to more easily
How to programmatically change custom document properties in Word – and and example of why you should not trust Microsoft help files! I have received a number of messages from readers (Word guru George Mair was the first) informing me that I was mistaken in saying the Word custom document properties collection
