Make your own free website on Tripod.com
The Access Web

Acknowledgements


A big "Thank you" and a very small token of appreciation to all those who share their wealth of information via the various articles or downloadable samples.   Without your help,  I would never have succeeded in getting the website to this point.  I hope you will continue your support in the future.

This page took a long time in coming up, and now that it has, I will keep it updated.  This is a very short list of the various contributions the contributors have generously made since the inception of this website.  Short list because I can't put down in words all that I have learned from them. This is just a sample of what they gave me or were a part of.

Should I have overlooked someone or something, I'd appreciate it if you could let me know.

Barnes, Pete

     Email the contributor
Adding a Search form to a database

Baron, Andy

Visit the contributor's website     Email the contributor
Detect new record in a form
Too few parameters, expected n
Bookmark Bug
Use a recordset as report's datasource
Maximum length strings crash Access Security Wizard

Bedward, Michael

Email the contributor

Display a dialog box for a specified duration

Best, Trevor

Visit the contributor's website     Email the contributor

Domain Aggregate Functions Replacements
Run Dos Batch files from Access

Brittel, Thomas M.

Email the contributor

Boxes with variable dimensions

Generic Name Structures in Access

date_97.zip

Seg_97.zip

Brooks, James H

Email the contributor
Printing First and Last Page Numbers for Report Groups
Changing the Background Color of the Current Record in a Continuous Form

Browne, Allen

Visit the contributor's website     Email the contributor
Detect new record in a form

Calinoiu, Nicole

Move and Resize form windows from code

Chipman, Mary

Visit the contributor's website     Email the contributor
Access 2000 ADPs- Memo field corruption

Chouteau, Marc

Visit the contributor's website     Email the contributor

ProgressBar sample

Splitter sample

Christopher, Larry

Track IntelliMouse's wheel

Corbin, Ray

Calendar.zip

Couch, Norris

Email the contributor
Duplicate VBA code in Perl using OLE

Dybenko, Alex

Visit the contributor's website     Email the contributor
Printout Multiple copies of a report
Use Variables in SQL behind forms

Fairfield, Lyle

Visit the contributor's website     Email the contributor
Relink tables from different datasources
Adding a Search form to a database
Determining the number of dimensions for an array

Foster, Joe

Visit the contributor's website     Email the contributor
Convert Currency ($500) into words (Five Hundred Dollars)
Create a query that returns Random records
Return Dates in US #mm/dd/yyyy# format
Handling floating-point, Currency, and Decimal Datatype in SQL

Getz, Ken

Visit the contributor's website     Email the contributor
Call Windows File Open/Save Dialog box
Save a report's output as a PDF file
Simplify action queries in code
VBA Developer's Handbook - Replacement for functions in Chapter 12
Scheduler Utility

Goudoever, Paul van

Email the contributor
Reading a Drive's Volume Label
To Hide or Not To Hide

Gotlieb, André

Email the contributor
LineNumbers.zip

Hansen, Lars M

Visit the contributor's website     Email the contributor
Connect your database to the web

Hardwick, Keri

Email the contributor
#Error when the Subform has no records
Error 3014 - Can't Open Any More Tables
Refer to Controls on a tabbed form

Refer to Form and Subform properties and controls
Save a report's output as a PDF file
Use Autonumbers properly
Bookmark Bug
Database Won't Open
Lines-Graphics not retained in Word-RTF Export
Removing Min-Max-Close buttons from a report's Preview Window

Heenan, Lambert

Email the contributor
Replacement for Sendkeys

Holovacs, Jay

Email the contributor
Names with Mixed cases

Jorgensen, Steve

Don't let the Synonym "bug" bite!
Count the Number of Groups on a Report

Kaplan, Michael

Visit the contributor's website     Email the contributor
Access minimizes to Windows 95/NT toolbar instead of closing
Solving Access 97 IPFs with /Decompile
TSI Synchronizer
Maximum length strings crash Access Security Wizard
Jet 4.0 Replication
Automation object doesn't close automatically
Specify UserName & Password for new Access instance
Access 2000: Formatting MsgBox's with '@'
To Hide or Not To Hide
Opening another database in the same instance
Why CompactCurrentDatabase doesn't work from code
TSI Xpression 9.0
TSI Form-Report to Data Access Page Wizard
What was that password again?
Access 2000- Using DAO code in ADPs

Karman, Hans

 Email the contributor
Synchronization without Replication

Karre, Anthony S.

Creating DSNs from code

Kaskel, Matthias

Email the contributor
Displaying IP Addresses by using an Input mask

