Access Cookbook, 2nd Edition [Electronic resources] نسخه متنی

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

اصطلاحنامه مجموعه ها مرورالفبایی لغت نامه دهخدا

➟

جستجو در لغت نامه

بیشتر

کتابخانه شخصی پرسش از کتابدار ارسال منبع

Access Cookbook, 2nd Edition [Electronic resources] - نسخه متنی

Ken Getz; Paul Litwin; Andy Baron

| ،

افزودن به کتابخانه شخصی

میخواهم بخوانم

درحال خواندن

خوانده شده

ارسال به دوستان

آدرس پست الکترونیک گیرنده :

آدرس پست الکترونیک فرستنده :

نام و نام خانوارگی فرستنده :

پیغام برای گیرنده ( حداکثر 250 حرف ) :

کد امنیتی را وارد نمایید

ارسال

جستجو در متن کتاب

بیشتر

تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب

➟

جستجو در لغت نامه

بیشتر

لیست موضوعات

Sitemap

Table of content

What This Book Is About

Who This Book Is For

What You Need to Use This Book

How This Book Is Organized

What We Left Out

Conventions Used in This Book

Comments and Questions

Acknowledgments

Chapter 1. Queries

Recipe 1.1 Specify Query Criteria at Runtime

Recipe 1.2 Using a Form-Based Parameter Query

Recipe 1.3 Limit the Items in One Combo Box Based on the Selected Item in Another

Recipe 1.4 Make Formatted Date Columns Sort Correctly in a Crosstab Query

Recipe 1.5 Group Mailing Labels by Address

Recipe 1.6 Use a Field in One Table to Update a Field in Another Table

Recipe 1.7 Use a VBA Variable to Filter a Query

Recipe 1.8 Use a Query to Retrieve a Random Set of Rows

Recipe 1.9 Create a Query That Will Show Aging of Receivables

Recipe 1.10 Create a Join That's Based on a Comparison Other than Equality

Recipe 1.11 Create a Query to Combine Data from Two Tables with Similar Structures

Recipe 1.12 Create a Combo Box That Allows a User to Select N/A

Recipe 1.13 Use a Query to Show the Relationship Between Employees and Supervisors

Recipe 1.14 Create a Query That Uses Case-Sensitive Criteria

Recipe 1.15 Use a Query to Create a New Table Complete with Indexes

Recipe 1.16 Save My Queries in a Table for Better Programmatic Access and Security

Recipe 1.17 Create a Recordset Based on a Parameter Query from VBA Code

Chapter 2. Forms

Recipe 2.1 Make Custom Templates for Forms and Reports

Recipe 2.2 Highlight the Current Field in Data-Entry Forms

Recipe 2.3 Restrict the User to a Single Row on a Form

Recipe 2.4 Use an Option Group to Collect and Display Textual Information

Recipe 2.5 Display Multiple Pages of Information on One Form

Recipe 2.6 Provide Record Navigation Buttons on a Form

Recipe 2.7 Size a Form's Controls to Match the Form's Size

Recipe 2.8 Make a Simple 'Searching' List Box

Recipe 2.9 Create a Replacement for Access's InputBox

Recipe 2.10 Store the Sizes and Locations of Forms

Recipe 2.11 Open Multiple Instances of a Form

Chapter 3. Reports

Recipe 3.1 Create a Report with Line Numbers

Recipe 3.2 Print the Value of a Parameter on a Report

Recipe 3.3 Create a Report with Multiple Columns

Recipe 3.4 Print a Message on a Report if Certain Conditions Are Met

Recipe 3.5 Create a Page-Range Indicator on Each Page

Recipe 3.6 Create a Simple Bar Graph on a Report

Recipe 3.7 Create a Page Total

Recipe 3.8 Avoid Unwanted Blank Rows on Mailing Labels

Recipe 3.9 Suppress Printing a Report if There Are No Records to Print

Recipe 3.10 Print Different Headers or Footers on Odd and Even Pages

Recipe 3.11 Make a Vertical Line the Same Height as a CanGrow/CanShrink Control

Recipe 3.12 Alternate Gray Bars on My Reports

Recipe 3.13 Print Only Records Matching a Form's Filter

Recipe 3.14 Keep a Report from Breaking at an Inappropriate Place

Recipe 3.15 Customize a Report's Grouping and Sorting at Runtime

Chapter 4. Applications

Recipe 4.1 Convert Queries into Embedded SQL Statements

Recipe 4.2 Build an Object Inventory

Recipe 4.3 Verify That Objects Use Consistent Settings

Recipe 4.4 Hide Access Screen Activity

Recipe 4.5 Find out What Language Version of Access Is Installed

Recipe 4.6 Internationalize Text in Your Applications

Recipe 4.7 Change and Reset the Access Caption Bar

Recipe 4.8 Use the Windows File Open/Save Common Dialogs

Recipe 4.9 Clean Test Data out of a Database When You're Ready to Ship It

Recipe 4.10 Secure Your Access Database

Chapter 5. Printers

