How to successfully merge data from Access to Word. Q: Bruce Michael writes: “I have been attempting to do a merge in Word 2003 using an Access 2003 query. When I look in the query, the data is correct, but when I actually merge using the data, for one column
A tip to keep in mind when copying queries to another database. Queries copied to another (transfer) database may lose their links. Try including the tables in the transfer.
Using the Size to Fit Form. Q: Peter Farren writes “I would be grateful if you could clarify for me usage of the acCmdSizeToFitForm constant. For example, the Load Event of frmInvoices in Archon Column 114 consists of: DoCmd.RunCommand acCmdSizeToFitForm I assume that the RunCommand method is applied
How to make the cursor go to the first column in the new record row. Q: Henry W. writes that he needs to move the cursor to the first column in the new record row of a datasheet subform, from the AfterUpdate event of a combo box that assigns a
Here’s a function to determine whether a database exists on a network drive. Q: Glenn Faber writes that he needs a function that determines whether a database exists, on a network drive. If it exists (i.e., the network drive is available), a number of instructions will be run; otherwise, they
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
Version 10 of Total Access Analyzer is out now, ideal for anyone who develops in Access. FMS has released v. 10 of Total Access Analyzer, the premier product for analyzing Access databases. This version supports Access 2002, both for Access 2000 and Access 2002 formatted databases. Track down those unused
How to document an application in Access. Q: Ashjan Al-Mahmeed would like to know what is the best practice of documenting an application in Access (using the documenter and other tools). A: I recommend Total Access Analyzer, which is available in versions for Access 97, 2000 and 2002. See the
How to change multiple object icons to just one Access icon that represents the database. Q: Sally Q. writes: “I am using Access 2002/Windows 2000, and instead of a single Access icon on the taskbar, I see several different icons, apparently representing every open object in the database. This is
This is the book you need for all those situations when Access security is required. access archon #120 Introduction I have always hated Access security. It is a pain to secure a database, and a nightmare to modify a secured database – and, after all that trouble, the database
A reader reported that the Office XP templates for my Time & Expense Billing application don’t work in Office 2003, so I’ve provided a new set. Dan Gifford wrote to report that the Office XP templates for my Time & Expense Billing application (Code Sample #29on my Web site) don’t
Here’s a brief overview of my latest book, Expert One-on-One Microsoft Access Application Development. I wrote my latest book (Expert One-on-One Microsoft Access Application Development, Wrox) for experienced Access users, who know how to create tables, queries, forms and other Access objects, and have some familiarity with writing Access VBA
How to email attachments using the Redemption Library – and avoid the Object Model Guardian. Mark Riddick wrote in response to Access Archon #114, Avoiding the Object Model Guardian with the Redemption Library, asking how he could email report snapshots using the Redemption Library (he used to do this with
How to display data from other fields in the same record that’s selected in a combo box. Q: Robert Colum wants to know how to display data from other fields in the same record that is selected in a combo box. A: This can be done easily using the Column
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 get group headings to repeat for groups that extend over several pages. Q: Saul writes that he is having problems with getting headers to repeat on each page in a report. A: To get group headings to repeat for groups that extend over several pages, set the Repeat
How to reference specific fields in an Access query. Q: Lee Aldrich wants to know how to reference specific fields in an Access query/dataset. A: In VBA code, you can set up a DAO recordset to work with Access data, using the following syntax (the example sets two variables
A reader wants to know how to get a report to display just the items related to a specific order. Q: George Adams is having a problem with getting a report to display just the items related to a specific order. How can this be done? A: You need
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
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 shrink up the blank spaces on reports. Q: Randy writes: “I was wondering if there was any way I could shrink up the blank spaces on a report. The CanShrink Property just kinda shifts the blank spaces from the bottom of the detail section to the top in
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
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
How to get a return value of the number of full years elapsed between two dates. Q: William Butler writes: “I have been working on this problem all day, writing an expression in a query to show the difference between today’s date and one that just passed. It seems it