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) DoCmd.OpenForm “Sagsstyring”, , , “ID”End […]
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 is a procedure that cancels […]
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, and the function’s definition would […]
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 for storing the right value […]
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 work in Office 2003. I […]