Microsoft Access Examples

Various examples of VBA, queries, macros, forms, reports and ribbon XML in an Microsoft Access database file

Table of Contents

• References
• Command Line Options
• Object Listing Reference

References

Link	Type
Microsoft Access Find & Replace Add-in	Software
Microsoft Access Merge & Diff	Software
O'Reilly Access Database Design & Programming, 3rd Edition	Book

Command Line Options

OPTION	DESCRIPTION
/decompile	Undocumented command line. Will sometimes remove old code and objects from the database and make it faster.
/excl	Opens the specified Access database for exclusive access. To open the database for shared access in a multiuser environment, omit this option. Applies to Access databases only.
/ro	Opens the specified Access database or Access project for read-only access.
/user user name	Starts Access by using the specified user name. Applies to Access databases only.
/pwd password	Starts Access by using the specified password. Applies to Access databases only.
/profile user profile	Starts Access by using the options in the specified user profile instead of the standard Windows Registry settings created when you installed Microsoft Access. This replaces the /ini option used in versions of Microsoft Access prior to Access 97 to specif
/compact target database or target Access project	Compacts and repairs the Access database, or compacts the Access project that was specified before the /compact option, and then closes Access. If you omit a target file name following the /compact option, the file is compacted to the original name and fo
/repair	Repairs the Access database that was specified before the /repair option, and then closes Microsoft Access. In Microsoft Access 2000 or later, compact and repair functionality is combined under /compact. The /repair option is supported for backward compat
/convert target database	Converts a previous-version Access database or Access project to the default file format, renames the new file, and then closes Access. You must specify the source database before you use the /convert option. To view the default file format, click Options
/x macro	Starts Access and runs the specified macro. Another way to run a macro when you open a database is to use an AutoExec macro.
/cmd	Specifies that what follows on the command line is the value that will be returned by the Command function. This option must be the last option on the command line. You can use a semicolon (;) as an alternative to /cmd. Use this option to specify a comma
/nostartup	Starts Access without displaying the task pane (the second dialog box that you see when you start Access).
/wrkgrp workgroup information file	Starts Access by using the specified workgroup information file. Applies to Access databases only. C:\Program Files\Access 2K Runtime\Office\MSACCESS.EXE P:\general\Database\Facilities_Management_System\v_11_1\FMS.mde /user username /pwd /wrkgrp P:\gene
/runtime	Starts Access in runtime mode for testing. C:\Program Files\Office\MSACCESS.EXE C:\Database\database.mde /runtime

Object Listing Reference

Type	Nbr	Name	Description	Items
Form (-32768)
	1	001_About_frm	A description of the Microsoft Access Database.
	2	002_Splash_Screen_frm	A splash screen with the company logo and the application information.
	3	003_Buttons_frm	Command Button example with code
	4	004_DSN_Password_frm	A form to login to a DSN database connection
	5	005_Access_Security_frm	Allow the user to login, change password, edit permission; where granted, and view list of current users.
	6	006_Dialogbox_Examples_frm	Dialog box examples
	7	010_Date_Calendar_frm	Uses the calendar dll from Microsoft (only needed previous to 2007)
	8	301_Roulette_frm	Roulette game
	9	700_Create_Filelist_frm	Recursive code to go through complete folder structure and catalog a file list
	10	800_Link_Manager_frm	Manage the links from server objects
	11	900_Check_Runtime_frm	Check performance of queries and reports
	12	950_Leszynski_Conventions_frm	Leszynski Naming Conventions for Microsoft Solution Developers
	13	980_Data_Dictionary_frm	A form that documents the columns, column descriptions, and the rest of the attributes of each table within the database whether the table is a Access or Server based.
Macro (-32766)
	1	AutoKeys	Hot Key designation
	2	Ribbon	Access 2007-2016 Ribbon example
Report (-32764)
	1	001_Organization_Logo_srp	Primary company logo.
	2	099_Object_Listing_Report_rpt	A listing of all the objects within the database
	3	803_Object_Calendar_List_rpt	A calendar style report
	4	803a_Calendar_List_srp	A sub-report to 803_Object_Calendar_List_rpt
	5	804_Weekly_Report_rpt	A 52 week style report
	6	805_Timeline_Report_rpt	A MS Project like time line report example
	7	950_Leszynski_Conventions_rpt	Leszynski Naming Conventions for Microsoft Solution Developers
	8	980_Data_Dictionary_rpt	A data dictionary listing of all the tables in this database
