| Home Fees/Services Access Examples Tutorials Access Download Articles Search Contact SiteMap Privacy Links | ||
|
Custom Software
Development Database Programming Examples Access Database Downloads |
 |
|
| |||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Our website is divided into two main sections:
At the top of all pages you will find a menu of key pages: Home Page, Customer Overview, Tutorial & Tips, Site Map, Site Search, Support Links, and Contact: Home Page - Overview of the entire site including highlights of key subjects Customer Overview - As mentioned above, this is the starting point of those looking for us to create, fix, or support a database. Tutorial & Tips - Again, as above, offers detailed examples in nearly all areas of Access database development - these pages are design for the novice - intermediate Access programmer.
Site Map - Here. Site Search - Gives you the ability to search our site for specific examples and subjects - note you should include some words that are not in the left or right navigation borders otherwise too many pages will be returned in your search. Support Links - Displays:
Contact - Our email address, mailing address, phone number and hours of operation. |
|||
|
Customer Overview/ Customer Information Menu Group |
|||
|
Getting Started Customer Support Consulting Credentials Clients' FAQs Consulting Rates Visitor Feedback Recent Clients Why Blue Claw? Access Right For You? Conversion Service Programming Quickly Access on the Internet ODBC To Corp. DBs Database Snapshots |
On the left are links to pages written for our prospective clients. Each pages is designed to answer specific questions about our experience and capabilities. We also offer details about subjects that all owners of software systems should be aware - specifically Risk Assessment and Disaster Recovery Planning. | ||
|
Tutorial & Tips/ Programmer Help Menu Group |
|||
|
|
On the right are links to help topic home
pages. Each of these links will take you to a subject home page
where you'll find several to many programming examples and detailed
discussion of key areas such as table design. If you hover your mouse over the links you'll see an additional popup explanation about the content of the link. |
SQL Query Examples VBA Visual Basic Code Combo Box Help Report Programming Manage Table DDL Table Design Guide Domain Aggregate Fx Form Programming Docmd Action Method RunCommand Method ADO Connections Form Event Examples Application Methods Access Security Security Alternative Download Examples |
|
| Below we have displayed the list of examples contained in each of the programmer help home pages | |||
| The SQL Query topic home page contains many examples on tricky or lesser known query techniques that can increase the functionality of databases. | SQL Query Help & Examples |
Aggregate Functions Child/Parent Table Query Choose Command More Choose Option Statement Crosstab Query Help Crosstab Query More Date/Time Data Retrieval Delete Query Basics Dynamic Links → Ext DB Filter Report Records Group By Clause Basics Having Clause Basics Histogram Query Help Insert Into Basics Master/Detail Updates Order By Dynamic Parameter Query Predicate Example Same Table Field Update Scalar Query Function Select Statement Basics Select Top 1 Record Union Query Example Update Statement Basics |
|
| You will find a lot of crossover between the SQL and VBA examples - we use SQL programming a lot within visual basic/VB script. | VBA Sample & Coding Help |
Age Calculation VB |
|
|
|
|||
| Everything you ever wanted to know about combo boxes, lookup lists, drop down list boxes and more. | Combo Boxes Explained |
Yes/no Drop Down
List Table-based Combo Box Combo Box: All/Any choice Lookup List-Correct Way Fill In Other Form Fields Best Way to Fill Form Field Dependent Dropdown List Lookup Lists in One Table Speed up Combo Boxes |
|
| Several tricks and little known techniques which can occasionally bail out a novice programmer. | Report Programming Tips & Tricks |
Line
Counter Sample Code Alternate Line Shading Running Sum Calculation Display Page Subtotals Dynamic Graphics Overlay Dynamic Crosstab Report Mail merge Within Access |
|
| Creating and changing tables programmatically in Access - maybe we should add a few examples here. | Table Management Using DDL |
Access Create Table Access Create Index Access Alter Table |
|
| This is the most important topic on the entire site. Novice and intermediate developers should start here to ensure their databases are structured correctly. Be sure to read the discussions on first, second and third normal form for table design. | Table Design Guide |
Link Database Table 0th Normal Form (0nf) 1st Normal Form (1nf) 2nd Normal Form (2nf) 3rd Normal Form (3nf) Our Design Rules Design Help Summary Reserved Words Tips and Tricks |
|
| Several examples showing how to use domain aggregate functions - see the compound dynamic lookup (DLookup) example for code to drive you crazy. | Domain Aggregate Function Examples |
Dlookup Function Example Compound Dlookup Code DMin & DMax Examples DStDev & DStDevP Code |
|
| Real-life coding examples for special form programming situations. | Form Programming Help |
Unbound Forms NotInList Event Master/Detail Forms Form Subtotal Fields Speed Up Forms |
|
| Don't use macros external to visual basic - use the DoCmd to active a macro within visual basic - makes following and documenting easier. | Docmd Action Examples |
Access Docmd AddMenu Action Access Docmd ApplyFilter Action Access Docmd CancelEvent Access Docmd Close Object Command Access Docmd CopyObject Access Docmd DeleteObject Access Docmd FindRecord Action Access Docmd FindNext Command Access Docmd GotoControl Method Access Docmd HourGlass Setting Access DoCmd Min/Max/Restore Access Docmd OpenForm Command Access Docmd OpenQuery Example Access DoCmd OutputTo |
|
|
|
|||
The hardest part of getting started with Active Server Page programming is getting the connection to the database to work. Here you'll find examples that may be a little easier to follow than others that you have found on the Internet. |
ASP ADO Connection Examples |
Access DSN Connection OLEDB Provider for Jet Connect To Remote DB ADO File-DSN Connection DSN-Less Connection SQL/Server ODBC Method OLE DB UDL Connection Open Method Defined |
|
| Run the old menuitem commands directly with the Docmd.RunCommand | DoCmd.RunCommand Method Examples | ||
| Definitions and brief programming examples of common events in Access forms. | Form Event Help & Examples |
AfterInsert Event AfterUpdate Event BeforeUpdate Event OnChange Event OnClose Example OnCurrent Event OnDblClick Event OnError Event OnExit Event Help Timer Event VBA Undo Event Method |
|
| The Application object contains all of the Microsoft Access objects and collections. Application object can be used to apply methods or property settings to the entire Microsoft Access application. | Application Method Examples |
Access Error Method Add To Favorites Method Build Criteria Method Close Current Database Code DB Method Compact Repair Method Convert Access Project |
|
|
Dual Interest Pages |
|||
| Articles about associated with information technology | Articles |
Disaster Recovery Plan Form Design Help MS Access Versus Replication of Database Risk Assessment Selecting a Consultant Speed Up Access DB |
|
| The following links appear in both the Customer Overview side menu and the Programmer Help side menu. We feel that these pages will be of interest to both types of visitors: | |||
| Microsoft Access database case studies | Case Studies |
Asbestos Survey Contact Management CRM Software Solution Document Rev Mngr HOA Management Inventory Tracking Loan Process Software Order Management Pell Grant Manager Personnel Agency DB PM Schedule Software Real Estate Marketing Reservations System Rx Assistance Plans Subscription Manager Tax Doc Manager Work Order Software |
|
| ASP Examples each have several associated pages that are detailed on the right. | ASP Examples |
Bar graph w/ Drilldown & Data Update Query by State, Town or Zip Code See Dynamic Links Maps & Weather Selectable Roll up of Sales Analysis
|
|
|
Database Comparison to Access Comparison of Microsoft Access to other leading database management systems |
Filemaker Pro versus Access SQL Server versus Access Oracle versus Access |
||
|
Download Microsoft Access Programming Tutorials We have created almost a dozen downloadable Microsoft Access databases demonstrating solutions to programming tasks. These download solutions range in complexity from simple to advanced. |
Access Send
Email Inventory Calculations Example Global Variables as Parameters Continuous Form Dependent Combo Box Continuous-Continuous Master/Detail Forms |
||
|
Contact Information |
