Book Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word? Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word ![]() ![]() Host your Web site with PureHost! ![]() |
![]() ![]() Saturday, February 27, 2010 – Permalink – Database GenisisGotta start somewhereMicrosoft has a tutorial on how to create a database. Office.Microsoft.com See all Topics access <Doug Klippert@ 3:41 AM
Comments:
Post a Comment
Friday, February 19, 2010 – Permalink – Navigate Navigation PaneAhoyHere's the Microsoft tutorial: Meet the Navigation Pane Also: "We have heard a few of you have missed the ALT D shortcut to open an object in design. As you know, ALT in ribbon apps now allows you to access ribbon shortcuts. Next time you want to open an object in design view, try Control Enter."Navigation pane tip See all Topics access <Doug Klippert@ 3:05 AM
Comments:
Post a Comment
Sunday, January 03, 2010 – Permalink – Keyboard and Key TipsFinger it out2007 apps look different because of the ribbon, but the keyboard can still be used to speed up tasks. Microsoft has an online course that may help After completing this course you will be able to:Office.Microsoft.com/Training See all Topics access <Doug Klippert@ 3:55 AM
Comments:
Post a Comment
Tuesday, December 29, 2009 – Permalink – Close FormsAuto ShutdownHere's how to close a form after it’s used:
TechRepublic See all Topics access <Doug Klippert@ 3:41 AM
Comments:
Post a Comment
Thursday, December 24, 2009 – Permalink – List Fields in Access TablesBit o' codeWhen viewing a table that has many fields in Design view, you have to scroll up and down to review the field names. This can be tiresome when you're referring to them constantly, and particularly when you're working with several tables. The following code produces a field listing for a given table. This can then be copied to Notepad and printed for easy reference. Enter the code into a module, substituting your table's name where appropriate. Open the Debug/Immediate window, type ListFields, Press Enter to produce the listing. Sub ListFields() Dim dbs As DATABASE Dim dbfield As Field Dim tdf As TableDef Set dbs = CurrentDb Set tdf = dbs.TableDefs!NAMEOFYOURTABLE Debug.Print "" Debug.Print "Name of table: "; tdf.Name Debug.Print "" For Each dbfield In tdf.Fields Debug.Print dbfield.Name Next dbfield End Sub See all Topics access <Doug Klippert@ 3:33 AM
Comments:
Post a Comment
Friday, December 11, 2009 – Permalink – Hungarian NotationBelépésThis tip is useful in a number of applications. When you name an object, include a prefix that identifies the type of object. When naming a table for Customers, use "tblCustomers" . You could also have a form for customers. It would be "frmCustomers" . It's called Hungarian notation because with the prefix, it does not look like an English word. Dr. Charles Simonyi developed the convention at Microsoft, and he is from Hungary. He wrote an article on Hungarian notation for MSDN, the Microsoft Developer's Network. Hungarian notation Here are some prefixes:
See all Topics access Labels: Tips <Doug Klippert@ 3:33 AM
Comments:
Post a Comment
Thursday, November 19, 2009 – Permalink – Control Access Text AlignmentDistribute Text Evenly Within ControlsWhen you add form or report controls, the Text Align property defaults to General setting: characters align to the left while numbers and dates align to the right. When you set up controls to act as headings or titles, you can achieve interesting visual results by changing the Text Align setting to Distribute (This is called Justify in Word). This setting distributes characters within the control evenly to span its entire width. If you apply this setting to a textbox control, the alignment switches to Left alignment when you click inside the control to allow for easy data entry.
See all Topics access Labels: Forms, Properties, Tips <Doug Klippert@ 3:31 AM
Comments:
Post a Comment
Sunday, November 15, 2009 – Permalink – Color NewsA multidiscipline subjectHere is a study about how color effects a reader's choice of concentration. It was intended for newspaper publishers, but the same knowledge can be used in Web design, PowerPoint, or any other reporting application. Word and Excel will also benefit. Color, Contrast, and Dimension in News Design ColorProject The Poynter Institute is a school for journalists, future journalists, and teachers of journalists. Poynter.org See all Topics access Labels: Tips <Doug Klippert@ 3:06 AM
Comments:
Post a Comment
Friday, November 13, 2009 – Permalink – Link to Office Documents from AccessClick to Word, PowerPoint, ExcelYou can create hyperlinks in Access that jump to other Office documents. The process of specifying the document and the bookmark you want to jump to can be cumbersome. There's an easy way to specify where in a Word, Excel or PowerPoint document that a hyperlink should jump to, without even having to open the Insert Hyperlink dialog box.
See all Topics access <Doug Klippert@ 3:44 AM
Comments:
Post a Comment
Saturday, October 31, 2009 – Permalink – Hiding Duplicates in Query ResultsOnce is enoughIt's easy to hide duplicate entries when you run a query, even though Access doesn't go out of its way to call attention to this ability.
Access displays unique records based on each field returned by the query. See all Topics access <Doug Klippert@ 3:12 AM
Comments:
Post a Comment
Sunday, October 25, 2009 – Permalink – Export Formatted SheetsAccess to ExcelAccess provides an easy way to export data to Excel through the Office Links feature. To use this feature, simply select a relevant database object and choose Tools>Office Links> Analyze It With Excel. The worksheet Excel creates includes some minor formatting applied to the field headings that appear in row 1. Some formatting in your original Access database affects the worksheet cell formatting as well. For example, if you're exporting from a datasheet, gridline and font attributes are carried over to Excel. If you use the Office Links feature to export data behind a form, text box shading and font properties are applied. The final result in Excel may not exactly match your Access data; however, you'll probably find that less work is required to get your Excel version of the data into an easily readable state. In Office 2007-10 it's External Data>Excel ![]() See all Topics access Labels: Tips <Doug Klippert@ 3:08 AM
Comments:
Post a Comment
Tuesday, October 20, 2009 – Permalink – Display Data OnceReport TrickSometimes, you may have data that needlessly clutters a report. For instance, suppose your report is listing the fields strCompany, strFirstName, and strLastName. If there are multiple names listed for each company, and the report is sorted by company name, repeating the company information is unnecessary. You may want to set a group header based on the company name, but there's an easier way to hide the redundant data.
![]() If the data in the modified control is the same as the data from the previous record, the control is hidden. See all Topics access <Doug Klippert@ 3:35 AM
Comments:
Post a Comment
Wednesday, October 14, 2009 – Permalink – Access to E-mailWhat's the Outlook?Garry Robinson from GR-FX Pty Limited of Australia and Scott McManus from Skandus, have a tutorial about: Processing E-Mail Orders using Outlook and Access. They have include sample database downloads and the code needed to make the engine work. "Using Microsoft Access and Outlook together can reduce manual processing of Ordering emails very substantially. I know this because sometimes it would take up to 15 minutes to undertake all the little steps of saving customer details into tables and newsletter lists. Also without software, it was very difficult to explain to other staff members what to do when an e-mail arrived. Now we can process the orders in a couple of minutes when Outlook email arrives in the correct folder." See all Topics access <Doug Klippert@ 3:04 AM
Comments:
Post a Comment
Saturday, September 26, 2009 – Permalink – Reduce Trips to the ToolboxSave shoe leatherWhen you add controls to forms and reports you'll often need to add several of the same type, such as when creating a group of option buttons or a series of unbound text boxes. In such cases, repeatedly moving between the Toolbox and the object you're designing can quickly become tedious. Fortunately, you can make the process easier. When you select the control you want to add from the Toolbox, double-click the control button (like double-clicking the Format Painter). Doing so lets you add as many controls of that type as you need. When you finish, click the button again to disable the control tool. See all Topics access <Doug Klippert@ 3:09 AM
Comments:
Post a Comment
Saturday, September 19, 2009 – Permalink – Disable ConfirmationOnly for the braveAccess tries to prevent user errors that would have calamitous effects on data or an application by throwing up confirmation boxes before potentially dangerous actions. This provides users with an out before committing irreversible changes to the database. Although you probably want these confirmation dialog boxes in place for end-users, you may find that they slow your work down too much. You may, also, click through the dialog boxes so quickly that they're essentially ineffective. If you have a programmer's version of hubris, you can prevent Access from displaying confirmation dialog boxes. To do so, choose Tools>Options from the menu bar and click on the Edit/Find tab. Then, clear the appropriate check boxes in the Confirm panel that correspond to the dialog boxes you want to suppress. Finally, click OK. In 2007, click the Office logo and then Access Options ![]() Good luck, you've been warned. See all Topics access <Doug Klippert@ 3:00 AM
Comments:
Post a Comment
Friday, August 28, 2009 – Permalink – Parameter v. FormYou have a choiceThere are a couple of ways to limit the data that is displayed in a Query or in a report. One is a Parameter Query
Also see FontStuff.com: Using Parameter Queries See all Topics access <Doug Klippert@ 3:02 AM
Comments:
Post a Comment
Sunday, August 16, 2009 – Permalink – Change Keyboard NavigationIt's your choiceYou, probably. take for granted how your direction arrow and Enter keys behave in Access. When you press Enter the focus moves to the next field and the contents of the field are selected. Likewise, when you press the direction arrow keys, the focus moves to the next field in the appropriate direction. You aren't locked into these behaviors. If you'd like, you can set up the arrow keys to move from one character to the next in the current field, rather than moving focus to the next field. You can also configure the Enter key to move to the next record when it's pressed or configure it to do nothing at all. When you do move focus to another field, you have the option to place the insertion point at the beginning or end of the field, rather than selecting the field's entire contents. To modify these settings, choose Tools>Options from the menu bar and click on the Keyboard tab. Then, simply make the selections you want and click OK. ![]() In 2007 it's under Access Options>Advanced when you click the Logo in the upper left corner. ![]() See all Topics access <Doug Klippert@ 6:55 AM
Comments:
Post a Comment
Saturday, August 08, 2009 – Permalink – Reduce Entry MistakesDisable AutoExpandWhen you type an entry in a combobox control Access will typically attempt to complete the entry based on the control's lookup list. This is controlled by the AutoExpand property, which is set to Yes (-1) by default. Although such behavior is helpful, it can cause problems if your value list contains several items that are close in spelling, since it's easy for users to accidentally let Access choose the wrong item. You can avoid errors by setting the control's AutoExpand property to No (0) in Design view or using VBA to set the property equal to 0. Once you've made the change users are forced to type the entire entry or select an item using the combobox control's dropdown list. (Works the same in Access 2007) ![]() See all Topics access <Doug Klippert@ 3:06 AM
Comments:
Post a Comment
Saturday, August 01, 2009 – Permalink – Data SecurityAccess styleWith all the news about database spying, here's some information about protecting your own Access db. Don't tell the New York Times. This is Margaret Blauvelt's TOC from Mendoclick.com: Mendoclick.com Access Security for End Users Support.microsoft.com: Frequently asked questions about Access security warnings For Access 2007: Data Security in Microsoft Access 2007 See all Topics access Labels: Tips, Troubleshoot <Doug Klippert@ 3:11 AM
Comments:
Post a Comment
Sunday, July 26, 2009 – Permalink – Fiscal Year in AccessMake up your own yearYou can show a custom Fiscal Year starting June, 1 and ending May 31. BeginFiscalYr = DateSerial(Year(Date), 6, 1) EndFiscalYr = DateSerial(Year(Date) + 1, 6, 1) - 1 Also: Calculating a future or past date in Access See all Topics access <Doug Klippert@ 3:29 AM
Comments:
Post a Comment
Saturday, July 18, 2009 – Permalink – Auto FormJust add DataHighlight a Table in the Objects Table view. Go to the main menu bar and click on Insert. Towards the bottom of the menu, you'll find an entry for "AutoForm" Click on it and Access will create a data entry form based on the selected table. When you close the AutoForm, you will be asked if you want to save changes. Click Yes. (In 2007 go to Create>Form) The default name will be the name of the table. If you are using Hungarian notation, change the name from "tblCustomers" to "frmCustomers" and click OK. Also see: Hungarian Notation See all Topics access <Doug Klippert@ 3:48 AM
Comments:
Post a Comment
Wednesday, July 15, 2009 – Permalink – Restore DefaultsOffice 2003 redoTo reset the original settings in Office 2003, follow these steps. Make sure that you back up your files before you follow these steps.
Microsoft Office Diagnostics in 2007 replaces Diagnose and Repair: Howtogeek.com See all Topics access Labels: Tips, Troubleshoot <Doug Klippert@ 3:30 AM
Comments:
Post a Comment
Sunday, July 12, 2009 – Permalink – Plain NumbersI'd Like to Make It ClearPlain Figures is a method of transforming statistical and financial data into figures, tables and graphs that people readily understand. Have you ever:
<Doug Klippert@ 3:01 AM
Comments:
Post a Comment
Saturday, July 11, 2009 – Permalink – A Hoard of TipsGood for all levels of userAllen Browne's tips for Access users Here is a list of the sections on this site; something for everyone.
<Doug Klippert@ 3:19 AM
Comments:
Post a Comment
Thursday, June 25, 2009 – Permalink – Compact Before SynchronizingA DB two stepIf you're working with a replicated database, always compact it twice before you synchronize. The first time you compact, Access marks objects that need to be deleted, but it doesn't actually remove them. The flagged objects are removed the second time you compact the database. Although there's no harm in additional compacting, there's no added benefit. This is particularly important to do when working with the Design Master. Each time you make design changes to the Design Master, a copy of the original object is kept in the database. If you edit and save a Report or Form 10 times, your database actually has 9 older versions of the form in it. The same is true if you change the schema of a Table or Query If you synchronize before compacting, all of the versions are sequentially sent to the other replicas until everything is in synch, and you can't reclaim the space taken up by the older versions. However, if you compact the database first, only the most recent form version is sent to the replica. See all Topics access Labels: Tips <Doug Klippert@ 3:29 AM
Comments:
Post a Comment
Tuesday, June 23, 2009 – Permalink – Mail Your MDB-ACDBDon't let Outlook stop youThere was a lot of frustration with Outlook 200x. If an Access MDB file is received, Outlook expects the worst and blocks the attachment. The trick has been to ZIP the file or change the extension to something like .DAT. Here's a registry trick that restores Outlook to the good old days. Outlook 2007, 2003, 2002 and Outlook 2000 SP3 allow the user to use a registry key to open up access to blocked attachments. (Always make a backup before editing the registry.) To use this key: If you are using this registry entry, a glance at Help>About Microsoft Outlook will show Security Mode: User Controlled above the license information.Slipstick.com: Opening .exe Attachments Also see: Shortcuts for Sending Access Objects via Email See all Topics access <Doug Klippert@ 3:33 AM
Comments:
Post a Comment
Wednesday, June 10, 2009 – Permalink – Automaticaly Setup a DatabaseLink in a snapWhen you're creating a new database that will link to data that isn't in an Access format, you can speed up the setup process. Rather than creating a new database and then using the File>Get External Data>Link Tables,
See all Topics access <Doug Klippert@ 3:55 AM
Comments:
Post a Comment
Thursday, June 04, 2009 – Permalink – Database ExamplesClever timesaversRoger Carlson, RogerCarlson.com, has collected a group of Access databases that demonstrate different functions. The Library includes tutorials and a good list of files that can be downloaded. See the Table of Contents
And many more See all Topics access <Doug Klippert@ 3:34 AM
Comments:
Post a Comment
Saturday, May 23, 2009 – Permalink – Compact-Repair ShortcutDesktop convenienceYou can make compacting and repairing databases easier by providing a desktop shortcut. Right-click on the Windows desktop and select New>Shortcut from the shortcut menu. Then, set up a Command Line entry in the form: "Path to Access.exe" "Path to Database.mdb" /compact For example, to create a shortcut to compact Northwind, you might use: "C:\Program Files\Microsoft Office\Office\Msaccess.exe" "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb" /compact Click Next and continue through the shortcut setup wizard, naming the shortcut appropriately. In Access 2000+, the database is both compacted and repaired when the /compact switch is applied. Access 97 executes these processes separately, so Access 97 shortcuts should use a Command Line in the form: "Path to Access" "Path to Database" /compact /repair Also note that you can compact to a different location by specifying a target database name after the /compact switch. If you omit a target file name following the /compact option, the file is compacted to the original name and folder. To compact to a different name, specify a target file. If you don't include a path in target database or target Access project, the target file is created in your My Documents folder by default. (Even though a shortcut will open the database without it, in order for the command line flag to work, you MUST include the path to the executable - Access.exe) See all Topics access <Doug Klippert@ 3:31 AM
Comments:
Post a Comment
Sunday, May 17, 2009 – Permalink – New Fields from Datasheet ViewTable fields on the flyWe all, of course, pre-plan our table layouts. However, if you need to create a table field while working in Datasheet view, you don't have to switch to Design view. There's a quick way to create a field from Datasheet view. Right-click on the column heading of the column you want to the right of your new field. Choose Insert Column from the shortcut menu. Access creates a field with a name such as "Field1". You can then immediately start entering data in. You can also use the shortcut menu to rename or delete the newly created field. Later you can go to Design view to set the field's properties. See all Topics access <Doug Klippert@ 3:19 AM
Comments:
Post a Comment
Sunday, April 26, 2009 – Permalink – Composite KeysMulti-Field KeysTo quickly create a multi-field primary key, while in the table's Design View:
University of Texas at Austin: Primary and Foreign Keys See all Topics access <Doug Klippert@ 3:05 AM
Comments:
Post a Comment
Saturday, April 18, 2009 – Permalink – Duplicate Table StructuresNo need to reinventWhen setting up a database, you may find that there is a table structure in another database that would be appropriate. You could Import the table, but then you have to clear out the useless records. Here's an easier way to do it:
To export a table definition from your current database to another:
See all Topics access <Doug Klippert@ 3:42 AM
Comments:
Post a Comment
Friday, April 10, 2009 – Permalink – Business
|