How to display linked records before deleting them. Access Archon #147 — The VBA code for the command buttons is listed below: VBA Code frmOrderCleanup Private Sub cmdDeleteOrder_Click() On Error GoTo ErrorHandler Dim strPrompt As String Dim strTitle As String Dim intReturn As Integer Dim strQuery As String […]
How to insert a progress bar into an Access application. Q: Martin Wichmand writes: “I looked in your site for at simple example with a progressbar – have you made one? You know like the progressbar fx shows how many days since current a day have until a deadline in fx 90 days – with color.” A: […]
Shows some more options that are available to you when using the Printer Object. Access Archon #131 The AssignPrinter procedure given in Part 1 of this article will do fine if you need to ensure that a specific report will always be printed to a specific printer (especially if you want to print the […]
How to convert Access data from a newer version so it can be viewed in an earlier version. Q: Linda Vazquez was sent an Access 2003 database, but she has Access 2000. Is there any way to open this database, even just in read-only mode? A: If you have Access 2003 installed (say on another […]
How to rename the column headings for combo box columns. Q: John V. wants to be able to give the column headings for combo box columns the names he wants – not just pick up the field names. A: This can be done by entering the column heading text you want in the Caption property […]