|
|
|
|
Query Add-in for Autonumber and Running Sum Queries XP VERSION | 30-Sep-2004 | John Hawkins |
| At last the XP version of the sites most popular download |
|
Reading Properties of Databases Objects in VBA Code | 29-Jul-2004 | John Hawkins |
| This example shows a simple function that reads the description of a specified query. |
|
Lotus Notes (version 6) appointment from VB or VBA | 30-May-2004 | Joe Korzeniewski |
| How to create a lotus notes version 6 appointment from a VB or VBA application |
|
Access Database Project - User Management Example | 30-May-2004 | Joe Korzeniewski |
| Joe's first in a series of articles on creating and using Access Database Project files with SQL server. This article show some great functions for managing user logons in the database. |
|
Calculating the Weighted Median of a Recordset | 29-Apr-2004 | John Hawkins |
| A module which will calculate the weighted median of a recordset field |
|
Multiple sorted reports from one report | 29-Jun-2003 | John Hawkins |
| Annoyed at producing several reports with exactly the same contents but different sort orders. Heres how to let users choose the sort field and order |
|
Normalizing Data and Flat Files - How To | 28-Jun-2003 | John Hawkins |
| So you understand normalization, have decided on the tables but have no idea how to convert the 20000 row excel spreadsheet youve been given |
|
How to Join Cells in Excel | 25-Jun-2003 | Chris Shepherd |
| An often asked and very simple solution to join two text cells together in excel |
|
Vlookup using multiple keys | 25-Jun-2003 | Chris Shepherd |
| How to extend the powerful vlookup function in excel to use multiple keys |
|
Quick ODBC Install | 21-Jun-2003 | John Hawkins |
| How to install ODBC settings quickly and easily from within the database |
|
Calendar Style Data Entry Form | 8-Mar-2003 | John Hawkins |
| A brilliant full example of how to build a form that looks like a calendar for any specified month and can many entreis for each day that the user can edit. All the code is there for you. |
|
Form Colour Changer | 8-Mar-2003 | John Hawkins |
| A little utility form that allows you to automatically change all you forms in your database to the same colour. |
|
Custom Combo Boxes | 8-Mar-2003 | John Hawkins |
| How to build combo boxes that are based on other combo boxes on the same form. |
|
Printing Multiple Reports from a Form | 8-Mar-2003 | John Hawkins |
| How to give users a list box containing all the reports and print off multiple selected reports. |
|
Fill a combo box with a reports list | 8-Mar-2003 | John Hawkins |
| How to automatically fill a combo box with all the report names in your database |
|
Inserting Special Characters in a form | 8-Mar-2003 | John Hawkins |
| Ever had a need to insert weird characters not on the keyboard quickly in a form. |
|
(Recordset flattening) getting relational data back into a flat format | 11-Nov-2001 | Chris Shepherd |
| A great example by Chris for turning data back into flat files for presentation purposes. |
|
Create an outlook appointment from access | 12-Oct-2001 | John Hawkins |
| Simple bit of code to allow you to create appointments in your outlook calendar directly from access code. |
|
Bypass startup macros | 12-Oct-2001 | John Hawkins |
| Locked your database down and removed startup options??? |
|
Calculating the Percentile of a Recordset | 12-Oct-2001 | John Hawkins |
| How to calculate the Percentile of a recordset |
|
Converting a number to its Spoken Word Value | 12-Oct-2001 | John Hawkins |
| An example database that contains a module with a function to convert numbers to words |
|
More flexible criteria prompt boxes | 11-Sep-2001 | John Hawkins |
| Example showing a way to let users put greater than and less than symbols in a prompt box |
|
Adding an extra row to a prepopulated combo box | 11-Sep-2001 | John Hawkins |
| How to add an extra item to a prepopulated combobox. This is a great sql trick saving on coding to add an extra line or lines to a combo box that looks us its values in a query or table. |
|
Getting Multiple Parameters from a Single [Prompt] Box | 18-Aug-2001 | John Hawkins |
| This shows how to use just one Parameter box with multiple entries and parse them using a supplied function |
|
Animated Open Close Form | 17-Jun-2001 | Jason Collins |
| An example of how to have animated opening and closing forms that shrink and expand when opened and closed. |
|
Deleting Duplicate Records Leaving Just the First | 21-Mar-2001 | John Hawkins |
| Have to get rid of duplicates in a huge table and want to know how to leave just one of each record using just queries and no code. This is it. |
|
Accessing user defined fields in an Outlook message | 21-Oct-2000 | John Hawkins |
| Getting the information out of an outlook message or custom form isn't difficult, but its not documented. So heres how. |
|
Setting a reference to an Exchange Public Folder | 21-Oct-2000 | John Hawkins |
| How to get straight to a public folder in outlook vba without going through 15 levels of folders. |
|
Odd and even margins | 18-Oct-2000 | John Hawkins |
| How to have different size margins depending on whether it's an odd or even page. |
|
Filter a Report based on List Box | 18-Oct-2000 | John Hawkins |
| How to filter a report based on choices made in a list box |
|
Convert Reports to Microsoft Word then Email Via Outlook | 18-Oct-2000 | John Hawkins |
| This sample is quite complex but show a task that very often is asked for. Save a bunch of reports to Word format and then email them. |
|
PageSize Changer | 18-Oct-2000 | John Hawkins |
| This form will change all the reports in your database to a specified page size format. Either A4 or Letter. |
|
Colouring Alternate Records in Access Reports | 18-Oct-2000 | John Hawkins |
| This example shows how to colour individual records different colours in an access report. Uses an example database and shows a step by step guie |
|
ODBC Add-in from Chris | 12-Oct-2000 | Chris Shepherd |
| ODBC add-in that makes ODBC connections just a little easier to managed from the database |
|
How to get the filenames of your Personal Folder (pst) files | 30-Jul-2000 | John Hawkins |
| Ever needed to retrieve the names of your outlook personal folders. Not easy but this bit of code strips them straight out of the registry for you. |
|
Weighted Average Function | 21-Mar-2000 | Chris Shepherd |
| A replacement for the lack of a weighted average function in excel. Great for Lotus convertees. |
|
How to move to a different cell once a cell has been modified | 21-Mar-2000 | Chris Shepherd |
| Very clever piece of code from our Excel Guru Chris showing you how to decide the cell order in Excel Worksheets |
|
Splitting Upper and Lower Case text in a Query | 21-Mar-2000 | John Hawkins |
| This is how to separate similar strings with different cases giving you case sensitive queries. |
|
Creating no matching record queries | 18-Mar-2000 | John Hawkins |
| This shows you how to create an IS NULL query. Otherwise know as NOT IN query. |
|
Setting a worksheet name in code | 17-Mar-2000 | Chris Shepherd |
| How to rename a worksheet you've just created in code. |
|
Normalizing Data and Flat Files | 9-Mar-2000 | John Hawkins |
| One of the most important aspects of access is normalization. All explained here for the beginner. Learn this before even thinking about building your tables. |
|
Dates and Times. How to calculate with dates. | 9-Mar-2000 | John Hawkins |
| Dates and Times. How to calculate with dates. |
|
Database Launcher | 9-Mar-2000 | John Hawkins |
| DB Launcher Updated with a few bug fixes and most importantly with the new auto backup engine. Back up your database while in use. |
|
Useful Functions and Sub Procedures | 9-Mar-2000 | Chris Shepherd |
| This database has a load of usefull functions and subs written by Chris Shepherd. If we get enough response I may be able to get him to keep updating it |
|
Calculating the Difference Between Two Dates | 9-Mar-2000 | John Hawkins |
| Tells you all about the datediff function and how to calculate someone's age |
|
Re-linking tables in an Access Database | 9-Mar-2000 | John Hawkins |
| VBA A little bit of code to automatically re-link tables to a new database. All you have to do is tell the code where the new database is |
|
Database Backup Utility | 9-Mar-2000 | John Hawkins |
| Little VB app that runs on its own and backs up access databases whilst in use. |
|
Access Bulk Object Copier | 9-Mar-2000 | John Hawkins |
| This program will allow you to copy all objects from one database to another. It's great if you want to export all your objects from a replicated database. Will recreate relationships and indexes. |
|
Text Edit | 9-Mar-2000 | John Hawkins |
| A replacement for NotePad. It allows multiple documents and views, find function and browser pane. It will remember the last opened documents as well. Will open documents of any size (tested to 2GB), and will open all documents as text. |
|
Lotus Notes mail from VB or VBA | 9-Mar-2000 | John Hawkins |
| How to create a lotus notes mail from a VB or VBA application |
|
Lotus Notes appointment from VB or VBA | 9-Mar-2000 | John Hawkins |
| How to create a lotus notes appointment from a VB or VBA application |
|
Returning the next top x number of records in a Query | 27-Feb-2000 | John Hawkins |
| This shows how to return the top x number of records in a query and then how to return the next top x number of records. |
|
The Trouble with Access (6) Who's in that database | 26-Feb-2000 | Chris Shepherd |
| It's 3am and after a heavy night of coding you want to update the database but someone is still in it. Find out who. |
|
The Trouble with Access (5) Renaming Stuff | 25-Feb-2000 | Chris Shepherd |
| So your naming convention isn't up to scratch and you need to change stuff. Been there done that…so save yourself the hassle. |
|
The Trouble with Access (4) Access 2000 and 97 at the same time!! | 24-Feb-2000 | Chris Shepherd |
| Chris gives insight into the way access 2000 and 97 can get into the same database and the do's and don'ts |
|
The Trouble with Access (3) Runtime error '2185' | 23-Feb-2000 | Chris Shepherd |
| Why do we have to move to a control to set it's value. That’s just not VB |
|
The Trouble with Access (2) DoCMD what where they thinking?? | 22-Feb-2000 | Chris Shepherd |
| Why oh why did microsoft decide to use a dodgy macro system to service a vb application. Chris sticks the boot in. |
|
The Trouble with Access (1) The Resize Event | 21-Feb-2000 | Chris Shepherd |
| Chris kicks us off with the problem with maximised forms |
|
Borrow Spell Check facility from Word | 21-Feb-2000 | John Hawkins |
| Want to word correct what a user just typed in. This example borrows Microsoft Words spell check facility to check a string. |
|
Running Totals or autonumbers in a query | 21-Feb-2000 | John Hawkins |
| This is how to get a running total or autonumber in a query using aliases and without Domain functions |
|
Top Five One Line Code Statements | 21-Feb-2000 | John Hawkins |
| This shows you my five favourite one line code statements |
|
Reading Outlook E-Mails from Access | 21-Feb-2000 | John Hawkins |
| A module to scan through your inbox and process certain emails |
|
Create a search form to search a text type field | 20-Feb-2000 | John Hawkins |
| This shows how to create a search form that will enable users to enter a string of words and then return search results (including number of hits) to the user |
|
Count, Sum, Average and Lookup Fields or Records | 20-Feb-2000 | John Hawkins |
| A beginners guide to the Domain functions (Dcount, DSum, Davg and DLookUp). |
|
Calculating the Median of a Recordset | 20-Feb-2000 | John Hawkins |
| A module which will calculate the median of a recordset field |
|
Dialing with a modem or Data and the Comm ports | 20-Feb-2000 | John Hawkins |
| All the code you need to dial from access straight to the modem. Very simple but can be axpanded if you know what you are doing. |
|
Lookup Tables (LUT) | 20-Feb-2000 | John Hawkins |
| What is a lookup table and why do I need to use one?. Find out here |
|
Many to Many Relationships | 20-Feb-2000 | John Hawkins |
| Another tough topic to get your head round explained in very easy terms. |
|
Pictures of Fabalou | 18-Feb-2000 | John Hawkins |
| Pictures of Fabalou |
|
Book Reviews | 15-Feb-2000 | John Hawkins |
| Book Reviews |
|
Finding All Those Data Entry Typos | 12-Feb-2000 | John Hawkins |
| Fully built form that will help you find common typo errors in fields where 1 character is wrong. |
|
A Genealogy Example Database | 12-Feb-2000 | John Hawkins |
| A Genealogy Example Database |
|
Importing messages from Outlook to your Database | 12-Feb-2000 | John Hawkins |
| Nice bit of code to run through your inbox and import emails into Access tables |
|
Creating Union Queries in Access | 12-Feb-2000 | John Hawkins |
| This step by step example shows you how to use a union query to get data from two or more tables into one query. |
|
Conversion Functions Explained | 12-Feb-2000 | John Hawkins |
| How to convert from various types to various other types |
|
File Open Dialog Boxes Without Using Common Dialog Controls | 12-Feb-2000 | Chris Shepherd |
| How to create file open dialog boxes without using common dialog controls. |
|
Object Exporter for Access 97 | 12-Feb-2000 | John Hawkins |
| VBA . If you've replicated a database and don't have a copy of the original ,or have made significant changes, this bit of code will get the objects out of the database for you. Now includes all objects for export, including relationships. Can also be used to move large numbers of objects to another database. VB Program in VB section. |
|
Using Excel Functions in Queries | 8-Feb-2000 | John Hawkins |
| This is how to get all those useful excel functions either in your code or more importantly in your query |
|
Viewing External Pictures on a form | 8-Feb-2000 | John Hawkins |
| Embedding pictures inside a database is never a good thing to do. This code shows you how to use a stored filename and display that filename picture on the form. |
|
Parsing FormMail CGI Emails into Access Tables | 3-Feb-2000 | John Hawkins |
| FormMail CGI script is a common script use to send emails from a web server. This little solution shows how to scrip those emails into the database automatically. |
|
Outlook References | 3-Feb-2000 | John Hawkins |
| Change the outlook reference based on what the user has installed |
|
Relation Database Design Example | 3-Feb-2000 | John Hawkins |
| Written for beginners this example explains the most important function of databases and that is relational data. |
|
Splash Screen at Startup | 3-Feb-2000 | John Hawkins |
| How to display your own logo when Microsoft Access starts up |
|
Query Add-in for Autonumber and Running Sum Queries | 3-Feb-2000 | John Hawkins |
| This add-in works just like the built in Microsoft Access Query Wizards creating Autonumber and running sum queries |
|
Checking if Customers Have Ordered this Week Month Year | 3-Feb-2000 | John Hawkins |
| This shows how to see if a customer has placed an order in during their normal order period. |
|
Multiple Combo Boxes as Criteria for A Query | 3-Feb-2000 | John Hawkins |
| This shows how to use multiple combo boxes as criteria for a query without the user having to make entries in all the boxes. |
|