How to get accented characters in Access fields. Q: Ray Bona wants to know: “How can I get an accented character (e.g. e-acute, n with a tilde, or o with an umlaut, etc.) in text that I enter in an Access field?” A: One way is to create the accented
Readers offer their solutions for calculating total hours. Many readers have contributed better (or at least different) functions or expressions as alternatives to the rather awkward method I described in AW 7.04. Here they are for your consideration, with my comments. (Bill Patterson’s contribution was described in AW 7.10). For
Looks at the different types of item counts you can get for listboxes and combo boxes. Access Archon #132 Introduction Recently I received some emails from AW readers requesting help on counting selections in listboxes and combo boxes. This article deals with the different types of item counts you
How to deal with unwanted or redundant indexes. While reading my new book, Expert One-on-One Microsoft Access Application Development, Garry Robinson (see my review of his Access Security book in Access Archon #120) wrote to point out that I didn’t mention that giving fields the suffix “ID” can result in
How to group database objects in Access 97. Q: Ron McIntire would like to be able to group database objects in Access 97, similar to the built-in feature in Access 2000 and higher. Is there any way to do this? A: This could be done (in a limited fashion)
Using the FindFirst method in a DAO recordset. Q: Peter Lucero is having problems using the FindFirst method in a DAO recordset based on a table, using the following syntax: Set Rst = dbs.OpenRecordset(tablename) A: This is because when you create a DAO recordset based on a table, without
How to print a report footer “page X of Y”, where X is the current and Y is the total. Q: Don Fox wants to know how to print a report footer “Page x of y”, where x is the current page and y is the total number of pages.
Here are a couple of methods for creating calculations in queries vertically. Q:Gang Wei writes to ask whether it is possible to create calculations in queries not only horizontally (like Total Cost: [UnitPrice] * [Quantity]), but also vertically, pulling in data from multiple rows. A:Yes, this can be done in
Access Archon #172 Using the AddItem and RemoveItem Methods The frmPairedListboxesMethodsUnsorted form uses the new AddItem and RemoveItem methods to move items from one listbox to the other. You can’t simply iterate through the ItemsSelected collection of the listbox, and use the appropriate method, since using AddItem or RemoveItem
Microsoft Australia is trying to lure Aussies to buy Office 2007 with petrol. Down in Australia you can buy Office 2007 and get money back for petrol see Office 2007 plus petrol
Q: Bradley Wellard writes: “I am still a bit of a novice and have been attempting to find some useful information on how to apply/use ActiveX controls in Access with little success. I am particularly interested in any information regarding the Microsoft ImageCombo Box control V.6. Are you aware of
How to get Access add-ins to work in Access 2007 running on Windows Vista. Access Archon # 162 Introduction I have add-ins that were originally developed in Access 97 that have worked in all versions up through 2003, and others that had features new to Access 2000 or Access
A look at the Extras Add-in which combines the functionality of backup and field listing. Access Archon #155 Introduction In previous articles, I described a set of objects you could import into any Access database to do database backup (Access Archon #151) or list tables and queries and their fields
Here’s a quick solution to get databases linked again if the Linked Table Manager is missing from the Database Utilities menu. Q: Jeanne M. writes: “I sent new back-end and front-end databases to a client, and told him to re-link the front-end to the back-end, but he said there was
Here’s how to make a reminder automatically pop up with a MessageBox when a date has expired. Q: Martin writes: “I keep trying to make a reminder that automatically pops up with a msgbox when a date has expired, but no luck… If cboPartshøringSlut >= Date Then MsgBox “Partshøringen
More on creating mass emails with report attachments. Access Archon #135 When the database is opened, the CreateSnapshots procedure is run to automatically create report snapshots for the four reports in the database, in the DocumentsAccess Merge folder (this folder will be created if it doesn’t already exist, using methods
Looks at importing Excel data to Access databases. Q: Graham Alison has two Excel workbooks, and when he imports them into an Access database, he just gets the data, not the formats that make the spreadsheets work. A: Data is all you will get when importing from Excel. If you
How to format times and/or dates in the way you want to see them. Q: M. Schiller wants to know how to convert a time to the 12 hour time format. A: There is no need to convert – just use the Format function to format dates and/or times in
Here’s the code to use to email Excel worksheets (using the Word envelope object). Access Archon #122 Access versions: 2002 and 2003 In Part I of this article I discussed how to use the Word envelope object to email Word documents and Excel worksheets, thus avoiding the pain of attachments
How to auto-populate City and State fields on a form when the user selects a Zip Code. Q: Joe O’Meara wants to auto-populate City and State fields on a form when the user selects a Zip Code. How can this be done? A: Here is a procedure that updates
How to get full justification in a Memo field on a form. Q: Bronwyn Pugh writes to ask if there is a way to get full justification in a Memo field on a form (no jagged right edge).A: From Access 2000 on, there is an alignment selection (oddly named Distribute)
A reader wants to know if there’s a tool that sets up code for error handling. Q:Stephen Young writes to ask whether there is a tool for Access that sets up the code for error handling in a function or sub. A:There is no built-in tool for this purpose in
How to find Outlook mail messages from a specific sender. Q: Ray in New Zealand writes: “I’m trying to link my Access db (Accommodation) to Outlook. I receive accommodation bookings from guests and would like to be able to click on a button on the guest data form which will
Access Archon #170 Introduction Several earlier Access Archon articles have dealt with various aspects of mass emailings. In Access Archon #106 I described how to send mass emailings from an Access table, in Access Archon #135 I described how to send reports as attachments for a mass emailing, and in
