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 |
|