Category Archives: VBA
Spatial Data, Part 2
In Part 1 of this series (see ” Accessing Spatial Data, Part 1” in the December 1997 issue), David provided the routines for determining whether two lines intersect. In Part 2, he completes the spatial data toolset with the functions … Continue reading
Spatial Data, Part 1
Access can be used to hold much more than just business data. In this article, David begins a series that looks at the tools you’ll need to work with spatial data stored in Access. Access, as a database system, is … Continue reading
Sounds Good to Me
In this article, Doug Steele talks about how to play MP3 files from your Access application How can I play an MP3 in my application? I’ve read that if you have the latest version of Windows Media Player on your … Continue reading
Soundex: “Close” Only Counts in Horseshoes
This month, Doug Steele looks at a couple of techniques to help determine when text entries are “close enough” to be considered the same. My users have problems with the accuracy of their typing. Is there some way that I … Continue reading
Security Warning
If you receive the message Open File – Security Warning when opening a database, this is what you need to do. In Windows Explorer, right click on the file and choose Unblock (see picture 2). Your database will open correctly … Continue reading
