How to email attachments using the Redemption Library – and avoid the Object Model Guardian. Mark Riddick wrote in response to Access Archon #114, Avoiding the Object Model Guardian with the Redemption Library, asking how he could email report snapshots using the Redemption Library (he used to do this with
How to display data from other fields in the same record that’s selected in a combo box. Q: Robert Colum wants to know how to display data from other fields in the same record that is selected in a combo box. A: This can be done easily using the Column
Using the FindFirst method in a DAO recordset. Q: Peter Lucero is having problems using the FindFirst method in a DAO recordset based on a table, using the following syntax: Set Rst = dbs.OpenRecordset(tablename) A: This is because when you create a DAO recordset based on a table, without
How to get group headings to repeat for groups that extend over several pages. Q: Saul writes that he is having problems with getting headers to repeat on each page in a report. A: To get group headings to repeat for groups that extend over several pages, set the Repeat
How to reference specific fields in an Access query. Q: Lee Aldrich wants to know how to reference specific fields in an Access query/dataset. A: In VBA code, you can set up a DAO recordset to work with Access data, using the following syntax (the example sets two variables
A reader wants to know how to get a report to display just the items related to a specific order. Q: George Adams is having a problem with getting a report to display just the items related to a specific order. How can this be done? A: You need
How to auto-populate City and State fields on a form when the user selects a Zip Code. Q: Joe O’Meara wants to auto-populate City and State fields on a form when the user selects a Zip Code. How can this be done? A: Here is a procedure that updates
The meaning of the word “Me” in VBA code. Q: Stuart E. Wugalter asks what is the meaning of the word “Me” in VBA code? A: Me is an Access keyword that refers to the form (or report) from which the code is running. There is also a Parent keyword
How to shrink up the blank spaces on reports. Q: Randy writes: “I was wondering if there was any way I could shrink up the blank spaces on a report. The CanShrink Property just kinda shifts the blank spaces from the bottom of the detail section to the top in
Here’s how to make a reminder automatically pop up with a MessageBox when a date has expired. Q: Martin writes: “I keep trying to make a reminder that automatically pops up with a msgbox when a date has expired, but no luck… If cboPartshøringSlut >= Date Then MsgBox “Partshøringen
How to get accented characters in Access fields. Q: Ray Bona wants to know: “How can I get an accented character (e.g. e-acute, n with a tilde, or o with an umlaut, etc.) in text that I enter in an Access field?” A: One way is to create the accented
How to get a return value of the number of full years elapsed between two dates. Q: William Butler writes: “I have been working on this problem all day, writing an expression in a query to show the difference between today’s date and one that just passed. It seems it
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