How to total a calculated field on a report. Q: Marie H. needs a total in a report group footer, based on a calculated field in the report detail section. =Sum([txtWeekTotal]) doesn’t work – how can this field be totaled? A: You can’t total a textbox, but you can total the text box’s control source, […]
How to synchronize Access and Outlook contact data. Access Archon #145 Introduction If you store contact data both in an Access table and an Outlook Contacts folder, it would be handy to be able to quickly switch from the Access contact record to the Outlook contact item, or vice versa. In this article I show […]
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 ways of using the Windows […]
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 to actual files stored in […]
How to generate sequential dates automatically. Q: Richard Bryant writes: “I have made a diary in Access. I enter a month at a time from notes on my calendar. I have to enter each date of the month each time I make an entry. In Excel the dates can be put in sequentially automatically. Is […]