|
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, March 13, 2010 – Permalink – This blog has movedThis blog is now located at http://unofficialaccessstuff.blogspot.com/. You will be automatically redirected in 30 seconds, or you may click here. For feed subscribers, please update your feed subscriptions to http://unofficialaccessstuff.blogspot.com/feeds/posts/default. <Doug Klippert@ 6:51 PM
Comments:
Post a Comment
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
Thursday, February 18, 2010 – Permalink – Custom QATAccess additionsApplications put most of the most-used commands on the Home tab's Ribbon, not everything is there. You may want to add Close, Close All, or Print commands, for example. In the upper Left corner is the Quick Access Tool bar. To update the QAT: Click the down-pointing arrow to the right of the QAT. Choose any common commands (New, Close, Print, etc.) by checking the option. See all Topics access Labels: Customize <Doug Klippert@ 3:32 AM
Comments:
Post a Comment
Wednesday, February 10, 2010 – Permalink – Access CommunitiesIt takes a villageHere are some links the Access groups. Someone has probably asked your question before. Access Communities See all Topics access <Doug Klippert@ 3:52 AM
Comments:
Post a Comment
Thursday, February 04, 2010 – Permalink – Command Reference2003-2007-2010Those of you that are just now making the switch to the Ribbon world, will find this valuable.ComputerWorld.com See all Topics access <Doug Klippert@ 3:11 AM
Comments:
Post a Comment
Tuesday, February 02, 2010 – Permalink – Office TrainingSuggestionsTechRepublic lists a number of areas that you might explore when training is needed for a new Office version.Here are a few:
See all Topics access Labels: Tutorials <Doug Klippert@ 3:57 AM
Comments:
Post a Comment
Tuesday, January 26, 2010 – Permalink – Where's the Temp[lateFind and/change storage spotsDescribes the different template categories and the locations of templates in 2007 Office programs. Also describes the registry settings that control where to find your custom templates. Support.Microsoft.com See all Topics access <Doug Klippert@ 3:49 AM
Comments:
Post a Comment
Monday, January 18, 2010 – Permalink – Access Transition TutorialsAvailable in PDFThis collection relates to the transition to 2007, but most are also appropriate for 2010. "The main intent of these tutorials is to guide frequent users of Microsoft Access through the transition of earlier versions to the new 2007 edition. Throughout the different tutorials . . . topics from program specifications through features added, dropped, or unchanged as well as demonstrating implementations of subjects discussed."
<Doug Klippert@ 3:40 AM
Comments:
Post a Comment
Monday, January 11, 2010 – Permalink – Merge Access with WordDatabase integration"You can merge Microsoft Office Access 2007 data with a Word 2007 document by using the Mail Merge Wizard. This demo shows you how to create a simple form letter and how to troubleshoot problems. You can also use this feature to create address labels or any other type of Word document in which you want to display Access data."Office.Microsoft.com See all Topics access <Doug Klippert@ 3:43 AM
Comments:
Post a Comment
Thursday, January 07, 2010 – Permalink – Automate ShutdownClose everythingIt's generally considered good form to close all forms and reports when you're shutting down a database.Here's a link to some code that takes care of it for you. TechRepublic.com See all Topics access <Doug Klippert@ 3:01 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
Thursday, December 17, 2009 – Permalink – Combo Box QueriesHow toParameter queries add flexibility to filtering records in a database. To make it easy, take a look at this approach from Martin Green's Office Tips site: Drop down box in a Parameter Query
Base Combo Box on Parameter Query to Filter Values See all Topics access <Doug Klippert@ 3:25 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
Thursday, November 05, 2009 – Permalink – Change Code to CommentsFast solutionWhen you're testing procedures, you can temporarily convert a block of VBA code to comments that will be ignored during a trial run. Doing so manually by inserting an apostrophe before each line of code can be a real chore. To simplify this task,
See all Topics access Labels: VBA <Doug Klippert@ 3:42 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
Thursday, October 08, 2009 – Permalink – Copy PasteExcel tablesOne way to create a new table in an Access database from information included in an Excel spreadsheet is to select the pertinent data on the spreadsheet, including the field names. Copy the selection (Edit>Copy, or CTRL+C) Switch back to Access . With Tables objects being shown in the database window, choose Edit>Paste, or use the CTRL+V shortcut. Access will ask if the first row contains the field names and then will paste the information as a new database table. See all Topics access Labels: Tables <Doug Klippert@ 3:47 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
Saturday, September 12, 2009 – Permalink – Declaring Multiple VariablesDeclare each oneWhen setting up a macro in VBA, if you want to declare multiple variables in one line of code, be sure to specify the type for each variable, even if the variables are the same type. Avoid code like the following: Dim strFName, strLName, strMI As String In such a case, only the last variable, strMI, is actually declared as a String type. The first two variables are designated by default as Variant data types. To correctly declare the three variables, you would use the statement: Dim strFName As String, strLName As String, strMI As StringSee all Topics access Labels: VBA <Doug Klippert@ 3:54 AM
Comments:
Post a Comment
Friday, September 11, 2009 – Permalink – AutoShapesDrawing bar objectsKim Hedrich has put together a series of basic articles on AutoShapes for TechTrax. AutoShapesPart 1 - How to draw circles, ovals, squares and rectangles; also modifying fill and line colour AutoShapes Part 2 - Fill Effects AutoShapes Part 3 - Shadows and 3-D AutoShapes - Text Inside a Shape See all Topics access <Doug Klippert@ 7:45 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
Saturday, August 22, 2009 – Permalink – Self HelpGet started in the right directionThe Office of Technology Services of Towson University, located in Towson, Md., provides Self-Help Training Documents for many applications. They are available for many levels of knowledge. They’re clean, clear, and concise.
See all Topics access Labels: Tutorials <Doug Klippert@ 7:28 AM
Comments:
Post a Comment
|