Module (-32761)
	1	clsMonthCal	Calendar Class	CreateDTPControl ReDraw MultiSelect MaxSelectRangeofDays CalendarYOffset MonthRows MonthColumns WindowLocation PositionAtCursor CursorXinit CursorX CursorY FontSize FontName ShowWeekNumbers NoTodayCircle NoToday hwnd hWndForm hWndCal OneClick SelectedDate SetSelectedDateRange StartSelectedDate EndSelectedDate GetSelectedDates SetViewableMonths SetBoldDayState Class_Initialize Class_Terminate GetProperty SetProperty IsCalendar
	2	modCalendar	Calendar Functions	ShowMonthCalendar WindowProc GetFuncPtr SetSelectedDate SetMonths sClick ShowWeekNums sShowToday sShowcircleToday sWindowPosition UpdateCursor LocationCursorOnCalendar ReleaseClass LoWord MakeDWord
	3	modDate	Date functions	Timedelay DaysInMonth Age DaysInMonthMS DaysInMonth2 EndOfMonth EndOfWeek FormatInterval LastBusDay LeapYear2 NextDay NextDay1 Num2Date PriorDay PriorDay1 StartOfMonth StartOfWeek String2Date WorkDays
	4	modFileFunctions	Contains procedures that check and refresh the links to Northwind tables.	RefreshLinks GetDirectory FindFile ReturnAllFiles RecursiveDir TrailingSlash MSA_CreateFilterString MSA_ConvertFilterString MSA_GetSaveFileName MSA_SimpleGetSaveFileName MSA_GetOpenFileName MSA_SimpleGetOpenFileName OF_to_MSAOF MSAOF_to_OF
	5	modMain	Subroutines that run objects and procedures in the database	OSUserID ErrorMsg GetObjectDescription GetObjectTypeName
	6	modMathAreaVolume	Area and Volume	ACircle ARect ARing ASphere ASquare ASquare2 ATrap ATriangle2 RectDiag SquareDiag VCone VCylinder VPipe VPyramid VTruncPyramid
	7	modMathCumulative	Cumulative Value	CumulativeValue DeCumulativeValue
	8	modMathStatistics	Statistics	Combin Factorial FactorialR Permut Regress TestRegress
	9	modMathTrig	Trigonometry	ArcCos Arccosec Arccotan ArcSec ArcSin ATan2 Cotan Deg2Rad HArccos HArccosec HArcsec HArcsin HArctan HCos HCosec HSec HSin HTan pi Rad2Deg Sec
	10	modMathXYZ	Latitude/Longitude	DegToDMS DegToDMSStr DMSStrToDeg DMSToDeg GreatArcDistance LatLongToXYZ testxyz XYZToLatLong
	11	modOutlook	Microsoft Outlook Functions	ImportContactsFromOutlook ImportCalendarFromOutlook PushAppointments
	12	modString	String Manipulation/Parsing	LowerCC ParseCSZ ParseName Proper ProperEx ProperWord StrToHex TestParseName UpperCC CountCSVWords CountWords CutFirstWord CutLastWord ReplaceStr GetCSVWord GetWord Like2 LPad ParseItemsToArray RPad ParseArticle
Access Table (1)
	1	CMD_LINE_TB	Command line options for Access
	2	CUM_VAL_TB	Used to test the function in modMathCumulative
	3	DATABASE_STRUCTURE_TB	Used to store the database table structure
	4	DECUM_VAL_TB	Used to test the function in modMathCumulative
	5	ROULETTE_TB	Numbers for roulette
	6	TAG_GRP_TB	Leszynski Naming Conventions for Microsoft Solution Developers
	7	TAG_NME_TB	Leszynski Naming Conventions for Microsoft Solution Developers
	8	tblContacts	Used with the Microsoft Outlook Functions
	9	tblDefaults	Used to store defaults used in the this database
	10	tblFileList	Used to store a list of files
	11	USysRibbons	Microsoft Access Ribbon XML example
Query (5)
	1	101_Object_List_qry	Creates a list of all objects in the MS Access database (Needs module modMain)
	2	200_Create_DATABASE_STRUCTURE_TB_qry	Used to create the MS Access table using DDL
	3	201_Create_DATABASE_STRUCTURE_TB_qry	Used to create the MS Access table using DDL
	4	202_Add_Constraint_pk001_Primary_Key_PROP_ID_qry	Used to add a constraint to a MS Access table using DDL
	5	203_Add_Column_LST_MDFD_ID_qry	Used to add a new column to a MS Access table using DDL
	6	204_Alter_Column_LST_MDFD_ID_qry	Used to alter a column in a MS Access table using DDL
	7	205_Drop_DATABASE_STRUCTURE_TB_qry	Used to drop a MS Access table using DDL
	8	720_Cumulative_Value_qry	Used to test the function in modMathCumulative
	9	721_Decumulative_Value_qry	Used to test the function in modMathCumulative
	10	803_Calendar_Style_Listing_qry	Used in the report 803_Object_Calendar_List_rpt
	11	803a_Calendar_List_qry	Used in the sub-report 803a_Calendar_List_srp
	12	804_Weekly_Report_qry	Used in the report 804_Weekly_Report
	13	940_Date_Format_qry	Examples of formating date & time
	14	950_Leszynski_Conventions_qry	Leszynski Naming Conventions for Microsoft Solution Developers
	15	SQL_Server_Function_Login_Name_qry	SQL Server pass-through query
	16	SQL_Server_View_Date_Time_qry	SQL Server pass-through query