|
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 |
 |
|
 |
Adding a Search form to a database |
|
Baron, Andy |
|
|
|
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 |
|
|
|
Display
a dialog box for a specified duration |
|
Best, Trevor |
|
|
|
Domain Aggregate Functions Replacements |
|
Run Dos Batch files from Access |
|
Brittel, Thomas M. |
|
|
|
Boxes with variable dimensions |
|
Generic Name Structures in Access |
|
date_97.zip |
|
Seg_97.zip |
|
Brooks, James H |
|
|
|
Printing First and Last
Page Numbers for Report Groups |
|
Changing
the Background Color of the Current Record in a Continuous Form |
|
Browne, Allen |
|
|
|
Detect new record in a form |
|
|
|
Move
and Resize form windows from code |
|
Chipman, Mary |
|
|
|
Access 2000 ADPs- Memo field corruption |
|
Chouteau, Marc |
|
|
|
ProgressBar sample |
|
Splitter sample |
|
|
|
Track IntelliMouse's wheel |
|
|
|
Calendar.zip |
|
Couch, Norris |
|
|
|
Duplicate VBA code in
Perl using OLE |
|
Dybenko, Alex |
|
|
|
Printout Multiple copies
of a report |
|
Use Variables in SQL
behind forms |
|
Fairfield, Lyle |
|
|
|
Relink tables from different datasources |
|
Adding a Search form to a database |
|
Determining the number of dimensions for an array |
|
Foster, Joe |
|
|
|
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 |
|
|
|
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 |
|
|
|
Reading a Drive's Volume
Label |
|
To Hide or Not To Hide |
|
Gotlieb, André |
|
|
|
LineNumbers.zip |
|
Hansen, Lars M |
|
|
|
Connect your
database to the web |
|
Hardwick, Keri |
|
|
|
#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 |
|
|
|
Replacement
for Sendkeys |
|
Holovacs, Jay |
|
|
|
Names
with Mixed cases |
|
|
|
Don't let the Synonym "bug" bite! |
|
Count the Number of Groups on a Report |
|
Kaplan, Michael |
|
|
|
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 |
|
|
|
Synchronization
without Replication |
|
|
|
Creating
DSNs from code |
|
Kaskel, Matthias |
|
|
|
Displaying IP Addresses by using an Input mask |
|
Kreft, Terry |
|
|
|
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 |
|
|
|
Maintain a history
of changes |
|
Lascae, Radu |
|
|
|
Custom
Zoom in Reports |
|
Lebans, Stephen |
|
|
|
Rotate Text |
|
Rotate Label ActiveX Control |
|
Determining Combobox's Dropped state |
|
Linson, Larry |
|
|
|
Displaying
photos in a form |
|
Looney, Jason |
|
|
|
Make Numeric and Date fields respond to Plus or Minus keys |
|
Lunde, Jim |
|
|
|
Check if an object
exists in the database |
|
Mandeno, Graham |
|
|
|
Preventing
multiple instances of a database |
|
Marshall, Albert |
|
|
|
TableLister.zip |
|
Moseley, Lewis |
|
|
|
Various Date
manipulation functions |
|
Meyer, Arvin |
|
|
|
Handle Null values in
fields |
|
CodeWriter
2.0 |
|
Adding a Search form to a database |
|
Access 2000: Formatting MsgBox's with '@' |
|
Oberdalhoff, Klaus |
|
|
|
Suppress
the "Loading Image" dialog |
|
knowhw30.zip |
|
usepic.zip |
|
obdwinwd.zip |
|
Pascoe, Timothy J. |
|
|
|
Relink tables from
different datasources |
|
Probst, Klaus |
|
|
|
Put
a custom icon in the form's caption bar |
|
Revilla, Ernesto |
|
|
|
expreval.zip |
|
splash.zip |
|
Riordan, Rebecca |
|
|
|
Sub-classing
Entities |
|
Songne, Lloyd |
|
|
|
Hyperlink with "mailto:" tag opens two windows |
|
Stoddard-Stones, Robin |
|
|
|
Bill Of Materials |
|
How
to handle midnight in calculations |
|
Time,
adding and subtracting time and timesheets |
|
Determining
Average Time |
|
Stiphout, Tom van |
|
|
|
Maximum
length strings crash Access Security Wizard |
|
Streeter, Alden |
|
|
|
Replace a character with
another within one string |
|
Access 2000- Using Group by along with NZ results in unreadable characters |
|
Taylor, Douglas J. |
|
|
|
The Access Web MDB |
|
Tessier, Pierre |
|
|
|
GridReport.zip |
|
Walsh, Michel (Vanderghast) |
|
|
|
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 |
|
|
|
Calculate
Age of a person |
|
Wickenden, Terry |
|
|
|
Conquer RunCommand
Constants |
|
Move cursor to the end
of text in a textbox |
|
Wilson, Graeme |
|
|
|
Email/Export
Charts from Access |
|
Wutka, Drew |
|
|
|
Mini Calendar |
|
Yoxall, Erika |
|
|
|
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 |
