Access (Public)
VBA Colours If Side = "MS" Then Me.Detail.BackColor = vbMagenta 'Changes to PINK ' In the example above, If a form field called sid...
Wed, 13 Apr, 2022 at 3:49 PM
When recompiling a database or migrating a database you get the following error:
Compile Error - User-defined type not defined, (see screen shot bel...
Thu, 15 Oct, 2020 at 3:07 PM
As an example these are set for report:- RED = LESS than 30 Days from today YELLOW = BETWEEN 30 & 90 Days from today GREEN = GREATER then 90 from ...
Sun, 18 Oct, 2020 at 8:48 AM
'Declare variables Dim StrYear As String Dim StrMonth As String StrYear = Year(StartDate()) ...
Wed, 13 Apr, 2022 at 3:22 PM
'Looks up the value of [CountOfStatus] in the Query [Qry_Status] Where the value of status is 1-NEW StrValueNEW = DLookup("[CountOfStatus]", ...
Wed, 13 Apr, 2022 at 3:36 PM
Notes https://docs.microsoft.com/en-us/office/vba/api/access.docmd DoCmd.SendObjects https://docs.microsoft.com/en-us/office/vba/api/access.docmd.s...
Mon, 14 Dec, 2020 at 2:13 PM
THIS DOES NOT WORK ON A SUB FORM USE ME.FILTER https://parryit.freshdesk.com/a/solutions/articles/3000104384 Example of DoCmdApplyfilter:- Where yo...
Wed, 16 Dec, 2020 at 2:20 PM
'In this example, on double click, you save the current record ID, It then refreshes & requerries the form, and then goes back to the form record...
Wed, 13 Apr, 2022 at 3:57 PM
'In this example, by double clicking on a specific field, in this case YR, it sets the form focus to YR, brings up the search bar and after entering you...
Wed, 13 Apr, 2022 at 4:01 PM
DoCmd.Close method (Access) The Close method carries out the Close action in Visual Basic. Syn...
Tue, 22 Sep, 2020 at 2:00 PM