MDE to MDB Conversion Service
ACCDE to ACCDB Conversion Service

IN THE SPOTLIGHT: MDE to MDB Conversion Service

(also supports: ACCDE to ACCDB, ADE to ADP, etc)

TELL ME MORE

Full restoration service (including source code) for MDE, ACCDE and ADE files

Access Database Repair Service

IN THE SPOTLIGHT: Access Database Repair Service

An in-depth repair service for corrupt Microsoft Access files

TELL ME MORE

Professional, friendly service for repairing corrupt Microsoft Access files (MDBs, ACCDBs, etc)

vbWatchdog

IN THE SPOTLIGHT: vbWatchdog

VBA error handling just got easier...

" vbWatchdog is off the chart. It solves a long standing problem of how to consolidate error handling into one global location and avoid repetitious code within applications. "

- Joe Anderson,
Microsoft Access MVP

Meet Shady, the vbWatchdog mascot watching over your VBA code →
(courtesy of Crystal Long, Microsoft Access MVP)

TELL ME MORE

vbWatchdog: A unique code library offering global error catching for your VBA & VB6 projects.

vbMAPI

IN THE SPOTLIGHT: vbMAPI

An Outlook / MAPI code library for VBA, .NET and C# projects

Get emails out to your customers reliably, and without hassle, every single time.

Use vbMAPI alongside Microsoft Outlook to add professional emailing capabilities to your projects.

TELL ME MORE

vbMAPI: An easy-to-use Outlook / MAPI code library for VBA, .NET and C# projects.

Code Protector

IN THE SPOTLIGHT: Code Protector

Standard compilation to MDE/ACCDE format is flawed and reversible.

TELL ME MORE

Protect your valuable intellectual property, by securing your MDE/ACCDE projects using Code Protector

twinBASIC

Looking to take your VBA skills further?...

Discover twinBASIC — a powerful new development platform that expands on VBA and VB6 with advanced features, modern tools, and enhanced compatibility. Perfect for those ready to elevate their projects or transition from VBA, twinBASIC lets you build on what you already know and take your applications to the next level!

Try out twinBASIC Community Edition - it's free!

Tutorials for Microsoft® Access


VBA / Modules [39 articles]
Extracting GPS data from JPEG files	06 Jul 2012	2000+
How to specify which version of Access to use for OLE automation	07 Mar 2012	2000+
Accessing detailed file information provided by the Operating System	03 Mar 2010	2000+
The differences between Nothing, Empty, Missing, Null, Zero and ZLS	18 May 2009	97+
Logging form/report usage (CODE)	18 May 2009	97+
Find As You Type (CODE)	17 May 2009	2000+
Using an Access 2007 (.accdb) back-end database in an Access 2000+ front-end application	26 Jun 2008	2000+
Scroll records with the mouse wheel in Access 2007	18 Jan 2008
Using VBA to insert characters at the cursor position	18 Jan 2008	95+
Code for Has the record been printed?	18 Jan 2008	95+
What is VBA?	17 Jan 2008	95+
DAO programming examples	23 Mar 2007	ALL VERSIONS
Easily copy an SQL statement from a query to VBA	23 Mar 2007	ALL VERSIONS
ADO programming examples	23 Mar 2007	2000+
ADOX programming examples	23 Mar 2007	2000+
List files recursively	30 Jun 2006	95+
ParseWord() - an alternative to Split()	30 Jun 2006	95+
FileExists() and FolderExists()	30 Jun 2006	95+
ClearList() and SelectAll()	30 Jun 2006	95+
Code for Build a search criteria form	30 Jun 2006	95+
Code for Relationship Report with extended field information	01 Feb 2006	97+
Bring an external application window to the foreground	03 Jun 2005	97+
Get all IP Addresses of your machine	18 May 2005	97+
VBA: Convert text to proper case (alternative to StrConv())	20 Apr 2005	v1, v2
Alternative to Nz for Access v1 / v2	20 Apr 2005	v1, v2
Copying a file in Access v2	20 Apr 2005	v2
Copying data to and from the Clipboard (Acc 95+)	20 Apr 2005	95+
Copying data to and from the Clipboard (Acc 1-2)	20 Apr 2005	v1, v2
Play a sound file in VBA	20 Apr 2005	ALL VERSIONS
Calculate a persons age given the DOB	20 Apr 2005	95+
MinOfList() and MaxOfList() functions	20 Apr 2005	97+
Code for Printer Selection Utility	20 Apr 2005	2000+
VBA Traps: Errors in Logic	20 Apr 2005	95+
VBA Traps: Working with Variables	20 Apr 2005	95+
VBA Traps: Working with Recordsets	20 Apr 2005	95+
Extended/Replacement DLookup()	20 Apr 2005	95+
Error Handling in Access Basic	20 Apr 2005	v2
Error Handling in VBA	20 Apr 2005	95+
Returning more than one value from a function	20 Apr 2005	ALL VERSIONS

