DMS Facets

Relating several topics, including IT, Microsoft Access, sports administration, and micro-ISV business.

Real World Access (37)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Jack Cowley’s Rodeos The general consensus seems to be that if you are cowboy or cowgirl and want to enter a rodeo, you fill out a form, pay your entry fee, and wait until the appointed day. After […]

0

Real World Access (36)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Sascha Trowitzsch’s Remote Equipment Service A manufacturer produces machines for industrial application, that fully automate the milling of guitar necks. The sound of the instruments will be optimized this way. They needed a database to administer all sold […]

0

New Blog – GPG On Access

Hey!  I have noticed that Access MVP George Hepworth (aka Grover Park George) has recently joined the ranks of Access bloggers.  He calls it GPG On Access. I’ll be keeping my eye on his blog. I expect he will be targeting some interesting topics, and he has a great knack for explaining things neatly. Technorati […]

0

Office 2007 Ribbon Saga

There is some fantastic information available, about the evolution of the Ribbon (Fluent User Interface) for Office 2007. I first heard about it on Clint’s post to the Access Team Blog. He points to an article by Jensen Harris, Group Program Manager of the Microsoft Office User Experience Team. And in particular a video of […]

0

Real World Access (35)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Graham Seach’s Investment Banking Many of the Access projects I develop are for very large organisations. One in particular was for a multi-national investment bank. This $3.9M project was to develop a highly secure enterprise system that allowed […]

3

Kids and the Internet

As a parent, as well an IT professional, I am very interested in the topic of safe computing practices for children. A few days ago, a guy I know pointed out this article. It caught my attention, especially since I have been managing a blog for some of the kids at my daughter’s school, during […]

0

Mouse Parade

This week has seen the opening of another chapter in my long-term process of caring for the tendons in my hand and arm. I am referring to my acquisition of a new Microsoft Natural Wireless Laser Mouse 6000 (#4 in the picture). When I first experienced problems because of mouse damage (RSI, OOS, whatever you […]

3

Bill Gates talks about Office

Thanks to Access MVP Thomas Möller for pointing out this very interesting recent interview with Bill Gates. We know that Bill has always been very fond of Access, and it is good to see this is still the case. In this interview, Bill gives some interesting hints about what might be coming in Access 14. […]

0

Up in the air

Can anyone figure out how they allocate passenger seating on aircraft? As far as I can tell, it must be a fairly complex data management task, so my hat’s off to the person who wrote the algorithm for Air New Zealand. Tell you why I think so.  All sarcasm aside, honestly. Today I travelled on […]

4

Real World Access (34)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Glenn Lloyd’s Distribution Bulk Product Information Management and Reporting My client, the regional manager for a major multi-national corporation, is responsible for the storage and distribution of a small variety of bulk products throughout a vast geographical area. […]

0

Real World Access (33)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Dave Hargis’s WIA Database   This Access application was written to support the United States Workforce Investment Act.  This law provide for training and assistance for people having difficulty obtaining employment. The law requires specific reporting on these […]

0

Real World Access (32)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Paul Baldarelli’s Taxis I have running, in 2 different cities, a comprehensive taxi reservation/dispatch system.  Each handles in the range of 500-1,000 calls per day. It is a Microsoft Access application, with the data in SQL Server. On […]

0

A Great Story

My Father the Writer This is a bit of a departure from the type of material I usually post.  But this is very cool. Apparently my Dad’s sister (my Auntie Mem) has been “encouraging” him for a while to write about this particular subject. And now he’s done it! Well, I don’t suppose Dad will […]

0

Real World Access (31)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Brent Spaulding’s Processes Maintenance/Production/Quality Management System   I work for an automobile company in the body weld department of an assembly plant.  Our department’s end product is the shell (body) of a vehicle all welded up. To perform this […]

0

Real World Access (30)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Leigh Purvis’s Duty Each year in the UK there are two million 8 page forms (with a possible 232 questions and potentially an additional 99 x 70 questions per form) submitted to the government for Stamp Duty Land Tax […]

1

Custom Toolbars 2007

 At the June meeting of the Wellington Office User Group, Peter asked a question about using Custom Toolbars in Office 2007 applications, and how this relates to the Fluent Interface (Ribbon). I have put together a few pieces of information, as this applies in particular to Access 2007. Toolbars as toolbars Whereas VBA will continue to […]

1

Protecting the Style in MS Word

At the June meeting of the Wellington Office User Group, Aniela asked a question about how to ensure that a Protected Document in Word 2007 can’t have the Style changed. It appears at first glance that anyone can select a different Style option from the drop-down list, even if the document has been protected and […]

0

Real World Access (29)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Scott Diamond’s Art Collection My company had a lot of artwork within their offices. Some of it very valuable, including an original Andy Warhol. However, we really didn’t have a good inventory of what we had on the walls […]

0

Real World Access (28)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  John Mishefske’s Homeland Security This application, which I developed in 2004, searches a list of designated parties with whom US persons are prohibited from conducting business transactions. It periodically automatically retrieves the U.S. Treasury list of Specially Designated […]

0

Pro Access 2007 : Book Review

I have been very much enjoying reading Martin WP Reid’s new book, Pro Access 2007. In fact, for me, it is just what I need at this time. As an Access developer who has acquired a reasonable level of skill and knowledge of earlier versions of Access, I have nevertheless been feeling a little intimidated […]

1