Access (Public)

ACCESS - Input Mask
You can use the InputMask property to make data entry easier and to control the values that users can enter in a text box control. Read/write String. Sy...
Tue, 13 Oct, 2020 at 12:56 PM
ACCESS-MkDir (Make A Windows Folder)
Private Sub Ticket_DblClick(Cancel As Integer)     'Opens newtwork folder specific to the MAM Ticket Number if there is one set up     Open_Specifi...
Wed, 13 Apr, 2022 at 2:56 PM
ACCESS - MsgBox
MsgBox Function https://support.microsoft.com/en-us/office/msgbox-function-e23511c8-4157-4e09-93a6-ba9f1749f4c0 https://www.automateexcel.com/vba/yes-no-...
Fri, 13 Nov, 2020 at 9:48 AM
ACCESS - QUERY (Union)
SELECT [Product ID], [Order Date], [Company Name], [Transaction], [Quantity] FROM [Product Orders] UNION SELECT [Product ID], [Creation Date], [Company Na...
Thu, 1 Jul, 2021 at 12:50 PM
ACCESS - Refresh - (Sub or Function Not Defined)
When using REFRESH in the VBA code with access you get the following error when debugging the code Compile error: Sub or Function not defined Us...
Wed, 1 Feb, 2017 at 11:33 AM
ACCESS - Resize (FORM FIELDS) Using VBA
How to dynamically resize Access (Form fields) https://www.youtube.com/watch?v=TC1QjUyOXi8 
Fri, 13 May, 2022 at 10:37 AM
ACCESS - Restrict ByPass Key
This will allow or disallow the SHIFT function on an Access Database Create a Module in Access and give it these details Password is win001 ########...
Tue, 22 Sep, 2020 at 3:38 PM
ACCESS - Report (Reference Sub Report)
To change a subreport visible control. This will either show or hide a sub report on the main report depending on the value set. Set variable as publ...
Wed, 30 Sep, 2020 at 1:57 PM
ACCESS - Subform Objects
Links https://docs.microsoft.com/en-us/office/vba/api/access.subform
Tue, 13 Oct, 2020 at 12:59 PM
ACCESS - Text Boxes
Text Boxes https://www.automateexcel.com/vba/yes-no-message-box/#VBA_Message_Box_Options Remove mini scroll bars Looks like mini scroll bars on the ri...
Thu, 26 Nov, 2020 at 7:55 AM