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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment