/Access-examples

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

Primary LanguageVisual BasicMIT LicenseMIT

Microsoft Access Examples

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

License: MIT current_build Office_2016 Latest Release Github commits (since latest release) GitHub issues

Table of Contents

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