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 […]
Several readers responded with their suggestions for determining if a database exists. Thomas Mount responded to my tip on finding out whether a file exists in WAW 6.07, with a more efficient method using the FileSystemObject: Function isFile(FileName as String) as Boolean isFile = _ CreateObject(“Scripting.FileSystemObject”).FileExists(FileName) End Function This method is indeed more […]