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
How to make invoice numbers automatically advance one number at a time. Q: Peter Lessey writes: I would like the invoice numbers to advance automatically one number at a time. Also to start from a preset number. Is there a way to do this? A: You can always use an
A reader wants to know if it’s possible to color every other line of a listbox. Q: Martin wants to know if there is a way to color every other line of a listbox. A: Not as far as I know, but it is possible to color cells in a
How to preview reports when running a database on a laptop not connected to a printer. Q: Gregory Hoffman asks: Is it possible to view reports when running a database on a laptop not connected to a printer? A: Yes, so long as you have installed the printer driver on
Looks at playing media files in Windows Media Player. Access Archon #138 Playing Media Files After (optionally) selecting a Media Path, and selecting an audio or video file, you can use the cmdPlayAudioFile or cmdPlayVideoFile buttons in the form footer to play the selected file. To illustrate two different
A reader has provided this helpful code that allow user’s to add multiple attachments. In response to my article on faxing with DDE in AW 5.12-5.14, Tim contributed some code for adding multiple attachments: ‘Add attachments Set rstAttachments = _ db.OpenRecordset(“Select * from tblBulkEMailMessageAttachments”) If rstAttachments.RecordCount > 0 Then With
How to make only selected fields display in a form or report. Q: Martin writes: I’m working on a function that should not display the field if it is not picked, but my code (below) does not work: Private Sub picEpl() Dim picEpl If Me![picEpl.Visible] = 0 Then picEpl.Visible
Playing audio and video files using the Windows Media Player Control. Access Archon #138 Introduction Since the earliest days of Access, you have been able to sound a beep from Access code, or a macro (the code is simple: DoCmd.Beep). But if you want something more sophisticated, say playing a
How to develop applications using Access and deploy them as standalone applications. Q: Kamlesh Chand wants to develop applications using MS Access and deploy them as standalone applications (i.e., applications that can be run on machines that do not have MS Access installed on them). How can this be done?
Use this technique to switch fields to records. Access Archon #137 Introduction Ray Wright wrote to me to ask how he could convert a table with over 100 questionnaire fields to a more manageable format, with the fields converted to records in a table, to make it easier to tabulate
How to export information from a current record of an Access form to make a new Outlook appointment. Q: Martin Wichmand writes: “In my planner I have a Subject, Startdate, StartTime and Endtime. Normally I import those to Outlook via the slow and manual way. But I wonder if it
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
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)
More on creating mass emails with report attachments. Access Archon #135 When the database is opened, the CreateSnapshots procedure is run to automatically create report snapshots for the four reports in the database, in the DocumentsAccess Merge folder (this folder will be created if it doesn’t already exist, using methods
Readers offer their solutions for calculating total hours. Many readers have contributed better (or at least different) functions or expressions as alternatives to the rather awkward method I described in AW 7.04. Here they are for your consideration, with my comments. (Bill Patterson’s contribution was described in AW 7.10). For
A reader suggests another way to convert a numeric option value to text. In AW 7.12 I suggested using the Switch function to convert numeric values from a choice in an option group to text values. Tom Bushaw writes to suggest another possibility, the Choose function. The Choose function yields a
How to create emails for multiple recipients using data stored in an Access table, and attach general reports. Access Archon #135 Introduction This article combines techniques from some previous Access Archon columns to create emails to multiple recipients using data stored in an Access table, and attaching either a saved
Here’s a more streamlined method for backing up databases without exiting them. In Access Archon #115(WAW 5.16) I described a method (usable in database formats from 2000 up) for making a backup of the current database, without exiting the database. This is very handy when working on a database –
How to stop Access auto-correcting your typing when you don’t want it to. Q: Maryann S. writes: “My application uses a number of two- or three-letter codes as field values. Sometimes, when I type one in, it changes to something else (for example, HGE changes to HE). How can I
A reader’s trying to add info to a query but keeps getting a message “Recordset Not Updateable”. Q: Roger Fisher writes: “I have an Access 2000 database that has a form that is based on a select query. When I try to type in a field on the form I
How to compare actual files in a folder with files names in a table. Access Archon #128 Introduction Thanks to AW reader, Keith Hungate, for suggesting the topic of this article. He wrote to ask if I could suggest a method for comparing file names stored in an Access table
These are some different settings user’s can use to yield the week number in the format they want. Q: Terry Smith writes that the expressionFormat(Now(),”ww”) Which used to yield the correct week number, no longer does so (in early 2005). A: This is not a bug, but a result of
DAO or ADO – what’s the best to use when working with Access? Q: Scott Berry writes: “When should I use ADO and when should I use DAO? I have always used DAO since Access 97, but a lot of guys at work use ADO because it is the ‘new
How to get text values from the user’s selection of an option. Q: Julia H. writes: “I have an option group with choices for different areas of the country, and when the user clicks on one, I want to get the name of the area. But I can only assign