SitemapMain PageTable of contentCopyrightPrefaceWhat This Book Is AboutWho This Book Is ForWhat You Need to Use This BookHow This Book Is OrganizedWhat We Left OutConventions Used in This BookComments and QuestionsAcknowledgmentsChapter 1. QueriesRecipe 1.1 Specify Query Criteria at RuntimeRecipe 1.2 Using a Form-Based Parameter QueryRecipe 1.3 Limit the Items in One Combo Box Based on the Selected Item in AnotherRecipe 1.4 Make Formatted Date Columns Sort Correctly in a Crosstab QueryRecipe 1.5 Group Mailing Labels by AddressRecipe 1.6 Use a Field in One Table to Update a Field in Another TableRecipe 1.7 Use a VBA Variable to Filter a QueryRecipe 1.8 Use a Query to Retrieve a Random Set of RowsRecipe 1.9 Create a Query That Will Show Aging of ReceivablesRecipe 1.10 Create a Join That's Based on a Comparison Other than EqualityRecipe 1.11 Create a Query to Combine Data from Two Tables with Similar StructuresRecipe 1.12 Create a Combo Box That Allows a User to Select N/ARecipe 1.13 Use a Query to Show the Relationship Between Employees and SupervisorsRecipe 1.14 Create a Query That Uses Case-Sensitive CriteriaRecipe 1.15 Use a Query to Create a New Table Complete with IndexesRecipe 1.16 Save My Queries in a Table for Better Programmatic Access and SecurityRecipe 1.17 Create a Recordset Based on a Parameter Query from VBA CodeChapter 2. FormsRecipe 2.1 Make Custom Templates for Forms and ReportsRecipe 2.2 Highlight the Current Field in Data-Entry FormsRecipe 2.3 Restrict the User to a Single Row on a FormRecipe 2.4 Use an Option Group to Collect and Display Textual InformationRecipe 2.5 Display Multiple Pages of Information on One FormRecipe 2.6 Provide Record Navigation Buttons on a FormRecipe 2.7 Size a Form's Controls to Match the Form's SizeRecipe 2.8 Make a Simple 'Searching' List BoxRecipe 2.9 Create a Replacement for Access's InputBoxRecipe 2.10 Store the Sizes and Locations of FormsRecipe 2.11 Open Multiple Instances of a FormChapter 3. ReportsRecipe 3.1 Create a Report with Line NumbersRecipe 3.2 Print the Value of a Parameter on a ReportRecipe 3.3 Create a Report with Multiple ColumnsRecipe 3.4 Print a Message on a Report if Certain Conditions Are MetRecipe 3.5 Create a Page-Range Indicator on Each PageRecipe 3.6 Create a Simple Bar Graph on a ReportRecipe 3.7 Create a Page TotalRecipe 3.8 Avoid Unwanted Blank Rows on Mailing LabelsRecipe 3.9 Suppress Printing a Report if There Are No Records to PrintRecipe 3.10 Print Different Headers or Footers on Odd and Even PagesRecipe 3.11 Make a Vertical Line the Same Height as a CanGrow/CanShrink ControlRecipe 3.12 Alternate Gray Bars on My ReportsRecipe 3.13 Print Only Records Matching a Form's FilterRecipe 3.14 Keep a Report from Breaking at an Inappropriate PlaceRecipe 3.15 Customize a Report's Grouping and Sorting at RuntimeChapter 4. ApplicationsRecipe 4.1 Convert Queries into Embedded SQL StatementsRecipe 4.2 Build an Object InventoryRecipe 4.3 Verify That Objects Use Consistent SettingsRecipe 4.4 Hide Access Screen ActivityRecipe 4.5 Find out What Language Version of Access Is InstalledRecipe 4.6 Internationalize Text in Your ApplicationsRecipe 4.7 Change and Reset the Access Caption BarRecipe 4.8 Use the Windows File Open/Save Common DialogsRecipe 4.9 Clean Test Data out of a Database When You're Ready to Ship ItRecipe 4.10 Secure Your Access DatabaseChapter 5. PrintersRecipe 5.1 Retrieve a List of All the Installed Output DevicesRecipe 5.2 Set and Retrieve the Name of the Default Output DeviceRecipe 5.3 Programmatically Change Margin and Column Settings for ReportsRecipe 5.4 Programmatically Change Printer OptionsRecipe 5.5 Programmatically Control the Paper SourceRecipe 5.6 Retrieve Information About a Report or Form's Selected PrinterRecipe 5.7 Choose an Output Device at RuntimeRecipe 5.8 Find Which Reports Are Not Set to Print to the Default PrinterChapter 6. DataRecipe 6.1 Save with Each Record the Name of the Last Person Who Edited It and the Date and TimeRecipe 6.2 Determine if You're on a New Record in a FormRecipe 6.3 Find All Records with Names That Sound AlikeRecipe 6.4 Find the Median Value for a FieldRecipe 6.5 Quickly Find a Record in a Linked TableRecipe 6.6 Get a Complete List of Field Properties from a Table or QueryRecipe 6.7 Create and Use Flexible AutoNumber FieldsRecipe 6.8 Back Up Selected Objects to Another DatabaseChapter 7. VBARecipe 7.1 Build Up String References with Embedded QuotesRecipe 7.2 Create a Global Procedure StackRecipe 7.3 Create an Execution Time ProfilerRecipe 7.4 Multitask Your VBA CodeRecipe 7.5 Programmatically Add Items to a List or Combo BoxRecipe 7.6 Pass a Variable Number of Parameters to a ProcedureRecipe 7.7 Sort an Array in VBARecipe 7.8 Fill a List Box with a List of FilesRecipe 7.9 Handle Object Properties, in GeneralRecipe 7.10 Detect Whether an Object ExistsChapter 8. OptimizationRecipe 8.1 Accelerate the Load Time of FormsRecipe 8.2 Make Slow Forms Run FasterRecipe 8.3 Make Combo Boxes Load FasterRecipe 8.4 Use Jet Engine Optimizations to Speed Up QueriesRecipe 8.5 Accelerate VBA CodeRecipe 8.6 Test the Comparative Benefits of Various Optimization TechniquesRecipe 8.7 Accelerate Multiuser ApplicationsRecipe 8.8 Accelerate Client/Server ApplicationsChapter 9. User InterfaceRecipe 9.1 Create Context-Sensitive Keyboard ShortcutsRecipe 9.2 Create a Form with No Menu or ToolbarRecipe 9.3 Create a Geographical Map InterfaceRecipe 9.4 Mark a Record on a Form and Return to It LaterRecipe 9.5 Carry Data Forward from Record to RecordRecipe 9.6 Create a Combo Box That Accepts New EntriesRecipe 9.7 Create Animated ButtonsRecipe 9.8 Create an Expanding DialogRecipe 9.9 Use an ActiveX ControlRecipe 9.10 Create a Generic, Reusable Status MeterChapter 10. Multiuser ApplicationsRecipe 10.1 Properly Secure Your DatabaseRecipe 10.2 Maintain Multiple Synchronized Copies of the Same DatabaseRecipe 10.3 Create a Transaction LogRecipe 10.4 Send Messages to Other Users Without Using EmailRecipe 10.5 Programmatically Track Users and GroupsRecipe 10.6 Adjust an Application Based on Who's Logged InRecipe 10.7 List All Users with Blank PasswordsRecipe 10.8 Track Which Users Have a Shared Database OpenRecipe 10.9 Determine if a Record Is Locked and by WhomRecipe 10.10 Set a Maximum Locking Interval for a RecordChapter 11. Windows APIsRecipe 11.1 Remove a Form's System Menu and Maximize/Minimize ButtonsRecipe 11.2 Flash a Window's Titlebar or IconRecipe 11.3 Classify Keypresses in a Language-Independent MannerRecipe 11.4 Restrict Mouse Movement to a Specific RegionRecipe 11.5 Run Another Program and Pause Until It's DoneRecipe 11.6 Exit Windows Under Program ControlRecipe 11.7 Run the Application Associated with a Data FileRecipe 11.8 Check to See if an Application Is Already RunningRecipe 11.9 Retrieve a List of All Top-Level WindowsRecipe 11.10 Close a Running Windows ApplicationRecipe 11.11 Set File Date and Time StampsRecipe 11.12 Retrieve Information About Available DrivesRecipe 11.13 Collect and Display Information on the System and the Access InstallationRecipe 11.14 Create and Cancel Network Connections ProgrammaticallyChapter 12. AutomationRecipe 12.1 Play an Embedded Sound File from Within an ApplicationRecipe 12.2 Print an Access Report from ExcelRecipe 12.3 Use Excel's Functions from Within AccessRecipe 12.4 Perform a Mail Merge from Access to WordRecipe 12.5 Add an Item to the Startup GroupRecipe 12.6 Send Access Data to Excel and Create an Excel ChartRecipe 12.7 Create a PowerPoint Presentation from Access DataRecipe 12.8 Add a Contact and Send Email Through OutlookChapter 13. Data Access PagesRecipe 13.1 Replace Navigation Button Images with Your Own ImagesRecipe 13.2 Use Labels or Other Controls for Record NavigationRecipe 13.3 Change the Text Displayed with a Navigation ControlRecipe 13.4 Create a DAP that Allows You to Update DataRecipe 13.5 Create One File to Store Connection Information for All DAPs in an ApplicationRecipe 13.6 Programmatically Change the Connection String for All Pages in a DatabaseRecipe 13.7 Change the Default Settings for New DAPsRecipe 13.8 Use Parameters Set in One DAP to Open AnotherChapter 14. SQL ServerRecipe 14.1 Dynamically Link SQL Server Tables at RuntimeRecipe 14.2 Dynamically Connect to SQL Server from an ADPRecipe 14.3 Share an ADP from a Shared Network FolderRecipe 14.4 Fill the Drop-Down Lists When Using ServerFilterByForm in an ADPRecipe 14.5 Pass Parameters to Stored Procedures from Pass-Through Queries in an MDBRecipe 14.6 Pass Parameters to Stored Procedures from an ADPRecipe 14.7 Use Controls as Parameters for the Row Source of Combo and List Boxes in an ADPRecipe 14.8 Reference Data from More than One SQL Server Database in an ADPRecipe 14.9 Use Views to Update Data in an ADP When Users Don't Have Permissions on TablesChapter 15. Office Web and SharePointRecipe 15.1 Work with SharePoint Data from AccessRecipe 15.2 Create a SharePoint Data View Web Part Based on Access DataRecipe 15.3 Conditionally Format a Data View Web PartRecipe 15.4 Create a Master/Detail Page using Data View Web PartsRecipe 15.5 Post Web Form Data to an Access DatabaseRecipe 15.6 Create a Web Frontend to an Access Table Using FrontPageChapter 16. Smart TagsRecipe 16.1 Use the Built-in Smart TagsRecipe 16.2 Display Multiple Smart Tags on Multiple FormsRecipe 16.3 Display Smart Tags when Application StartsRecipe 16.4 Execute a Smart Tag Action Without Displaying the Smart TagRecipe 16.5 Create a Smart Tag on a Table in an Access ProjectRecipe 16.6 Create a Custom Smart Tag to Get a Weather ReportRecipe 16.7 Create a Custom Smart Tag DLLChapter 17. .NETRecipe 17.1 Call a .NET Component from AccessRecipe 17.2 Call a .NET Component Containing a Parameterized ConstructorRecipe 17.3 Retrieve Access Data from an ASP.NET ApplicationRecipe 17.4 Call a Web Service from AccessRecipe 17.5 Work with a Web Service that Returns a DataSetRecipe 17.6 Print an Access Report from .NET Windows Form ApplicationChapter 18. XMLXML OverviewRecipe 18.1 Import XML Structured as ElementsRecipe 18.2 Import XML into Existing TablesRecipe 18.3 Import XML Using a Schema (XSD)Recipe 18.4 Export XMLRecipe 18.5 Exporting Selected Columns to an HTML TableRecipe 18.6 Export Unrelated TablesRecipe 18.7 Export Using a Where ClauseRecipe 18.8 Export a ReportColophonIndexIndex SYMBOLIndex AIndex BIndex CIndex DIndex EIndex FIndex GIndex HIndex IIndex JIndex KIndex LIndex MIndex NIndex OIndex PIndex QIndex RIndex SIndex TIndex UIndex VIndex WIndex X
لطفا منتظر باشید ...
