Modules and Classes MS Access Professionals File Archive

Name	Type	Uploaded By	Size	Created	Updated
AccessSecurity.zip Module Of Simplified Security Processes	zip	Bill Mosca	5.1 kB	4/16/2007	4/16/2007
ActiveDirectoryMemberList_excel.txt VBScript for getting list of users in an Active Directory Group. Change the extension from txt to vbs and double-click to launch it.	txt	Bill Mosca	8.6 kB	1/29/2010	2/7/2020
ActiveDirectoryUserList.txt Code for getting AD groups and users	txt	Bill Mosca	9.3 kB	5/16/2014	2/7/2020
bas_crystal_code_general_070609.zip The bas_crystal_code_general_070609 module has several basic functions and I have put lots of comments so that you can learn! Read it like a tutorial! This would be a handy module to import into any database.	zip	Bill Mosca	11 kB	8/23/2007	8/23/2007
bas_Crystal_DataDictionary_ReservedWords.zip How many times have you wanted a list of your table structures so that you can make your own reports? Or just document your database better? If you are like me, you check all your names to make sure they are not reserved words. I use Allen Browne's list, which now has > 2500 entries! Well, I decided to combine my program to create a data dictionary with a program to check for bad words and would like to share it with you. Needs a reference to a Microsoft DAO Object Library.	zip	Bill Mosca	3.6 kB	10/15/2007	10/15/2007
bas_crystal_Document_SQL_FormRpt_RecordSource_090703.zip Document Form and Report RecordSources, and Query SQL. Look at first 3 procedures in modules for quick launch. Import Module into Database. File, Import from VBE -- navigate to BAS file.	zip	crystal (strive4peace)	8.7 kB	7/3/2009	7/3/2009
bas_crystal_ReplaceSomething_090530.bas Useful to update objects when you change Fieldnames or Tablenames. Search queries, forms, and reports. Change WORD1 to WORD2 for: SQL, RecordSource, ControlSource, and RowSource. Count how many changes were made. Look at Debug window for report. VBE: File, Import --> navigate to BAS file. Also check V-Tools: DeepSearch (Links > Development Tools section) especially if you are replacing reserved words in SQL syntax such as Group.	bas	crystal (strive4peace)	9.4 kB	5/30/2009	5/30/2009
bas_crystal_SetDefaultTableDesignStuff.zip Here are 3 useful procedures that can improve performance in your database: SetSubDatasheetNone, SetDisplayControlTextbox, GetRidOfCaptionsTableDesign. More comments in the code.	zip	Bill Mosca	2.0 kB	8/28/2007	8/28/2007
bas_xl_Document_Queries_To_Excel_080628.zip VBA Module. Generates an Excel workbook with 4 sheets: (1) query name and SQL - if SQL is too many lines to show in cell, each statement is split to multiple cells (2) query name, date created and updated, type, updateable, # fields, #parameters (3) query name and field names (4) info from MSysQueries (thank you Clive) ... AutoFilter on each sheet so you can filter for a single query name (most common use). Can take a few minutes to run. NEEDS DAO Library. More Info: mssg# 62555	zip	crystal (strive4peace)	7.7 kB	6/28/2008	6/28/2008
bas_xl_Properties_080818_1213_.zip Properties Module with Custom Procedures. Includes Set_Property, Get_Property, Delete_Property, IsPropertyDefined. Limited Information about the Properties module is posted in Message #69601 -- 1. unzip 2. from VBE: File, Import --> navigate to BAS file	zip	crystal (strive4peace)	4.1 kB	2/1/2009	2/1/2009
bas_xl_Word_DocumentQuerySQL.zip VBA module. Outputs and formats SQL from Saved Queries to a Word table. Uses late binding to Word. Needs reference to DAO Library.	zip	crystal (strive4peace)	6.5 kB	6/30/2008	6/30/2008
basActiveDirectoryUserList.bas Active Directory User List. outputted to Excel or an email	bas	Bill Mosca	9.4 kB	6/1/2007	2/7/2020
basCommDlg.bas Common Dialgo API code for browsing Windows Explorer.	bas	Bill Mosca	4.4 kB	2/16/2007	2/7/2020
basCommDlg.txt Code for using Windows Common Dialog	txt	Bill Mosca	4.3 kB	9/23/2006	2/7/2020
basCompactUtility.zip Compacts a database. Must be run from another database.	zip	Bill Mosca	843 B	7/19/2009	7/19/2009
basDatabaseInfo.bas Functions to set and read database properties	bas	Bill Mosca	6.1 kB	8/10/2016	8/10/2016
basDriveInfo.zip Various routines to get drive information	zip	Bill Mosca	2.3 kB	6/24/2009	6/24/2009
basEmail.bas Send more than one attachment using Outlook automation.	bas	Bill Mosca	16 kB	5/4/2007	2/7/2020
basFormInstance.zip Shows how to open more than one instance of a form. Can be edited to do the same for reports.	zip	Bill Mosca	1.2 kB	8/14/2012	8/14/2012
basFormTemplate.bas Functions for setting various form and control properties for a uniform look.	bas	Bill Mosca	10 kB	10/11/2016	10/11/2016
					GoTo Top
basGetIPAddress.bas Get PC's IP Address using API call	bas	Bill Mosca	3.3 kB	8/16/2007	2/7/2020
basMapDirections.zip Code to get map and directions from google	zip	Bill Mosca	1.5 kB	6/23/2009	6/23/2009
basPrintPDF.bas Print PDF file by passing the file path to a function.	bas	Bill Mosca	5.2 kB	12/3/2007	2/7/2020
basScreenResolutionAdjust.bas Change screen resolution	bas	Bill Mosca	3.3 kB	9/12/2007	2/7/2020
basSecurity_wrkgrp_generic.bas Module containing functions for adding/editing users and their group memberships, change passwords and more.	bas	Bill Mosca	21 kB	11/20/2008	2/7/2020
basZip_Unzip.bas Zip or unzip files	bas	Bill Mosca	2.7 kB	8/14/2011	2/7/2020
clsUserInfo.cls VBA Class module written by Graham Seach (Access MVP) for getting User Infomation in Active Directory. Import into your VBA project. Example included at top of code page.	cls	Bill Mosca	32 kB	7/1/2011	2/7/2020
CurrencyToEnglish.txt Converts currency to words as you would use for writing checks.	txt	Bill Mosca	6.6 kB	11/5/2018	2/7/2020
Encrypt_Decrypt_usesKey.txt Encrypt/Decrypt a string using a key string for added security.	txt	Bill Mosca	2.8 kB	6/6/2016	2/7/2020
Outlook_SendEmail.txt Send email with multiple attachments using Outlook Redemption	txt	Bill Mosca	2.9 kB	7/26/2010	2/7/2020
StartupExample.zip Sample code to check and relink backend tables.	zip	Bill Mosca	14 kB	12/12/2015	12/12/2015