Access-vba
access-vba
#accessvba
Table of Contents
About
1
Chapter 1: Getting started with access-vba
2
Remarks
2
Examples
2
Installation or Setup
2
Chapter 2: Access Error Codes (Form.Error, DataErr)
3
Remarks
3
Examples
196
Form.Error
196
Trap All Errors
197
Catching and handling errors in user code
197
Chapter 3: Check if Table Exists in Current DB
199
Remarks
199
Examples
199
Example
199
A somewhat simpler function that can be used in one line
199
Chapter 4: Create Text Delimited File in Access Vba
200
Introduction
200
Remarks
200
Examples
200
Example:
200
Chapter 5: Enable/Disable Shift Key on DB Open
202
Remarks
202
Examples
202
Disable Shift Function Code
202
Enable Shift Function Code
203
Credits
205
About
You can share this PDF with anyone you feel could benefit from it, downloaded the latest version from: access-vba
It is an unofficial and free access-vba ebook created for educational purposes. All the content is extracted from Stack Overflow Documentation, which is written by many hardworking individuals at Stack Overflow. It is neither affiliated with Stack Overflow nor official access-vba.
The content is released under Creative Commons BY-SA, and the list of contributors to each chapter are provided in the credits section at the end of this book. Images may be copyright of their respective owners unless otherwise specified. All trademarks and registered trademarks are the property of their respective company owners.
Use the content presented in this book at your own risk; it is not guaranteed to be correct nor accurate, please send your feedback and corrections to info@
1
Chapter 1: Getting started with access-vba
Remarks
This section provides an overview of what access-vba is, and why a developer might want to use it. It should also mention any large subjects within access-vba, and link out to the related topics. Since the Documentation for access-vba is new, you may need to create initial versions of those related topics.
Examples
Installation or Setup
Detailed instructions on getting access-vba set up or installed. Read Getting started with access-vba online:
2
Chapter 2: Access Error Codes (Form.Error, DataErr)
Remarks
The most tricky part is finding description for error codes. This site has a most complete list of codes I've found so far.
Below you can find a copy cleaned of "@@@"s.
Error Number
Error Description
3
Return without GoSub
5
Invalid procedure call or argument
6
Overflow
7
Out of memory
9
Subscript out of range
10
This array is fixed or temporarily locked
11
Division by zero
13
Type mismatch
14
Out of string space
16
Expression too complex
17
Can't perform requested operation
18
User interrupt occurred
20
Resume without error
28
Out of stack space
35
Sub or Function not defined
47
Too many DLL application clients
48
Error in loading DLL
49
Bad DLL calling convention
3
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.