Kreft, Terry

Visit the contributor's website     Email the contributor
Calculate differences in time
Call Windows Browse for Folder Dialog box

Class Builder Wizard
Create/return a unique temp file
Daylight Savings Time & PreciseDateDiff
Disable Close button on maximized form

Forms Format Wizard
Get Local Drives and UNC Path of network drives
Get path and file name of Current database
Handle reports from a modal form
Have Access pause until Shelled process has finished
Importing Excel spreadsheets from code
Manipulate Access Window
Numlock key keeps turning off

PrivDBEngine and Startup Properties
Read a Value from Registry

References Wizard
VB5 Switchboard Utility
Calc.zip
Bookmark Bug
Put an image in Access window
Convert an Access 97 database to Access 95 format
Code Comment Builder Wizard
Access 97 Compactor MDB
Class Information Wizard
Common Functions like CurrentDB, str$, Mid$ fail to work
Internet Data Transfer Library
Scheduler Utility
Adding a Search form to a database
Displaying a custom Mouse icon
Subclassing form for SysTray functionality
Copy variables/control contents to memory
Backup Wizard
WebBrowser control- Run-Time error '438'
File Search and Properties Object
Removing Min-Max-Close buttons from a report's Preview Window
Bits and Bitmasks

Labowitz, Gary

Email the contributor

Maintain a history of changes

Lascae, Radu

Email the contributor

Custom Zoom in Reports

Lebans, Stephen

Visit the contributor's website     Email the contributor

Rotate Text
Rotate Label ActiveX Control
Determining Combobox's Dropped state

Linson, Larry

Email the contributor

Displaying photos in a form

Looney, Jason

Email the contributor

Make Numeric and Date fields respond to Plus or Minus keys

Lunde, Jim

Email the contributor
Check if an object exists in the database

Mandeno, Graham

Email the contributor
Preventing multiple instances of a database

Marshall, Albert

Email the contributor
TableLister.zip 

Moseley, Lewis

Email the contributor
Various Date manipulation functions

Meyer, Arvin

Visit the contributor's website     Email the contributor
Handle Null values in fields
CodeWriter 2.0
Adding a Search form to a database
Access 2000: Formatting MsgBox's with '@'

Oberdalhoff, Klaus

Email the contributor
Suppress the "Loading Image" dialog
knowhw30.zip
usepic.zip
obdwinwd.zip

Pascoe, Timothy J.

Email the contributor
Relink tables from different datasources

Probst, Klaus

Email the contributor
Put a custom icon in the form's caption bar

Revilla, Ernesto

Email the contributor
expreval.zip
splash.zip

Riordan, Rebecca

Visit the contributor's website     Email the contributor
Sub-classing Entities

Songne, Lloyd

Email the contributor
Hyperlink with "mailto:" tag opens two windows

Stoddard-Stones, Robin

Email the contributor
Bill Of Materials
How to handle midnight in calculations
Time, adding and subtracting time and timesheets
Determining Average Time

Stiphout, Tom van

Email the contributor
Maximum length strings crash Access Security Wizard

Streeter, Alden

 Email the contributor
Replace a character with another within one string
Access 2000- Using Group by along with NZ results in unreadable characters

Taylor, Douglas J.

Email the contributor
The Access Web MDB

Tessier, Pierre

Email the contributor
GridReport.zip

Walsh, Michel (Vanderghast)

 Email the contributor
Calculate Age of a person
Daylight Savings Time & PreciseDateDiff
How to perform Seek on Linked Tables
How many Sundays between two dates
Finding all X having all required Y
The Access Web (French Translation)
Spelling number, in many languages (PolyGlot Number Speller)
Fixed column name and crosstabs
Use Variables in SQL behind forms
Continuous sequence, maximum length (stroke)
Quartiles, Percentiles
Getting a related field from a GroupBy (total) query
Merging sequences
Jet-MSDE- DELETE * FROM Table1; Incorrect syntax near '*'

Walters, Tim

Email the contributor
Calculate Age of a person

Wickenden, Terry

Visit the contributor's website     Email the contributor
Conquer RunCommand Constants
Move cursor to the end of text in a textbox

Wilson, Graeme

Email the contributor
Email/Export Charts from Access

Wutka, Drew

Email the contributor
Mini Calendar

Yoxall, Erika

Visit the contributor's website     Email the contributor
Fill Fields automatically on form based on a control's value
Find Unmatched records between two tables
Have a query return every nth record in a table
Have query return highest/lowest value in a field
Solving problems with Dates in SQL