[AccessD] Fw: Article on Access

Dan Waters dwaters at usinternet.com
Sat Nov 21 12:41:52 CST 2009


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




More information about the AccessD mailing list