Corruption [8 articles]
Steps to recover from Access database corruption	20 May 2009	v2+
List files to a table	05 Feb 2009	2000+
Code for Splash screen with version information	24 Feb 2008	97+
Bugs introduced in Access 2003 SP3	31 Jan 2008	2003
Preventing corruption	20 Apr 2005	v2+
Preventing corruption (old version)	20 Apr 2005	v2+
Recovering from corruption	20 Apr 2005	v2+
Access Database Corruption Repair Guide	13 Feb 2005	ALL VERSIONS

Security [9 articles]
Jet MDB security - under the hood	15 Feb 2009	ALL VERSIONS
Changing the encryption type in Access Part 2	04 Jun 2008
Changing the encryption type in Access 2007	28 May 2008
Access 97 'enabled' MDE databases are vulnerable!	25 Oct 2006	97+
How to make design changes to an Access MDE file	02 Oct 2006	97+
Protect the VBA source code in your MDE files	26 Jun 2006	97+
Outlook Send E-mail Without Security Warning	06 Sep 2005	97+
Field-level Permissions in Microsoft Access	30 Apr 2005	2000+
Enabling/Disabling controls based on User Security	20 Apr 2005	ALL VERSIONS

General [24 articles]
Access basics: free tutorial	18 Jan 2008	ALL VERSIONS
Rounding in Access	18 Jan 2008	95+
Prevent Access 2007 users from modifying existing databases	18 Jan 2008
What is Microsoft Access?	17 Jan 2008	ALL VERSIONS
The lowdown on Access 2007	23 Mar 2007	ALL VERSIONS
Problem names and reserved words	06 Sep 2006	ALL VERSIONS
Postal / Zip codes	06 Sep 2006	97+
Quotation marks within quotes	30 Jun 2006	95+
Database Issue Checker Utility	30 Jun 2006	2000+
Managing Access COM Add-Ins	17 Jan 2006	2000+
Common Errors with Null	20 Apr 2005	95+
Event Driven Programming	20 Apr 2005	ALL VERSIONS
Currency format does not reflect regional settings	20 Apr 2005	v2+
International Dates in Access	20 Apr 2005	v2+
Display system and version information	20 Apr 2005	2000+
Solving Problems with Library References (e.g. Date() fails)	20 Apr 2005	97+
Custom Database Properties	20 Apr 2005	v2+
Self Joins	20 Apr 2005	ALL VERSIONS
The DAO Object Model	20 Apr 2005	v2+
Split your MDB file into data and application	20 Apr 2005	ALL VERSIONS
Calculating Elapsed Time	20 Apr 2005	ALL VERSIONS
Nulls: Do I need them?	20 Apr 2005	95+
Mail Merge with Word for Windows	20 Apr 2005	v2
Undocumented SysCmd Functions	19 Apr 2005	97+

