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 for area.

In last month’s article, I showed you how to use Access with geographical data. I then went on to describe a Line Intersection function as one of the primary tools for working with spatial data. In this month’s article, I’ll spend a little time looking at some more data represent-ations before going on to two further functions: one to calculate areas, and one to determine whether or not a point lies within a defined area.

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 widely used for storing all kinds of data. Traditionally, these include systems like stock control, accounts receivable, and personnel management. An increasing trend is to store geographical data that might be extracted from a plan or map. Over the next three issues of Smart Access, I’ll show you how Access can be used to store and process such data. These principles apply equally well to other applications as well, such as graphics programs, routing systems, or any other spatially based problems. 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 system you can play MP3 files simply by adding the Windows Media Player component onto your form and adding this one line of code: 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 can check whether something close to the name they typed already exists in the database?

My first impulse was to tell you not to let your users type the name but rather have them use a ComboBox to let them select the correct name. However, if your users would have to select from a large list, picking from a list may not be the best interface to use. 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 next time. Continue reading

Posted in VBA | Leave a comment