Host your Web site with PureHost! |
![]() ![]() Saturday, February 27, 2010 – Permalink – Database GenesisGotta start somewhereMicrosoft has a tutorial on how to create a database. Office.Microsoft.com See all Topics Labels: Access <Doug Klippert@ 3:40 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 Labels: Access <Doug Klippert@ 3:08 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 Labels: Access, Excel, Outlook, PowerPoint, Word <Doug Klippert@ 3:28 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 Labels: Access <Doug Klippert@ 3:49 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 Labels: Access, Excel, Outlook, PowerPoint, Word <Doug Klippert@ 3:51 AM
Comments:
Post a Comment
Tuesday, January 26, 2010 – Permalink – Where's the TemplateFind 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 Labels: Access, Excel, PowerPoint, Word <Doug Klippert@ 3:44 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."
Labels: Access <Doug Klippert@ 3:38 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 <Doug Klippert@ 3:40 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 Labels: Access <Doug Klippert@ 3:59 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 Labels: Access, Excel, Outlook, PowerPoint, Word <Doug Klippert@ 3:52 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 Labels: Access <Doug Klippert@ 3:36 AM
Comments:
Post a Comment
Thursday, December 24, 2009 – Permalink – List Fields in Access TableBit 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 [Edited entry from 12/24/2006] See all Topics Labels: Access <Doug Klippert@ 3:31 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 [Edited entry from 12/17/2006] See all Topics Labels: Access <Doug Klippert@ 3:23 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:
[Edited entry from 12/9/2006] See all Topics Labels: Access <Doug Klippert@ 3:32 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.
[Edited entry from 11/14/2006] See all Topics Labels: Access <Doug Klippert@ 3:29 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 [Edited entry from 11/8/2006] See all Topics Labels: Access, Addendum, Excel, Expression Web, FrontPage, Outlook, PowerPoint, Word <Doug Klippert@ 3:01 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.
[Edited entry from 11/7/2006] See all Topics Labels: Access <Doug Klippert@ 3:40 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,
[Edited entry from 10/27/2006] See all Topics Labels: Access, Excel, PowerPoint, Word <Doug Klippert@ 3:39 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. [Edited entry from 10/17/2006] See all Topics Labels: Access <Doug Klippert@ 3:10 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 ![]() [Edited entry from 10/10/2006] See all Topics <Doug Klippert@ 3:05 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. [Edited entry from 10/2/2006] See all Topics Labels: Access <Doug Klippert@ 3:34 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." [Edited Entry from 9/24/2006] See all Topics <Doug Klippert@ 3:02 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. [Edited entry from 9/16/2006] See all Topics <Doug Klippert@ 3:44 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. [Edited entry from 8/31/2006] See all Topics Labels: Access <Doug Klippert@ 3:07 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. [Edited entry from 8/22/2006] See all Topics Labels: Access <Doug Klippert@ 3:58 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 String [Edited entry from 8/14/2006] See all Topics Labels: Access, Excel, PowerPoint, Word <Doug Klippert@ 3:52 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 [Edited entry from 8/13/2006] See all Topics Labels: Access, Excel, PowerPoint, Word <Doug Klippert@ 3:09 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 [Edited entry from 7/29/2006] See all Topics Labels: Access <Doug Klippert@ 3:00 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.
[Edited entry from 7/21/2006] See all Topics Labels: Access, Excel, Expression Web, FrontPage, Outlook, PowerPoint, Vista, Windows, Word <Doug Klippert@ 3:03 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. ![]() [Edited entry from 7/13/2006] See all Topics Labels: Access <Doug Klippert@ 3:15 AM
Comments:
Post a Comment
Monday, August 10, 2009 – Permalink – Military ClipartThousands of itemsIf you find the need for Armed Forces photos and art, here is the place to look. Regardless of your opinion about their present mission, the military does present a spectacular visage. ![]() "06/17/06 - An F/A-18E Super Hornet aircraft sits at the ready as storm clouds pass overhead aboard the Nimitz-class aircraft carrier USS Ronald Reagan (CVN 76) in the Philippine Sea June 17, 2006. HqDA.Army.Mil - Clipart [Edited entry from 7/7/2006] See all Topics Labels: Access, Excel, Expression Web, FrontPage, PowerPoint, Word <Doug Klippert@ 3:59 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) ![]() [Edited entry from 7/5/2006] See all Topics Labels: Access <Doug Klippert@ 3:04 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 [Edited entry from 6/27/2006] See all Topics Labels: Access <Doug Klippert@ 3:09 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 [Edited entry from 6/19/2006] See all Topics Labels: Access <Doug Klippert@ 3:26 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 [Edited entry from 6/9/2006] See all Topics Labels: Access <Doug Klippert@ 3:46 AM
Comments:
Post a Comment
Thursday, July 16, 2009 – Permalink – Access-Excel-XML-HTMLTransfer dataXML makes data transferable between applications. Here is a tutorial with downloadable files. Some simple guidance of how to transfer data from Excel or Access into HTML web pages using XML data files. VBA programs can be used to export data tables from Excel or Access into simple XML files. There are several examples of using different methods to display the XML and XSL files on web pages in order to quickly share your data with others. An introduction to Excel and XML data files Also: Some nice photos and calendar layout: Monthly calendar with photos [Edited entry from 6/8/2006] See all Topics <Doug Klippert@ 5:43 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 [Edited entry from 6/7/2006] See all Topics <Doug Klippert@ 3:22 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:
Labels: Access, Excel, PowerPoint, Word <Doug Klippert@ 3:59 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.
Labels: Access <Doug Klippert@ 3:17 AM
Comments:
Post a Comment
Wednesday, July 08, 2009 – Permalink – Polyglot PolynomialsToolPak TranslatorI was disappointed recently when I tried to look up Eric Desart's ToolPak translator. I found his site "niet beschikbaar." I won't use the boy and wet thumb story, but Ron de Bruin did spring up to save the day and make the download available. "Ever wanted an oversight of the Analysis-ToolPak Add-In functions, their descriptions, their arguments, their VBA and Procedure names, and all of this in your LOCAL language including translations versus the corresponding English names? Analysis ToolPak Translator [Edited entry from 5/31/2006] See all Topics <Doug Klippert@ 3:59 AM
Comments:
Post a Comment
Monday, June 29, 2009 – Permalink – Access Tools for Free or FeeShareware/FreewarePeter De Baets has some for pay and some for free downloads at Peter's Software. In the past I have used his Shrinker-Stretcher ShrinkerStretcher will automatically rescale/resize your MS Access forms, controls, and fonts to fit any screen resolution, desktop scheme, or font setting. For free includes:
[Edited entry from 5/14/2006] See all Topics Labels: Access <Doug Klippert@ 3:35 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. [Edited entry from 5/10/2006] See all Topics Labels: Access <Doug Klippert@ 3:26 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 [Edited entry from 5/8/2006] See all Topics <Doug Klippert@ 3:27 AM
Comments:
Post a Comment
Sunday, June 21, 2009 – Permalink – Clip Art at HomeInstall moreDo you remember all of the clip art that was available locally with Office XP? When you have an Internet connection, you have access to the Office Online collection, but if you would like more clip art installed on your machine: A small amount of sample clip art images was included The 2007 Office systems and Office 2003 and is part of the "local collection" that is searched when you do not have Internet access to the Microsoft Office Online Clip Art and Media Web site. Office 2003 no longer included a media content CD with additional clip art. However, the Microsoft Office XP Media Content CD can still be installed locally or on a network share.Support.Microsoft.com How to add clip art to Clip Organizer in a 2007 Office system and in Office 2003 [Edited entry from 5/5/5006] See all Topics Labels: Access, Excel, Expression Web, FrontPage, PowerPoint, Vista, Windows, Word <Doug Klippert@ 3:53 AM
Comments:
Post a Comment
Wednesday, June 17, 2009 – Permalink – VBA Variable ProblemsExplicit protectionIt's good practice to always use the Option Explicit statement in the beginning of your code modules to ensure that all variables are unambiguously declared in your procedures. With this process in place, you'll receive a "Variable not defined" error if you try to execute code containing undeclared variables. Without this statement, it's possible to mistype variable names, which would be interpreted as new Variant type variables. This could severely impact the results of your code, and you might not ever know it. If you do find a problem, tracking down where the error is can be a chore. Although you can manually type the statement into your modules, changing a setting in Access can ensure that the statement is always added to new modules.
[Edited entry from 5/2/2006] See all Topics Labels: Access, Excel, PowerPoint, Word <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,
[Edited entry from 4/24/2006] See all Topics Labels: Access <Doug Klippert@ 3:53 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 [Edited entry from 4/16/2006] See all Topics Labels: Access <Doug Klippert@ 3:32 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)
Labels: Access <Doug Klippert@ 3:29 AM
Comments:
yes, you are telling the truth we are able to repair our access file or mdb file in such a way but those file which are very less corrupted. For badly corrupted file you need the Access repair software which repair and recover your corrupted and damaged access file.
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. [Edited entry from 3/24/2006] See all Topics Labels: Access <Doug Klippert@ 3:17 AM
Comments:
Post a Comment
Sunday, May 10, 2009 – Permalink – Shortcuts to Access ObjectsQuick way inIf you often work with a certain Access objects (specific forms, queries, etc.) in a database, you can create a shortcut to it on your desktop. Click on the Object and drag it to the desktop.. Access will create the shortcut on your desktop, or another location. [Edited entry from 3/15/2006] See all Topics Labels: Access <Doug Klippert@ 3:10 AM
Comments:
Post a Comment
Wednesday, May 06, 2009 – Permalink – Who was that font I saw you with last night?That was no font, that was my typefaceYou can find the Fonts supplied with some Microsoft products Select a product name from the list to get a list of fonts supplied with that product. Microsoft's Typography is an interesting site to poke around in. Here are some books I use for reference material: Words into Typeby Marjorie E. Skillin, Robert Malcolm Gay ISBN 0139642625Stop Stealing Sheep & Find Out How Type Works |