Various examples of VBA, queries, macros, forms, reports and ribbon XML in an Microsoft Access database file
| Link | Type |
|---|---|
| Microsoft Access Find & Replace Add-in | Software |
| Microsoft Access Merge & Diff | Software |
| O'Reilly Access Database Design & Programming, 3rd Edition | Book |
| 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 |
| 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 |