Recipe 5.1 Retrieve a List of All the Installed Output Devices

Recipe 5.2 Set and Retrieve the Name of the Default Output Device

Recipe 5.3 Programmatically Change Margin and Column Settings for Reports

Recipe 5.4 Programmatically Change Printer Options

Recipe 5.5 Programmatically Control the Paper Source

Recipe 5.6 Retrieve Information About a Report or Form's Selected Printer

Recipe 5.7 Choose an Output Device at Runtime

Recipe 5.8 Find Which Reports Are Not Set to Print to the Default Printer

Chapter 6. Data

Recipe 6.1 Save with Each Record the Name of the Last Person Who Edited It and the Date and Time

Recipe 6.2 Determine if You're on a New Record in a Form

Recipe 6.3 Find All Records with Names That Sound Alike

Recipe 6.4 Find the Median Value for a Field

Recipe 6.5 Quickly Find a Record in a Linked Table

Recipe 6.6 Get a Complete List of Field Properties from a Table or Query

Recipe 6.7 Create and Use Flexible AutoNumber Fields

Recipe 6.8 Back Up Selected Objects to Another Database

Recipe 7.1 Build Up String References with Embedded Quotes

Recipe 7.2 Create a Global Procedure Stack

Recipe 7.3 Create an Execution Time Profiler

Recipe 7.4 Multitask Your VBA Code

Recipe 7.5 Programmatically Add Items to a List or Combo Box

Recipe 7.6 Pass a Variable Number of Parameters to a Procedure

Recipe 7.7 Sort an Array in VBA

Recipe 7.8 Fill a List Box with a List of Files

Recipe 7.9 Handle Object Properties, in General

Recipe 7.10 Detect Whether an Object Exists

Chapter 8. Optimization

Recipe 8.1 Accelerate the Load Time of Forms

Recipe 8.2 Make Slow Forms Run Faster

Recipe 8.3 Make Combo Boxes Load Faster

Recipe 8.4 Use Jet Engine Optimizations to Speed Up Queries

Recipe 8.5 Accelerate VBA Code

Recipe 8.6 Test the Comparative Benefits of Various Optimization Techniques

Recipe 8.7 Accelerate Multiuser Applications

Recipe 8.8 Accelerate Client/Server Applications

Chapter 9. User Interface

Recipe 9.1 Create Context-Sensitive Keyboard Shortcuts

Recipe 9.2 Create a Form with No Menu or Toolbar

Recipe 9.3 Create a Geographical Map Interface

Recipe 9.4 Mark a Record on a Form and Return to It Later

Recipe 9.5 Carry Data Forward from Record to Record

Recipe 9.6 Create a Combo Box That Accepts New Entries

Recipe 9.7 Create Animated Buttons

Recipe 9.8 Create an Expanding Dialog

Recipe 9.9 Use an ActiveX Control

Recipe 9.10 Create a Generic, Reusable Status Meter

Chapter 10. Multiuser Applications

Recipe 10.1 Properly Secure Your Database

Recipe 10.2 Maintain Multiple Synchronized Copies of the Same Database

Recipe 10.3 Create a Transaction Log

Recipe 10.4 Send Messages to Other Users Without Using Email

Recipe 10.5 Programmatically Track Users and Groups

Recipe 10.6 Adjust an Application Based on Who's Logged In

Recipe 10.7 List All Users with Blank Passwords

Recipe 10.8 Track Which Users Have a Shared Database Open

Recipe 10.9 Determine if a Record Is Locked and by Whom

Recipe 10.10 Set a Maximum Locking Interval for a Record

Chapter 11. Windows APIs

Recipe 11.1 Remove a Form's System Menu and Maximize/Minimize Buttons

Recipe 11.2 Flash a Window's Titlebar or Icon

Recipe 11.3 Classify Keypresses in a Language-Independent Manner

Recipe 11.4 Restrict Mouse Movement to a Specific Region

Recipe 11.5 Run Another Program and Pause Until It's Done

Recipe 11.6 Exit Windows Under Program Control

Recipe 11.7 Run the Application Associated with a Data File

Recipe 11.8 Check to See if an Application Is Already Running

Recipe 11.9 Retrieve a List of All Top-Level Windows

Recipe 11.10 Close a Running Windows Application

Recipe 11.11 Set File Date and Time Stamps

Recipe 11.12 Retrieve Information About Available Drives

Recipe 11.13 Collect and Display Information on the System and the Access Installation

Recipe 11.14 Create and Cancel Network Connections Programmatically

Chapter 12. Automation

Recipe 12.1 Play an Embedded Sound File from Within an Application

Recipe 12.2 Print an Access Report from Excel

Recipe 12.3 Use Excel's Functions from Within Access

Recipe 12.4 Perform a Mail Merge from Access to Word

Recipe 12.5 Add an Item to the Startup Group

Recipe 12.6 Send Access Data to Excel and Create an Excel Chart

Recipe 12.7 Create a PowerPoint Presentation from Access Data

