Menu Bar VBE

Prefix-Full	Prefix-Region	Prefix-Constant	Prefix-Type	Prefix-Example, Variable declaration	Variable Visibility
gkc_	g (global)	k (Constant)	c (String/Character)	(Module Declaration Section) Public Const gkc_DriveFrontEnd = "C"	Everywhere in PROJECT (ALL Modules/Procedures)
mkc_	m (module)	k (Constant)	c (String/Character)	(Module Declaration Section) Private Const mkc_ModuleName = "MOD_Constants"	Only in THIS MODULE
lkc_	l (local)	k (Constant)	c (String/Character)	(Procedure Declaration Section) Const lkc_ProcedureName = "Test"	Only in THIS PROCEDURE (Sub/Function)
lc_	l (local)	NONE (Not Constant)	c (String/Character)	(Procedure Declaration Section) Dim lc_MyVariable As String	Only in THIS PROCEDURE (Sub/Function)
c	NONE (local, function parameter)	NONE (Not Constant)	c (String/Character)	(Procedure Definition Section) Optional cDatabaseFullName As String	Only in THIS PROCEDURE (Function)

[edit]

Edit,Parameter Info

Wiki-link: [[Menu Bar VBE#Edit,Parameter Info|VBE_Menu,Parameter Info]]

[edit]

Edit,Complete Word

Wiki-link: [[Menu Bar VBE#Edit,Complete Word|VBE_Menu,Complete Word]]

Forum: Crash of Intelligence-Sense on 'adg', Office 2003

[edit]

Edit,Bookmarks

Wiki-link: [[Menu Bar VBE#Edit,Bookmarks|VBE_Menu,Bookmarks]]

[edit]

Edit,Bookmarks,Toggle Bookmark

Wiki-link: [[Menu Bar VBE#Edit,Bookmarks,Toggle Bookmark|VBE_Menu,Toggle Bookmark]]

[edit]

Edit,Bookmarks,Next Bookmark

Wiki-link: [[Menu Bar VBE#Edit,Bookmarks,Next Bookmark|VBE_Menu,Next Bookmark]]

[edit]

Edit,Bookmarks,Previous Bookmark

Wiki-link: [[Menu Bar VBE#Edit,Bookmarks,Previous Bookmark|VBE_Menu,Previous Bookmark]]

[edit]

Edit,Bookmarks,Clear All Bookmarks

Wiki-link: [[Menu Bar VBE#Edit,Bookmarks,Clear All Bookmarks|VBE_Menu,Clear All Bookmarks]]

[edit]

View

(Menu Bar) Top-?,File, Edit, >View<, Insert, Debug, Run, Tools, Libraries, Add-Ins, Window, Help, Bottom

Wiki-link: [[Menu Bar VBE#View|VBE_Menu,View]]

[edit]

View,Code

Wiki-link: [[Menu Bar VBE#View,Code|VBE_Menu,Code]]

[edit]

View,Object

Wiki-link: [[Menu Bar VBE#View,Object|VBE_Menu,Object]]

[edit]

View,Definition

Wiki-link: [[Menu Bar VBE#View,Definition|VBE_Menu,Definition]]

[edit]

View,Last Position

Wiki-link: [[Menu Bar VBE#View,Last Position|VBE_Menu,Last Position]]

[edit]

View,Object Browser

Wiki-link: [[Menu Bar VBE#View,Object Browser|VBE_Menu,Object Browser]]

KeyBoard-ShortCut: PRESS F2
For HELP Select Unknown-Item/Keyword and PRESS F1
To Add NEW Project/Library VBE_Menu,References...

[edit]

View,Immediate Window

Wiki-link: [[Menu Bar VBE#View,Immediate Window|VBE_Menu,Immediate Window]]

FMS Inc., Error Handling,Debugging Views

Examples:

CODE

? (5*20)/3
33.3333333333333
? msgbox("Continue ?",vbYesNo+vbDefaultButton1+vbQuestion,"Ask the User..")
6
? inputbox("Your Age ?","Ask the User..",50)
10
msgbox "Switch me OFF and go out !",vbInformation,"Say to User.."
? Now,Date, WeekdayName( Weekday ( Date ))
24/04/2010 02:27:07 PM 24/04/2010 Saturday

[edit]

View,Locals Window

Wiki-link: [[Menu Bar VBE#View,Locals Window|VBE_Menu,Locals Window]]

[edit]

View,Watch Window

Wiki-link: [[Menu Bar VBE#View,Watch Window|VBE_Menu,Watch Window]]

[edit]

View,Call Stack...

Wiki-link: [[Menu Bar VBE#View,Call Stack...|VBE_Menu,Call Stack...]]

Error Codes-Out of Stack Space

[edit]

View,Project Explorer

Wiki-link: [[Menu Bar VBE#View,Project Explorer|VBE_Menu,Project Explorer]]

[edit]

View,Properties Window

Wiki-link: [[Menu Bar VBE#View,Properties Window|VBE_Menu,Properties Window]]

[edit]

View,Toolbox

Wiki-link: [[Menu Bar VBE#View,Toolbox|VBE_Menu,Toolbox]]

[edit]

View,Toolbars

Wiki-link: [[Menu Bar VBE#View,Toolbars|VBE_Menu,Toolbars]]

Toolbars

[edit]

View,Toolbars,Debug

Wiki-link: [[Menu Bar VBE#View,Toolbars,Debug|VBE_Menu,Debug]]

[edit]

View,Toolbars,Edit

Wiki-link: [[Menu Bar VBE#View,Toolbars,Edit|VBE_Menu,Edit]]

Forum: Code Block Comment/UN-Comment..?, Forum: Missing PLUS-SIGN..?

[edit]

View,Toolbars,Standard

Wiki-link: [[Menu Bar VBE#View,Toolbars,Standard|VBE_Menu,Standard]]

[edit]

View,Toolbars,UserForm

Wiki-link: [[Menu Bar VBE#View,Toolbars,UserForm|VBE_Menu,UserForm]]

[edit]

View,Toolbars,MZ-Tools 3.0

Wiki-link: [[Menu Bar VBE#View,Toolbars,MZ-Tools 3.0|VBE_Menu,MZ-Tools 3.0]]

mztools (Add Line numbers,..) freeware

[edit]

View,Toolbars,Customize...

Wiki-link: [[Menu Bar VBE#View,Toolbars,Customize...|VBE_Menu,Customize...]]

[edit]

View,Microsoft Access

Wiki-link: [[Menu Bar VBE#View,Microsoft Access|VBE_Menu,Microsoft Access]]

[edit]

Insert

(Menu Bar) Top-?,File, Edit, View, >Insert<, Debug, Run, Tools, Libraries, Add-Ins, Window, Help, Bottom

Wiki-link: [[Menu Bar VBE#Insert|VBE_Menu,Insert]]

[edit]

Insert,Procedure...

Wiki-link: [[Menu Bar VBE#Insert,Procedure...|VBE_Menu,Procedure...]]

[edit]

Insert,Module

Wiki-link: [[Menu Bar VBE#Insert,Module|VBE_Menu,Module]]

Debugging-How to START/RUN my First Code ?
DO NOT WRITE CODE, use code in Extern / Your Libraries ..VBE_Menu,References...
Before Edit switch to VBE_Menu,Design Mode
Naming Conventions for my Variables,.. in MY CODE
- Variable Local / Module / Global, How to build right Name..
Module Name
- Save Module as: Module_Prefix + Module_Description
- Module_Prefix = MOD_ , BAS_ ,..
- Example Module Name: MOD_Constants
Module Constants
- GLOBAL, Prefix g (gkc_DriveFrontEnd, GLOBAL Constant, Visible everywhere in PROJECT/ALL MODULES)
- MODULES, Prefix m (mkc_ModuleName, MODULE Constant, Visible only in THIS MODULE)
- LOCAL, Prefix l (lkc_ProcedureName, LOCAL Constant, Visible only in THIS PROCEDURE/SUB)
Option Explicit, Error Codes-Variable not defined
IS-IsStringEqualTo

CODE

Option Compare Database
Option Explicit

'GLOBAL Constant, Visible everywhere in Project
Public Const gkc_DriveFrontEnd = "C"

'LOCAL Constant, Visible only in THIS MODULE
Private Const mkc_ModuleName = "MOD_Constants"
'-------------------------------------
Public Sub Test()
On Error GoTo LBL_xPAC_ERR

'LOCAL Constant, Visible only in THIS PROCEDURE/SUB
Const lkc_ProcedureName = "Test"

LBL_xPAC_END:
Exit Sub
LBL_xPAC_ERR:
MsgBox "Err: " & Err & "," & Err.Description, vbCritical, lkc_ProcedureName
Resume LBL_xPAC_END
Resume Next
Resume
End Sub

If you want switch code lines to ON/OFF use Conditional Compilation - Compiler Directives

CODE

Option Compare Database
Option Explicit
#Const mflg_UseADO = True ' conditional compiler constant for THIS MODULE
#Const mflg_DebugMode = True ' conditional compiler constant for THIS MODULE
Public Sub Test_ADO_DAO()
#If mflg_UseADO Then
'ADO code here.....If mflg_UseADO = True
#Else
'DAO code here.....If mflg_UseADO = False
#End If
#If mflg_DebugMode Then
' DEBUG-code here.....If mflg_DebugMode = True
#End If
End Sub

[edit]

Insert,Class Module

Wiki-link: [[Menu Bar VBE#Insert,Class Module|VBE_Menu,Class Module]]

[edit]

Insert,File...

Wiki-link: [[Menu Bar VBE#Insert,File...|VBE_Menu,File...]]

[edit]

Debug

(Menu Bar) Top-?,File, Edit, View, Insert, >Debug<, Run, Tools, Libraries, Add-Ins, Window, Help, Bottom

Wiki-link: [[Menu Bar VBE#Debug|VBE_Menu,Debug]]

Debugging
FMS Inc., Error Handling,Debugging Views

[edit]

Debug,Compile Your_Database_Name

Wiki-link: [[Menu Bar VBE#Debug,Compile Your_Database_Name|VBE_Menu,Compile Your_Database_Name]]

[edit]

Debug,Step Into

Wiki-link: [[Menu Bar VBE#Debug,Step Into|VBE_Menu,Step Into]]

[edit]

Debug,Step Over

Wiki-link: [[Menu Bar VBE#Debug,Step Over|VBE_Menu,Step Over]]

[edit]

Debug,Step Out

Wiki-link: [[Menu Bar VBE#Debug,Step Out|VBE_Menu,Step Out]]

[edit]

Debug,Run To Cursor

Wiki-link: [[Menu Bar VBE#Debug,Run To Cursor|VBE_Menu,Run To Cursor]]

[edit]

Debug,Add Watch...

Wiki-link: [[Menu Bar VBE#Debug,Add Watch...|VBE_Menu,Add Watch...]]

[edit]

Debug,Edit Watch...

Wiki-link: [[Menu Bar VBE#Debug,Edit Watch...|VBE_Menu,Edit Watch...]]

[edit]

Debug,Quick Watch...

Wiki-link: [[Menu Bar VBE#Debug,Quick Watch...|VBE_Menu,Quick Watch...]]

[edit]

Debug,Toggle Breakpoint

Wiki-link: [[Menu Bar VBE#Debug,Toggle Breakpoint|VBE_Menu,Toggle Breakpoint]]

[edit]

Debug,Clear All Breakpoints

Wiki-link: [[Menu Bar VBE#Debug,Clear All Breakpoints|VBE_Menu,Clear All Breakpoints]]

[edit]

Debug,Set Next Statement

Wiki-link: [[Menu Bar VBE#Debug,Set Next Statement|VBE_Menu,Set Next Statement]]

[edit]

Debug,Show Next Statement

Wiki-link: [[Menu Bar VBE#Debug,Show Next Statement|VBE_Menu,Show Next Statement]]

[edit]

Run

(Menu Bar) Top-?,File, Edit, View, Insert, Debug, >Run<, Tools, Libraries, Add-Ins, Window, Help, Bottom

Wiki-link: [[Menu Bar VBE#Run|VBE_Menu,Run]]

For Macro-Code STOP (For-Ever-Loop), press CTRL+BREAK to pause execution of Visual Basic code ( Microsoft Access Help (F1), Answer wizard=AllowBreakIntoCode ), DO NOT KILL your Application with Task Manager !
If something goes Wrong Error Codes

[edit]

Run,Macro/Continue

Wiki-link: [[Menu Bar VBE#Run,Continue|VBE_Menu,Macro/Continue]]

[edit]

Run,Break

Wiki-link: [[Menu Bar VBE#Run,Break|VBE_Menu,Break]]

Error Codes-Unknown Jet Error

[edit]

Run,Reset

Wiki-link: [[Menu Bar VBE#Run,Reset|VBE_Menu,Reset]]

[edit]

Run,Design Mode

Wiki-link: [[Menu Bar VBE#Run,Design Mode|VBE_Menu,Design Mode]]

Crash-What to do-Code EDIT

[edit]

Tools

(Menu Bar) Top-?,File, Edit, View, Insert, Debug, Run, >Tools<, Libraries, Add-Ins, Window, Help, Bottom

Wiki-link: [[Menu Bar VBE#Tools|VBE_Menu,Tools]]

[edit]

Tools,References...

Wiki-link: [[Menu Bar VBE#Tools,References...|VBE_Menu,References...]]

DO NOT WRITE CODE, use code with References to Libraries.. or MY-Libraries..
Verifying References on Startup, References
- MISSING after CheckBox, means Library NOT FOUND (renamed,deleted,corrupt,..)/BROKEN !
- Verify Ac_Menu,Security... for trusted location..
- If you still need to use the reference, clear the check box entry for MISSING: {referencename} in the Available references list, and then create a new reference to the file using the Browse... button.
- You can use the Regsvr32 tool(Regsvr32.exe) to register and unregister OLE controls such as DLL or ActiveX Controls (OCX) files that are self-registerable (Ac_Menu,ActiveX Controls...)
Rebuild-Database-References
use Late binding(without References, for Advanced Users) instead of Early binding (with References, Image Down, for Beginners).
To View Project/Library Contents VBE_Menu,Object Browser

Use CODE-LIBRARY from external / internal (Your Databases) resources, Click on Browse..

In VBE_Menu,Immediate Window, Print out References..

CODE

for i=1 to references.Count: Debug.print i & "," & references(i).FullPath: next i

Be EXACTLY in your Dim statements: (Error Codes-Unexpected Type Mismatch)

CODE

Dim rs1 As ADODB.Recordset ' Library ADODB...........OK
Dim rs2 As DAO.Recordset ' Library DAO................OK
'rs3 Type=(ADODB/DAO)?, It depends on Library Higher Priority in References
Dim rs3 As Recordset ' Library (ADODB/DAO) ? ............NOT OK

Call/Run External Procedure (Your_DatabaseFunctionName) in Your_Project_Name in Your_Database_Path\Your_DatabaseName
- Set Project_Name in VBE_Menu,Your_Database_Name Properties...
- References.AddFromFile "Your_Database_Path\Your_DatabaseName"
  - Adds Reference with Name=Project_Name to Your_DatabaseName

CODE

' Example Call
? Run("Your_Project_Name.Your_DatabaseFunctionName","Optional, Your Argument-1,..")
Run "Your_Project_Name.Your_DatabaseFunctionName","Optional, Your Argument-1,.."
Run "db2.MyFunc" ' call from db1.MDB

[edit]

Libraries

(Menu Bar) Top.?, File, Edit, View, Insert, Debug, Run, Tools, >Libraries<, Add-Ins, Window, Help, Bottom

[edit]

Library VBA

Default/BuiltIn Library VBA, Visual Basic For Applications, VBE6.DLL, VBE_Menu,About Microsoft Visual Basic...
- Shell (Run EXE)
- Library VBA-Constant-Prefix= vb (Error Codes-Variable not defined)

[edit]

Library Access

Default/BuiltIn Library Access, Microsoft Access 11.0 Object Library, MSACC.OLB
- Library Access-Constant-Prefix= ac (Error Codes-Variable not defined)
- SysCmd

[edit]

Library DAO

Wiki-link: [[Menu Bar VBE#Library DAO|VBE_Menu,References...Library DAO]]

Library DAO, Microsoft DAO 3.6 Object Library, dao360.dll, Links-ADO, Choosing between DAO and ADO
- Class DAO.Recordset
- Library DAO-Constant-Prefix= db (Error Codes-Variable not defined)

[edit]

Library ADODB

Wiki-link: [[Menu Bar VBE#Library ADODB|VBE_Menu,References...Library ADODB]]

Library ADODB (ADO), Microsoft ActiveX Data Objects 2.5 Library, msado25.tlb, Choosing between DAO and ADO
- Class ADODB.Recordset
- Library ADODB-Constant-Prefix= ad (Error Codes-Variable not defined: adSchemaViews)

[edit]

Library ADOX

Library ADOX (ADO), Microsoft ADO Ext. 2.8 for DDL and Security, msadox.dll, Choosing between DAO and ADO
- Class Catalog, Table (Column, Index, Key), View, Procedure, User, Group
- Library ADOX-Constant-Prefix= ad (Error Codes-Variable not defined)

[edit]

Library Scripting

Wiki-link: [[Menu Bar VBE#Library Scripting|VBE_Menu,References...Library Scripting]]

Library Scripting, Microsoft Scripting Runtime, scrrun.dll
- Class TextStream (File-ReadLine,..), Dictionary, Drive, FileSystemObject, Folder (Copy, Move, Delete..),..(VBE_Menu,Object Browser)
- Library Scripting-Constant-Prefix= {NONE} (Error Codes-Variable not defined)

[edit]

Library Office

Library Office, Microsoft Office 11.0 Object Library, MSO.DLL
- Library Office-Constant-Prefix= mso (Error Codes-Variable not defined)

[edit]

Library Excel

Library Excel, Microsoft Excel 11.0 Object Library, EXCEL.EXE
- Library Excel-Constant-Prefix= xl (Error Codes-Variable not defined)
- ExcelConvertColumnNameFromNumberToLetter (704->AAB), ExcelConvertColumnNameFromLetterToNumber (AAB->704)
- IS-Sys_WIN_IsAppExcelRunning ?

[edit]

Library JRO

Library JRO, Microsoft Jet and Replication Objects 2.6 Library, msjro.dll
- Class JRO.JetEngine
- Library JRO-Constant-Prefix= jr (Error Codes-Variable not defined)

[edit]

Library VBIDE

Library VBIDE, VBProject (Visual Basic Editor), Microsoft Visual Basic for Applications Extensibility, VBE6EXT.OLB
- Library VBIDE-Constant-Prefix= vbext (Error Codes-Variable not defined)

[edit]

Library MSForms

Library MSForms,Microsoft Forms 2.0 Object Library (Excel.UserForms), C:\WINDOWS\system32\FM20.DLL
- Library MSForms-Constant-Prefix= fm (Error Codes-Variable not defined)

[edit]

Library MSComctlLib

Library MSComctlLib, Microsoft Windows Common Controls 6.0 (SP6),C:\WINDOWS\system32\MSCOMCTL.OCX
- Class TreeView, Treeview Sample With Drag And Drop

[edit]

Library Shell32

Library Shell32, Microsoft Shell Controls And Automation, C:\WINDOWS\system32\SHELL32.dll
- Library Shell32-Constant-Prefix= {NONE} (Error Codes-Variable not defined)
- Class Shell

[edit]

Library IWshRuntimeLibrary

Library IWshRuntimeLibrary, Windows Script Host Object Model, C:\WINDOWS\system32\wshom.oc
- Library IWshRuntimeLibrary-Constant-Prefix= {NONE} (Error Codes-Variable not defined)
- Class DRIVE_CONNECT

[edit]

Library OLXLib

Library OLXLib, Microsoft Office Outlook View Control, C:\PROGRA~1\MICROS~2\OFFICE11\OUTLCTL.DLL
- Class Outlook Calendar
- Ac_Menu,ActiveX Controls...

CODE

Private Sub Form_Load()
Me![ViewCtl0].Folder = "Calendar"
Me![ViewCtl0].View = "Day/Week/Month"
End Sub

[edit]

Library API

For APILibraries you DO NOT need add References
- Library Links-API (Application Programming Interface)-Constant-Prefix= {miscellaneous} (Error Codes-Variable not defined)

[edit]

Library Your_Project_Name

Wiki-link: [[Menu Bar VBE#Library Your_Project_Name|VBE_Menu,References...Library Your_Project_Name]]

Library Your_Project_Name, Your Library, Your_DatabaseName.MDB or Your_DatabaseName.MDE
- Library Your_Project_Name-Constant-Prefix = gk (Error Codes-Variable not defined)
Library Databases-How to..

[edit]

Tools,Macros...

Wiki-link: [[Menu Bar VBE#Tools,Macros...|VBE_Menu,Macros...]]

[edit]

Tools,Options...

Wiki-link: [[Menu Bar VBE#Tools,Options...|VBE_Menu,Options...]]

Crash-What to do-Compile on Demand
Startup-Set Options (Database environment) from Visual Basic
Automatically check Variable Declaration in your code Option Explicit, Error Codes-Variable not defined
Editor Format (Code Colors)

[edit]

Tools,Your_Database_Name Properties...

Wiki-link: [[Menu Bar VBE#Tools,Your_Database_Name Properties...|VBE_Menu,Your_Database_Name Properties...]]

Set Project Name
- For Hidden Project, starts ProjectName with Underscore:
  - _MyHiddenProjectName (VBE_Menu,Object Browser , Show Hidden Members)
Lock Project

[edit]

Add-Ins

(Menu Bar) Top-?,File, Edit, View, Insert, Debug, Run, Tools, Libraries, >Add-Ins<, Window, Help, Bottom

Wiki-link: [[Menu Bar VBE#Add-Ins|VBE_Menu,Add-Ins]]

[edit]

Add-Ins,Add-In Manager...

Wiki-link: [[Menu Bar VBE#Add-Ins,Add-In Manager...|VBE_Menu,Add-In Manager...]]

mztools (Add Line numbers,..), Developers: VTools AddIns freeware

[edit]

Window

(Menu Bar) Top-?,File, Edit, View, Insert, Debug, Run, Tools, Libraries, Add-Ins, >Window<, Help, Bottom

Wiki-link: [[Menu Bar VBE#Window|VBE_Menu,Window]]

Ac_Menu,Window
In VBE_Menu,Immediate Window type:

CODE

DoCmd.Echo True ' (Default) Screen/Window is repainted
DoCmd.Echo False ' **Frozen** Screen/Window, Screen is **NOT** repainted
DoCmd.Hourglass True ' Screen/Window mouse pointer: hourglass icon
Screen.MousePointer = 11 ' Screen/Window mouse pointer: hourglass icon
DoCmd.Hourglass False ' Screen/Window mouse pointer: normal

[edit]