Forms [40 articles]
A new method for disabling the Mouse Scroll Wheel in Access forms	12 Aug 2009	97+
Lookup a value in a range	20 May 2009	95+
Extended DAvg(): EAvg()	20 May 2009	95+
Ranking or numbering records in forms/reports	20 May 2009	95+
Logging form/report opening	18 May 2009	97+
Highlighting search matches in Access 2007	18 May 2009	2003
Flagging required fields in forms	17 May 2009	97+
Where are macros used in my forms and reports?	29 Jan 2008	95+
Avoid #Error in form/report with no records	18 Jan 2008	v2+
Enter text in calculated controls	18 Jan 2008	95+
Parameter of type Text is evaluated wrongly	01 Dec 2006	97+
Find as you type - Part 2: How it works	06 Sep 2006	97+
Find as you type	06 Sep 2006	97+
Why does my form go completely blank?	05 Sep 2006	ALL VERSIONS
Build a search criteria form	30 Jun 2006	95+
Enter value as a percent	31 May 2005	95+
Listing Directory contents in a listbox / combo list	20 Apr 2005	ALL VERSIONS
Losing data when you close a form (bug)	20 Apr 2005	ALL VERSIONS
List Box of Available Reports	20 Apr 2005	95+
Combos with Tens of Thousands of Records	20 Apr 2005	95+
NotInList: Adding values to lookup tables	20 Apr 2005	95+
NotInList: Adding values to lookup tables (old version)	20 Apr 2005	95+
Using the NotInList event (combo)	20 Apr 2005	v2
Managing Combo Boxes	20 Apr 2005	v2+
Using a Combo Box to Locate Records	20 Apr 2005	97+
Popup Calendar	20 Apr 2005	97+
Managing Multiple Instances of a Form	20 Apr 2005	95+
Limiting text input length of an unbound text box	20 Apr 2005	95+
Filter a Form on a Field in a Subform	20 Apr 2005	95+
Return to the same record next time form is opened	20 Apr 2005	95+
Carry data over to new record	20 Apr 2005	95+
Carry data over to new record (old version)	20 Apr 2005	95+
Rolling dates by pressing "+" or "-"	20 Apr 2005	v2+
Editing Form and control properties at runtime	20 Apr 2005	95+
Print the record in the form	20 Apr 2005	ALL VERSIONS
Assigning Auto Keys for Aligning Controls	20 Apr 2005	ALL VERSIONS
Referring to controls on a subform	20 Apr 2005	ALL VERSIONS
'#Error' when a Subform has no records	01 Jan 1999	ALL VERSIONS
Referring to properties and controls from a form/report	01 Jan 1999	ALL VERSIONS
Referring to controls within a tabbed form	01 Jan 1999	ALL VERSIONS

Reports [15 articles]
Hide duplicates selectively	18 Jan 2008	v2+
Has the record been printed?	18 Jan 2008	95+
Bring the total from a subreport back onto the main report	30 Jun 2006	97+
Print a page with 3 evenly spaced mailing slips	20 Apr 2005	ALL VERSIONS
Check boxes in reports	20 Apr 2005	ALL VERSIONS
Use a multi-select list box to filter a report	20 Apr 2005	95+
Printing a Quantity of a Label	20 Apr 2005	ALL VERSIONS
Sorting records in a Report at runtime	20 Apr 2005	95+
Reports: Snaking Column Headers	20 Apr 2005	ALL VERSIONS
Reports: Create a blank line every fifth record	20 Apr 2005	v2+
Reports: Page Totals	20 Apr 2005	v2+
Numbering Entries in a Report or Form	20 Apr 2005	v2+
Limiting a Report to a Date Range	20 Apr 2005	ALL VERSIONS
Exporting Reports whilst retaining graphics	01 Jan 1999	ALL VERSIONS
Removing Min/Max/Close buttons from a Report's Preview Window	01 Jan 1999	ALL VERSIONS

Tables [26 articles]
Cascade to Null Relations	20 May 2009	2000+
Using the Currency field data type - without the hassle	28 Mar 2009	97+
Creating an Audit Trail (Source Code)	15 May 2008	97+
Starting Relationships - The Microsoft Access Way	17 Jan 2008	ALL VERSIONS
Validation Rules	23 Mar 2007	ALL VERSIONS
Truncation of Memo fields	05 Sep 2006	ALL VERSIONS
Archive: Move records to another table	05 Sep 2006	95+
DeleteAllRelationships()	05 Sep 2006	95+
Dump table details in VBA (DAO)	20 Apr 2005	95+
Undelete Options (records)	20 Apr 2005	ALL VERSIONS
Referential Integrity can't be that easy!	20 Apr 2005	ALL VERSIONS
Data Types in Access	20 Apr 2005	ALL VERSIONS
What, no record numbers?	20 Apr 2005	ALL VERSIONS
Finding duplicate records in a table	20 Apr 2005	ALL VERSIONS
Creating an Audit Trail	20 Apr 2005	95+
Field type names (JET, DDL, DAO and ADOX)	20 Apr 2005	2000+
Renaming fields and tracing dependencies	20 Apr 2005	2000+
Fixing AutoNumbers (AutoNumber bug in Jet 4.0)	20 Apr 2005	2000+
Set AutoNumbers to start from ...	20 Apr 2005	95+
Reconnect linked tables on Start-up	20 Apr 2005	v2+
Reducing OLE Linking Overhead	20 Apr 2005	v2+
Introduction to Hyperlink fields	20 Apr 2005	97+
Getting a value from a table: DLookup()	20 Apr 2005	ALL VERSIONS
Relationships between tables	20 Apr 2005	ALL VERSIONS
Undelete Tables and Queries in Access	18 Apr 2005	97+
Using AutoNumbers properly	01 Jan 1999	ALL VERSIONS

