[From nobody Mon Aug 2 21:29:01 2004 Return-Path: <marsee@oreilly.com> X-Original-To: mlamertz@localhost Delivered-To: mlamertz@localhost Received: from localhost (tweety [127.0.0.1]) by tweety.intern.perl-ronin.de (Postfix) with ESMTP id 6814E2E83AC for <mlamertz@localhost>; Thu, 1 Jul 2004 02:57:27 +0200 (CEST) Received: from tweety.intern.perl-ronin.de ([127.0.0.1]) by localhost (tweety.dyndns.org [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 30221-02 for <mlamertz@localhost>; Thu, 1 Jul 2004 02:57:27 +0200 (CEST) Received: from localhost (tweety [127.0.0.1]) by tweety.intern.perl-ronin.de (Postfix) with ESMTP id 265B12E8026 for <mlamertz@localhost>; Thu, 1 Jul 2004 02:57:27 +0200 (CEST) Received: from struppi1.friedrichstrasse62.de [195.138.32.98] by localhost with POP3 (fetchmail-6.2.5) for mlamertz@localhost (single-drop); Thu, 01 Jul 2004 02:57:27 +0200 (CEST) Received: from www.pm.org (mail.pm.org [64.49.222.22]) by struppi1.friedrichstrasse62.de (8.9.3/8.9.3) with ESMTP id CAA20190 for <mike@perl-ronin.de>; Thu, 1 Jul 2004 02:52:41 +0200 Received: from newsletter.oreillynet.com (newsletter.oreillynet.com [209.204.146.25]) by www.pm.org (8.12.11/8.12.11) with SMTP id i610qjAY011752 for <mlamertz@cologne.pm.org>; Wed, 30 Jun 2004 19:52:45 -0500 From: marsee@oreilly.com To: mlamertz@cologne.pm.org Subject: Access Annoyances Needed for New Book Date: Wed, 30 Jun 2004 17:52:33 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit List-Unsubscribe: <mailto:leave-usergroup-4353007F@newsletter.oreilly.com> Message-Id: <LYRIS-4353007-18146-2004.06.30-17.52.34--mlamertz#cologne.pm.org@newsletter.oreilly.com> X-UIDL: @:%"!m;\!!X-8!!i)8"! X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at tweety.dyndns.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on tweety X-Spam-Level: X-Spam-Bayes: 0.0000 X-Spam-Status: No, hits=-4.2 required=2.5 tests=AWL,BAYES_00,NO_REAL_NAME autolearn=no version=2.63 X-Spam-Report: * 0.2 NO_REAL_NAME From: does not include a real name * -4.9 BAYES_00 BODY: Bayesian spam probability is 0 to 1% * [score: 0.0000] * 0.5 AWL AWL: Auto-whitelist adjustment Dear User Group Leader: O'Reilly is pulling together a new book called "Microsoft Access Annoyances" and, once again, we'd like your help! As you might guess, "Access Annoyances" ponders the problems, snarls, quirks, bugs, and just dumb things about Access that drive users nuts. The annoyances will encompass a range of topics: the Access interface, entering data, queries, reporting hassles, VBA, moving data to and from Excel and SQL databases, data tables, expressions, macros, deployment, security--well, you get the idea. If any members of your group use Access--be they newbies or Access masters--and they have annoyances they'd like to see solved, have them email marsee@oreilly.com with "Access Annoyances" in the subject line. Just have them note what version of Access and Windows they're using. As always, thanks for sharing. We'll make sure to get copies of "Access Annoyances" sent to your group shortly after publication. --Marsee *** An example: Long Lines In Small Places THE ANNOYANCE: I'm trying to type a long expression into a tiny text box, which is about as much fun as trying to watch a movie with a couple of basketball players seated in front of you. How the heck do you keep track of what you're typing when you can only see two or three words at a time? THE FIX: One of Access' handier features is the zoom box. Hit <Shift F2>, and Access opens a big, empty text area for editing a long line of text. You can use this trick just about anywhere you see a text box: in the query design grid, in property sheets, in a table design window or datasheet. For that matter, your users can benefit from this trick, too--it works on form fields as well. Highly recommended. [TIP: You'll notice that the zoom box closes when you hit <Enter>. If for some reason, you absolutely need a line break in what you're typing, use <Ctrl-Enter> instead.] *** ]