Replies

John,

In the properties of the form set the Control Box to NO as well. This will eliminate the ghosted Close button in the Title Bar.

Charlotte,

The total commission is calculated via square footage * commission rate. This total is then broke down to different profit centers in the organization. In other words, everyone getting their piece of the pie. I would love to use the subform and add up to a total, but they want to use the calculated total then break that down.

John,

There was a good article in the November 2000 “Advisor: Access, VB and SQL” magazine that talked about better interface design with VB. You can apply these principles to Access.

One thing I always do is find the lowest resolution of my clients systems and develop in that resolution. This way if even one user is using 640×480 they don’t have to scroll around to see the form. I also remove any thing the user doesn’t need. Like the Control Box, Min, Max and Close buttons on the title bar. I also don’t allow my users to size the forms. The less things they have to play with the fewer calls I will recieve. One other thing, when I place buttons on my forms I use the text caption. This way if they can read they can use the system.

Hope this helps.

Tom Farrington