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 Filename 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 from a form: Dim […]
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 […]