Recent posts are here
Search vb123 Here
Project Management & Data Modelling
Data Modeling for the Access Newcomer, Part 1
Data Modeling for the Access Newcomer, Part 2
An Access Project, Part 1: Requirements
An Access Project: Data Modeling
An Access Project: Creating a Great Report
Editorial: Working in the Real World
Data Modelling with Access and Visio
The ABCs of Requirements Management for Access
The Trouble with Normal
Learn to Use "Relationship" and "Normal" in the Same Sentence!
Parts 2-5 Normalization and Management Advice
Tables
What's in a Table?
Managing Lookup Tables
Managing State Transitions
Everything About AutoNumbers
Do More for Less
Decomposing a Badly Designed Table
I've Got Plenty of Nothing
200302 Combining Tables
List Boxes and Combo Boxes
Tricks With Combo Boxes
Drilling with Combo Boxes
Creating Paired Listbox Controls, Part 1
Creating Paired Listbox Controls, Part 2
Use Classes to Enhance List and Combo Boxes
Your Listbox-Filling Options
Get More From Your List Boxes
Access Answers: Let me check my list…
Intelligent Combo Boxes
Managing controls, check & text boxes, buttons etc
Drag and Drop in Access
Dynamic Checklists
Working with groups of controls
We Get Letters
Managing Margins Of Text Box and Label Controls
Alternative Buttons
From Zoom Box to Custom Dialog
Validate input such as ZIP codes and postal codes
How can I change the size of the checkbox on my form
Find controls where the Procedures have gone missing
Ordering Controls, Fixing Bugs, and Speeding Up Remote Databases
Choosing Options
Queries
Access Answers: All in the Family
Computing the Median (Again)
Auto-Generated Update SQL
Making the Grade
Simplifying Queries
Simplifying Complex SQL
Access Subquery Techniques
Combining Tables using Union Queries
Tame the Crosstab Missing Column Beast
Subquery Notes
You Can Do That with Datasheets?
SQL Without Joins
Doing Two Things at Once
Case Study: Researching Data
Querying a Customer Survey
Query Queries
Give Me a Call
Putting Subqueries to Use
Consolidating Your Data With Queries
SubQueries to the Rescue
Query-Based Applications
Manage your Update Tables with Query Lists
Exploiting the Query Manager
Flexible normalization and denormalization: Case 2
Simplifying Complex SQL
Navigating Through Recursion, Part 1
Record Locking and Updating Efficiencies
Locking Code
Demystifying JOINs
Supporting Custom Sort Orders
Forms and Menus
Flexible Normalization and Denormalization of Data
Explorer Forms with a Single Keystroke
Closing All Open Forms
Tip: Closing All Forms
Breadcrumbs, or How I Learned to Love the Switchboard
Dynamic Menus
Conditional Formats on Access Forms
Eventful Formatting for Access Forms
Positioning a Record on a Form
Using Invisible Forms to Track Users
Expanding and Contracting Forms
Sub Forms
Control Your Subforms
Let Your Users Sort it Out
Zoom, Zoom, Zoom
Accessing Subforms
Using List Regions with Many-to-Many Relationships
Undo in Sub Forms
You Can Do That with Datasheets?
The Sub-SubForm Youve Always Wanted
From Zoom Box to Custom Dialog
Invisible Forms: Park Your Global Values Here
Out of Sync Cascading Combo Boxes and Subforms
Reporting
Making Your Access Reports Dynamic
Things about Reports that you probably dont know
Reports: Multiple Columns and Subreports
Creating a Great Report
Saving Reports is a Snap
Printing Pesky ZIP Codes and Set the Start Page Number
How to Pad Access Reports With Blank Rows
Getting in Line
Dynamic Grouping In Reports
Dot Leaders and Table Of Contents Reports
Outputting Flexible Data
User Interface Standards-Reports
MS Word & MS Excel
Excel Automation
Build Word 2003 Docs with XML
Four Ways to Merge to Word
What Access Developers Need to Know About Word
Outputting Flexible Data
Excellent Analysis
Creating Spreadsheets Without Excel
Extending Access Reports with Word and HTML
Use Excel to Analyze and Graph Access Data
Creating Histograms Using Access
Single Sourcing Your Help
Does This File Register with You
Getting Data From Access Into Excel
Outlook
Manipulating Outlook Data from Access
Consolidating Outlook Contact Data
The Jet 4.0 Exchange/Outlook IISAM
Send Data Without Attachments
Outlook Synchronizing and Internet Maps in the Access 2007 Contacts Template
Outlook Linked Tables and a Flutter On The Stock Market
Macros
AutoExec Macros
Performance
Access Database Performance
Is The Query Compiled?
Focus on Popular Objects to Speed up an Access 2007 Database
Access Answers
Access Efficiency
Working SQL: Efficient SQL
DAO
Everything About Using Parameters from Code
DAO verses ADO - DAO isn't Done Yet
Properties Without Fear
The PrivDBEngine Object
Embedded quotes in SQL statements
New Topics
Drop Box for MS Access
Outlook Linked Tables and a Flutter On The Stock Market
Setting Up Right Click Menus for Access 2007
Creating Charts/Graphs in an Access 2007 Database
Searching For Text Anywhere In A Database
The rest of the 400 articles
can be purchased here.
|
Editorials
All the Editorials have been classified here
Gold 2006 2005 2004 Silver 2003 2002 2001 2000 Bronze 1999 1998 1997 1996 Toolbox 2009 and the 2012 articles
Installation, Setup and Access User Interface
Remote Updates of a Back-End Database
Using the Access 2003 Database Window
Extracting Your Access Configuration
Click Savers
Packaging Access 2003 Solutions
SQL Server etc
Client-Server Utilities
Access Answers: Client/Server Issues
Client/Server Development with Access
Migrating Access (and Outlook Data) to SQL Server
Improving on VBA with Transact-SQL
One Huge Leap Toward SQL Server
!An Access Explorer for SQL Server Tables
Using Access to Prototype for SQL Server
Working with or without a DSN
Preparing To Upgrade Access Tables to SQL Server 2005/2008
Using Triggers
Exercising Options
Access Data Projects
Access 2002 Data Projects for Developers
Using Stored Procedures in ADPs
Moving ADP's Between Machines
Starting the Interface with Access Data Projects
Creating SQL Server Tables with Access Projects
Starting the Interface with Access Data Projects
Starting the Interface with Access Data Projects (part 2)
Making Changes in Access Data Projects
Protection and Security
Microsoft Access Passwords, Workgroups and ADO
Real-World Access Security
Dual Control
Encrypt Your Data
Restricting Who Can Use Your Database
Manually Changing Startup Options
Pivots and Charts
Create Dynamic Chart Applications
PivotTables in Access
Programming Pivot Tables for Access Forms
Analyze Your Data in Space
Creating Histograms Using Access
Graph to GIFs and Powerpoint
Easy as Pie
Managing Quality, Bugs and Errors
Playing Tag with Validation
Access Answers: But it Worked Yesterday!
Logging Access Startup Details and Version Control
Soundex: "Close" Only Counts in Horseshoes
Handling Misleading Report Errors
Making History
Error Trapping with a Code Builder
No More Write-only Code
List Boxes, Access Bugs, and More
Imports, Exports and XML
Exporting and Recovering Programming Objects
Access 2003 and XML
Put XML to Use in Access 2000+
Taking Outlook and XML to Task
Access to XML
Using FTP from Access Applications
Save Yourself Some Work
Data export made easy
Web Services for the Access Developer
Matching Data for Analysis
User Interface and Documentation
Access User Interface Design
Six Rules for Effective User Interface Design
Handling Visual Complexity
Navigation Through Recursion
The Form’s the Thing
Access Application Development Documentation
Everything Doesn't Happen at Once: Loosely Coupled Events
Implementing Proactive User Assistance
Getting More Out of Access 2003 Help
Improving Data Entry Feedback with Sound
Cuing Banners
Access Answers: Talk to Me
Access Interfaces: Handling Price Ranges
Single Sourcing Your Help
Reviews
FMS Total Visual Code Tools 2002
FMS Access Speller 2000+
FMS Total Access Analyzer 2000
Product Review: Access 2003 Conversion Toolkit
Access 2002/XP for Developers
Book Review: Grover Park George on Access
The Access Developer's Bookshelf
Access Answers about a variety of issues
Forms, Sorting Reports, and Dating Errors
Want Machine Information?
MP3 - Sounds Good to Me
Access Replication
SQL Discrepancies, List Boxes, and Dating
Say UNC, API Calls, {CAPSLOCK}, and Time
Bar Code Basics
These Are a Few of My Favorite Things
How to Convert Case and Calculate Total Time
Peter Comes to Bat
An Average Column: I Mean, What Mode is Your Median
Top Values, Hierarchical Lists, Equivalent Strings
Loosely Coupled Events COM+
Managing Cursors, Quotes, Subforms, and Missing Data
Windows Controls and Message Boxes
Making Your Applications Talk
I've Just Got to Get a Message to You
Treeview: Building Explorer-style Forms
Taming the Treeview Control
Displaying Hierarchical Data in a TreeView
File Open Dialog Options
Giving Your Access Form Controls Web-style Behaviors
ActiveX Controls and Forms
An Assortment of Windows API Tricks
Dates and Time
About Time
When DateAdd Doesn't
Date Tricks
Fuzzy Dates
Working All Day
Did Someone Say Holiday
Access Developer Needs a Date
Dates, Data Access, and Presentation
VBA
The Easy Approach to Code Reuse
Objects for the Database Developer
Using Dynamic External Event Procedures
Preventing Reference Failures
Two Functions You Don't Use Enough
Embedded quotes in SQL statements
“Just-In-Time” Queries
Handling Print Layout
More Dragging Around
Dealing with File Names
The FileSystemObject
Accessing Spatial Data, Part 1 Part 2 Part 3
Peter Comes to Bat - Handling Quotes, Weekdays
Keeping up Appearances
Hide Your Input, and it’s Pretty Common
User Preferences, Toggles, and Rocket Science
Choosing Directories: Harder Than It Sounds
System Tables, Mixing Versions
More Favorites
Track Your System File Versions
Access Answers: Shortcuts, Quotes, and What Have I Done?
Microsoft Access Forms—All Class
Shrink-Wrapped or Do-it-yourself Queries
Shuffling Lists of Numbers, Ranking, and Control-Level Validation
Cool Tricks for the Sophisticated Developer
Advanced Data Shaping
ADO
Preview - Active Data Objects
An ADO Tutorial: What is ADO?
An ADO Command Factory for Stored Procedures
Using the ADO Command Object
Using the ADO Objects Effectively
Advanced ADO Data Providers
Comparing DAO and ADO Recordsets
Persistent Recordsets in ADO
Accessing ADO
Advanced Data Shaping
ADO and Subform Performance
.Net and SharePoint and Tricky Stuff
Visual Basic .NET Development
Access 2003 and Windows SharePoint Services
Access: The .NET Report Writer
Managing Access from .Net
Building an Access Add-In with Dot Net
Select * From SharePoint Where db = ‘Access’
ADO.Net Revolution: Data Adapter
Service-Oriented Access
Web Service Wannabes_2
Accessing the Internet
Service-Oriented Access
|
