|
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! 
|
 
Wednesday, August 31, 2011 – Permalink – Quick Subforms and SubreportsDrag 'em on overWhen you need to create a subform or subreport, you probably use the Subform/Subreport tool from the Toolbox to draw where you want to add the control. You can also create subform and subreports using drag and drop. Simply open the main form or report in Design view, then drag the appropriate form or report from the Database window to where you want the control created. Note that you'll still need to set Link Child Fields and Link Master Fields properties on the new control. See all Topics access <Doug Klippert@ 3:07 AM
Comments:
Post a Comment
Saturday, August 27, 2011 – Permalink – Filter Multiple FieldsTable sortsIn a table's Datasheet view, you can filter multiple selections in a few simple ways. In the first method, you select one of the fields you want to filter by and click the Filter By Selection button on the toolbar. Access filters the records by that selection. Next, select the second field you want to filter by and click the button again. Access filters the records even further by this second selection. Continue to follow these steps until you have filtered by the desired number of selections. You can also use Filter by Form. Click the icon on the toolbar. In the displayed form, enter the criteria. You can use And/Or statements, such as "Boston" Or "San Francisco". (Access will enter the quote marks for you.) For the third option, you use the Advanced Filter>Sort feature. To do so, select Records>Filter>Advanced Filter>Sort from the menu bar. Access displays a grid similar to the Query By Example grid. Now, drag down all the fields you want to filter by from the field list. Then, in the Criteria cells enter the values you want to filter for. When you have finished, click the Apply Filter button to see the results. Fourth, you could use Filter by input. Right click any entry in a field you want filtered. Enter the value in the Filter For box and hit Enter. You could then choose another field and sort again by another criteria. Creating a Query would let you save your filter, but these methods can be used to quickly display the desired information in a table. (In 2007 these options are on the Home tab in the Sort & Filter group) Florida Gulf Coast University: Sorting and Filtering eHow.com: How to Filter Records in a Microsoft Access Table Microsoft Kb: How to filter records in an Access database See all Topics access <Doug Klippert@ 3:11 AM
Comments:
Post a Comment
Wednesday, August 24, 2011 – Permalink – Email Access FormQuestion and collectionAccess 2007-10 has a wizard that will walk you through the process of sending an information gathering form through Outlook. The wizard is on the External Data tab in the Collect Data group.  "You begin with the Collect Data Through E-mail Messages Wizard, which guides you through the steps of creating a form. Collect data by using e-mail See all Topics access <Doug Klippert@ 3:24 AM
Comments:
Post a Comment
Saturday, August 13, 2011 – Permalink – Convert Access macros to VBAMacros to ModulesBefore Access 2000, the speculation was that Access would lose "Macros" and enter the exclusive world of VBA. It hasn't happened yet. If you have macros in a database that you would like to convert to code, doing so is easy. In Access 97: Right-click on the macro in the Database window and then choose Save As/Export from the shortcut menu. Then, select the Save As Visual Basic Module option button and click OK. You are then given the option of adding error handling functions and comments to the new module. Select the options you want and click Convert. In Access 2000/2002+: Right-click on the macro in the Database window and then choose Save As from the shortcut menu. Enter the name of the module you want to create in the text box and choose Module from the As dropdown list. Next, click OK. You will be given the option of adding error handling functions and comments to the new module. Select the options you want and click Convert. In 2007 go to Database Tools and look in the Macros group. Sam's Publishing: Taking More Control of Access By Gordon Padwick. Access 2007 introduces a new type of macros called embedded macros. Embedded macros are macros that are stored on an event instead of as a separate object. Embedded macros support name fix-up and are used extensively through-out our templates. They are largely targeted to information workers that don’t write code but useful for developers that are trying to perform some simple actions. See all Topics access <Doug Klippert@ 3:04 AM
Comments:
Post a Comment
Thursday, August 11, 2011 – Permalink – What the ####Truncated NumbersAccess has a new option that will show octothorps when the column is too narrow to display the entire value. When this option is not enabled, you see only part of the values in a column rather than ####. You'll find the selection under Access Options when you click the Office button. Go to Current Database and make your choice.  See all Topics access <Doug Klippert@ 3:48 AM
Comments:
Post a Comment
Wednesday, August 03, 2011 – Permalink – Copy Access Data to New RecordsFewer stepsThe Paste Append feature is often overlooked in Access. This feature lets you quickly create new records that copy existing information from other records. To see one way to use the feature, open a table in Datasheet view.
See all Topics access <Doug Klippert@ 3:25 AM
Comments:
Post a Comment
Monday, August 01, 2011 – Permalink – Security Questions2009-2010This article provides an overview of the security features offered by Access 2009-2010, and explains how to use the tools that Access provides for helping to secure a database. This article also links to more detailed content about various security features.
Introduction to Security See all Topics access <Doug Klippert@ 3:04 AM
Comments:
Post a Comment
|
