How to use records selected in a recordset as the record source for the Detail section of a report. Q: Mark Jackson writes to ask if records selected in a recordset can be used as the record source for the Detail section of a report. A: I think the best
How to ensure Access Watch isn’t mistakenly marked as spam in Outlook. Sometimes Office Watch newsletters end up in the Junk Email folder, it might seem like a conspiracy by Microsoft but it’s probably not. You can tweak the Outlook spam filter to ensure Access Watch isn’t mistakenly marked as
How to merge data from linked tables Q: Lisa Hartley writes: I’m planning to use the code in code2.zip to merge data from Access into word documents. Could you please give a couple lines of sample code which would tell me how to get data from a related table. In
How to rename files in a folder. Q: Richard Bryant writes: I have written the following code to change the name of files imported as .tif files from the county deed books for use by my Access program. Private Sub Command2_Click() Dim Path1 As String Dim Path2 As String Dim
The correct code to run when you want to add a record to a table with a value from a form. Q: Sarah Balthazor writes that she is getting an error message when trying to run the following code, intended to add a record to a table with a value
How to open a form record from a listbox selection. Q: Martin Wichmand is trying to open a form to a specific record from the DblClick event of a listbox, using the ID primary key, but he can’t make it work with the following procedure: Private Sub lstMandag_DblClick(Cancel As Integer)
How to throw up a flag if someone’s editing an existing record. Q: Julie Garret writes to ask if there is a way to throw up a flag if someone edits an existing record. A: On a bound form, you can use the form’s BeforeUpdate event for this purpose. Here
A reader wants to know where to find Functions information for more recent versions of Access. Q: Marty Nizlek writes: “In Access 97 one could easily find a summary page listing Functions alphabetically. As well, there was the ability in the Builder Wizard to select a function, then hit help,
How to make the combo box display the DistrictName value when the combo box is closed. Q: Mary V. writes: “I have a combo box that is bound to a DistrictID field, but the drop-down list shows a descriptive field, DistrictName. (The column widths are 0; 2). This works fine
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
How to create a functional drop-down list control on an Access toolbar. Q: Charles Duwel wants to make a custom toolbar for an Access 2002 form, with a drop-down list control. He tried dragging a combo box to a toolbar, but it just worked like a button. Is it possible
Here’s a simple procedure for exporting information from a table to an Outlook calendar. Q:Elizabeth Moeck wants to know if class name and date information stored in an Access table can be exported to an Outlook calendar A:Here is a simple procedure that does this: Dim dbs As Database Dim
A handy solution to the problem of disappearing form view headers and footers. Q: Bob writes that in Access 2003, when he is working on a form in design view, and turns on form headers/footers (using the View Form Header/Footer menu command), often the header and/or footer section doesn’t show
How to change back end database structure. Q: Peter Matthews writes: “If you have split a data base, and then decide to change the data structure – say to add some extra information to a table – is this a problem? There does not seem to be any way of
How to merge data from a recordset based on a query to Word documents. Access Archon #168 Introduction An AW reader wrote to me asking if the document properties merge code in my Code Sample #24could be modified to merge data to Word from a query, instead of selections
How to update Word fields in documents created from Access Mergee. Q: Richard Lally writes: I am very interested in trying the Mail Merge method you suggest but I am anxious about one thing. The templates include a number of fields that need updating when a document is created from
How to use Rich Text in memo fields in Access 2007. Access Archon #157 Introduction Over the years, the functionality of Access forms and reports has been significantly upgraded. In Access 2007, one long-requested feature has finally arrived in a workable form (I recall an early and unreliable implementation that
How to ensure leading zeroes are not discarded. Q: Albin Moroz wrote me to say that he is having problems keeping the leading zeroes in U.S. Social Security Numbers (SSNs). He was using the expression Format(Nz(patientRS(patient.SSN), “”), “###-##-####”) which discards leading zeroes. A: Instead of the # placeholder, which discards
How to export data that’s to be archived to an Excel worksheet, and then remove the exported records from the Access tables. Access Archon #143 The procedure that exports the data to be archived to an Excel worksheet, and then removes the exported records from the Access tables, is listed
A reader offers another method for automatically backing up databases, one which runs every time the database starts. In response to my update on backing up Access databases in AW 7.14, Wim Vermeer contributed his routine, which runs every time the database starts. It will make a backup folder (if
A reader’s method for calculating total hours. Bill Patterson responded to my request in Access Archon #129for alternate (possibly simpler) methods of calculating total hours. I used a series of calculated fields in a query to do the calculations; by contrast, the Nearest_Time function listed below does all the calculations
Here’s a way around an error that can sometimes occur with the IsLoaded property. Q: Chuck Tucker writes that he is getting an error on the IsLoaded function reference in a code sample from my book, Access 2002 Inside-Out. A: IsLoaded is a function that comes with the Access sample
Using the Office Envelope Object in Office 2000 – what works and what doesn’t. Some readers have asked whether the Office Envelope Object (featured in Access Archon #122) can be used in Office 2000. Well, sort of. While writing the article, I tested the two procedures in Office 2000 and
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