Rocky Smolin
rockysmolin at bchacc.com
Sat Nov 21 14:07:08 CST 2009
True, except I try to keep my hands on the keyboard as much as possible. Moving keyboard to mouse is my personal pet peeve. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Saturday, November 21, 2009 10:42 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Fw: Article on Access Hi Rocky, You might try creating a custom toolbar with all of those functions. I have one with just the align functions - big time saver! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Saturday, November 21, 2009 10:31 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Fw: Article on Access How's this? Access is known as a Rapid application Development platform, and for the development of custom databases and applications I have found it head and shoulders above any other product in that respect. Since I develop applications for business, speed of development the most important consideration for me in choice of platform. (And my customers, too, by the way!) Now like all programmers, I like doing the high level stuff - fashioning slick queries, writing elegant functions, and the like. Getting all the text boxes, labels and controls on a report or form lined up and positioned where you want them is tedious, time consuming, and unrewarding - nudging text or combo boxes, command buttons or labels around by the hundredth of an inch until they're all lined up right. So while it might seem a bit trivial, one of my favorite features is the ability to 'rubber band' a group of controls and line them up and/or space them equally so that my forms and reports look crisp and professional. And being a mouseophobe, I always use the keyboard shortcuts to: Align Top (Alt OAT) Align Bottom (Alt OAB) Align Left (Alt OAL) Align Right (Alt OAR) Equal Space Horizontally (Alt OZE) Equal Space vertically (Alt OVE) Increase/Decrease space Horizontally (Alt OZI/Alt OZD) Increase/Decrease space Vertically (Alt OVI/Alt OVD) And once aligned, if the group of controls needs some nudging, again I use the keyboard shortcut - Ctrl with the up, done, left and right arrows - to move them about in small increments. These are not sexy or particularly sophisticated features of the IDE. But they are workhorse functions that have saved me enormous time, aggravation, and eyestrain. Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Wednesday, November 18, 2009 12:32 PM To: AccessD at databaseadvisors.com Subject: [AccessD] Fw: Article on Access Someone has suggested that I clarify this request. I am looking for specific favorite/least favorite items for Access, Excel, and Word. The original post said "Office" -- so I want to be clear. Not getting much response, which surprises me! ;) Susan H. > I'm going to write a series of articles of favorite/least favorite > tips/features in the Office applications. The selling point is that > these comments are your's and not mine for a change. :) If you want to > be included, I'll include your contact information in the article -- > similar to the security and add-in articles I wrote last year. > > <http://blogs.techrepublic.com.com/10things/?p=497> > > I'll be writing one on Access. If you're interested, I'll need your > favorite all-time Access tip/feature and your least favorite feature. > Please mail them to me privately -- ss harkins at gmail dot com -- so > we don't upset the kind moderators! > > I'm been asked not to include keyboard shortcuts. I need a > user/code/feature type solution -- it can be very easy. If you want to > include a keyboard shortcut, we can do so, as an after thought... "In > addition, so and so uses the blah, blah shortcut regular..." Your > least favorite can be something you find awkward, a bug, or a feature > you think that should be available, but isn't -- or something else -- > those are just ideas. What makes you pound your desk and spit out, "D*mn!" > > I'll be writing one for Word and Excel too, and possibly Outlook and > PP if I can find enough people interested, so keep those in mind too > if you're interested. > > Thanks! > Susan > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com