SP Client Search - MS Access, My second hobby ...

I have been programming in Microsoft Access since version 1, and really enjoy programming (not the coding so much, but the puzzle of user interface and flow). It has been a second hobby - photography still #1, but I get to do that during the day. ;)

We use StudioPlus, a professional photography management software. It is built on the Access database format, StudioPlus allows access to the information stored in it's database (read only) through Microsoft Access. This is another testament to the company as most lock out access to the photographer's data.

I recently finished writing a program in Access that solves a problem that we run into every once in a while. We will get, not quite enough info about who a client is, like when we get a phone message and we cannot make it out clearly ... John somebody with the phone number ending in 435 called with a question about his order ... it can be a pain to figure out who this really is (StudioPlus allows searching, but each name and phone number field separately). As I had some of the elements designed anyway I put a program together ... and in a way that others could use it easily (since this forces me to really polish it up for our use) ... ;) ... I have called this program SP Client Search.

For a window into this hobby of mine here is the main screen in the program(really the only screen, except for a help/about window).




All of the clients are normally listed on the left, with the client's detail on the right along with any family member detail. Just select a client and use the arrow keys to move between clients. I entered our name and street number in the two search fields so that we would be the only one showing in order to keep our client info private - and to demo what the search filter does.

The program searches on up to three different criteria, and searches the following fields ...
- Client's first, last, and company names, address, 6 client phone fields and the client email address.
- Family member's name, phone number and email address.
All in one push of a button ~ Love It! :)

So there you go, just wanted to share a little behind the scenes of what I am up to ...

A link to the program is posted in the StudioPlus user forum, since it won't do anyone any good if they don't have StudioPlus. If there are any questions about how it works or on the StudioPlus software feel free to wave at me. :)

Please note: This program is written by me and is not supported in any way by StudioPlus

Thanks,
Roger

Added info ...

The post in the StudioPlus forum is titled "Client Search add on to StudioPlus" in the "Ideas to Improve Your Business" section and my user name is darkroomdevil. The StudioPlus forum is where any updates to the program will be posted, and hopefully conversations about the program :) ... since this program only works for StudioPlus users.

The link to the current version of the Access file is
http://www.eleakis.com/SPClientSearch/SPClientSearch_1.13.zip