Recipe 12.8 Add a Contact and Send Email Through Outlook

Chapter 13. Data Access Pages

Recipe 13.1 Replace Navigation Button Images with Your Own Images

Recipe 13.2 Use Labels or Other Controls for Record Navigation

Recipe 13.3 Change the Text Displayed with a Navigation Control

Recipe 13.4 Create a DAP that Allows You to Update Data

Recipe 13.5 Create One File to Store Connection Information for All DAPs in an Application

Recipe 13.6 Programmatically Change the Connection String for All Pages in a Database

Recipe 13.7 Change the Default Settings for New DAPs

Recipe 13.8 Use Parameters Set in One DAP to Open Another

Chapter 14. SQL Server

Recipe 14.1 Dynamically Link SQL Server Tables at Runtime

Recipe 14.2 Dynamically Connect to SQL Server from an ADP

Recipe 14.3 Share an ADP from a Shared Network Folder

Recipe 14.4 Fill the Drop-Down Lists When Using ServerFilterByForm in an ADP

Recipe 14.5 Pass Parameters to Stored Procedures from Pass-Through Queries in an MDB

Recipe 14.6 Pass Parameters to Stored Procedures from an ADP

Recipe 14.7 Use Controls as Parameters for the Row Source of Combo and List Boxes in an ADP

Recipe 14.8 Reference Data from More than One SQL Server Database in an ADP

Recipe 14.9 Use Views to Update Data in an ADP When Users Don't Have Permissions on Tables

Chapter 15. Office Web and SharePoint

Recipe 15.1 Work with SharePoint Data from Access

Recipe 15.2 Create a SharePoint Data View Web Part Based on Access Data

Recipe 15.3 Conditionally Format a Data View Web Part

Recipe 15.4 Create a Master/Detail Page using Data View Web Parts

Recipe 15.5 Post Web Form Data to an Access Database

Recipe 15.6 Create a Web Frontend to an Access Table Using FrontPage

Chapter 16. Smart Tags

Recipe 16.1 Use the Built-in Smart Tags

Recipe 16.2 Display Multiple Smart Tags on Multiple Forms

Recipe 16.3 Display Smart Tags when Application Starts

Recipe 16.4 Execute a Smart Tag Action Without Displaying the Smart Tag

Recipe 16.5 Create a Smart Tag on a Table in an Access Project

Recipe 16.6 Create a Custom Smart Tag to Get a Weather Report

Recipe 16.7 Create a Custom Smart Tag DLL

Chapter 17. .NET

Recipe 17.1 Call a .NET Component from Access

Recipe 17.2 Call a .NET Component Containing a Parameterized Constructor

Recipe 17.3 Retrieve Access Data from an ASP.NET Application

Recipe 17.4 Call a Web Service from Access

Recipe 17.5 Work with a Web Service that Returns a DataSet

Recipe 17.6 Print an Access Report from .NET Windows Form Application

Chapter 18. XML

Recipe 18.1 Import XML Structured as Elements

Recipe 18.2 Import XML into Existing Tables

Recipe 18.3 Import XML Using a Schema (XSD)

Recipe 18.4 Export XML

Recipe 18.5 Exporting Selected Columns to an HTML Table

Recipe 18.6 Export Unrelated Tables

Recipe 18.7 Export Using a Where Clause

Recipe 18.8 Export a Report

توضیحات

افزودن یادداشت جدید

[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
[X]

Label property (forms)

background colors for

changing default

internationalizing messages

limitations linking to text box

using as navigation controls
2nd

classifying characters

determining version

importance of optimizing techniques

internationalizing messages

LanguageSettings property (Application object)

LBound function
2nd

LDB file extension
2nd

least-restrictive rule
2nd

left outer join

LeftMargin property (Printer object)

Let property procedure
2nd
3rd
4th

LimitToList property (combo boxes)
2nd
3rd
4th

Line method (reports)
2nd
3rd

LinkChildFields property (subforms)
2nd

linked tables

finding records in

linking data tables

linking dynamically

linking

Access and Excel

Excel worksheet to database

servers in SQL Server

SQL Server tables dynamically

LinkMasterFields property (subforms)
2nd

list boxes

adding items
2nd

bound to queries

client/server applications and

controls as parameters

creating permanently open

filling with lists of files

performance bottlenecks

restrictions with binding

selecting multiple items

ListCount property (controls)

ListFields method (fields)

ListRows property (combo boxes)
2nd

lists

choosing from fixed lists

displaying and collecting information

filling drop-down

obtaining tables/queries

ListWidth property (combo boxes)
2nd

adjusting applications

animated buttons

Calendar control
2nd

choosing default printer

faster loading of combo boxes and

highlighting current field

printer names list

procedure stack and

retrieving setting with

tracking open shared databases

local variables

LocalTimeToFileTime function

Locked property (controls)

locks

error handling and

setting maximum intervals

LockWindowUpdate function
2nd

Logon method (Namespace)

Long Binary Data

importance of optimizing when

object inventory

pausing applications and

PowerPoint presentations