Samples [5 articles]
Google-Eye (Using the Web Browser ActiveX Control)	14 Jul 2005	97+
People in households and companies - modelling human relationships	20 Apr 2005	2000+
Printer Selection Utility	20 Apr 2005	2000+
Clashing Events/Appointments	20 Apr 2005	95+
Inventory Control: Quantity on Hand	01 Jan 1994	95+

Conversion [2 articles]
Converting from Access 97 to 2000, 2002 or 2003	20 Apr 2005	97+
Converting from Access 1 or 2 to Access 95 or 97	20 Apr 2005	v1, v2, 95, 97

Beginner Tips [3 articles]
Setting up Default Forms and Report templates	20 Apr 2005	ALL VERSIONS
What are these objects? (tables, queries, etc)	20 Apr 2005	ALL VERSIONS
What to do when a database won't open	01 Jan 1999	97

Queries [11 articles]
What is SQL?	17 Jan 2008	ALL VERSIONS
What's a subquery?	23 Mar 2007	ALL VERSIONS
Surviving Subqueries	23 Mar 2007	ALL VERSIONS
DDL query code examples	23 Mar 2007	97+
Crosstab query techniques	05 Sep 2006	ALL VERSIONS
Why can't I append some records?	30 Jun 2006	95+
Action queries: suppressing dialogs, while knowing results	30 Jun 2006	95+
Why is my query read-only?	30 Jun 2006	95+
Calculated fields being misinterpreted	20 Apr 2005	ALL VERSIONS
Calculated Fields	20 Apr 2005	ALL VERSIONS
The query lost my records!	20 Apr 2005	ALL VERSIONS

Bugs [21 articles]
Why I stopped using Yes/No fields	20 May 2009	ALL VERSIONS
Slow queries in Microsoft Vista	18 Jan 2008	97+
Grouping by Memo field yields garbage	01 Dec 2006	97+
Concatenated fields yield garbage in recordset	01 Dec 2006	97+
Outer join queries fail on Yes/No fields	01 Dec 2006	97+
Relationship Report with extended field information	01 Feb 2006	97+
DISTINCT query handles Nulls inconsistently	20 Dec 2005	ALL VERSIONS
Query NULL comparison gives wrong result (bug)	20 Apr 2005	ALL VERSIONS
Records missed by SELECT query (bug)	20 Apr 2005	2000+
Problem properties (bugs)	20 Apr 2005	2000+
Incorrect sorting with Decimal fields (bug)	20 Apr 2005	2000+
Incorrect displaying of data in forms (bugs)	20 Apr 2005	95+
Conditional formatting bug	20 Apr 2005	2000+
Writing the wrong record (Bookmark bug)	20 Apr 2005	97, 2000
Writing the wrong record (Bookmark bug, old version)	20 Apr 2005	97, 2000
Failures caused by Name Auto-Correct (bugs)	20 Apr 2005	2000+
Incorrect filtering in forms/reports (4 bugs)	20 Apr 2005	95+
Errors using multiple versions of Access under Vista/Windows 7	20 Apr 2005
Bug: Flickering tab controls in Access 2003	20 Apr 2005	2003
Access 97 'Error 3014 - Can't open any more tables.'	01 Jan 1999	97
Access 97 Bookmark Bug	07 Sep 1998	97

iTech Masters | VAT: GB202994606 | Terms | Sitemap | Newsletter