Monday 25 March 2019

Powershell Query MS Access Database in Microsoft Windows Application

Powershell Access Database – Ms. Powershell is a task automation and configuration management framework from Microsoft. To do this, first you will need ADO (ActiveX Data Objects) Database Connection to connect the Access database to PowerShell. Mostly, it brought along when you install Windows, but if you don’t have it you can download it for

source https://database.access-templates.com/powershell-query-ms-access-database-in-microsoft-windows-application.html

Saturday 23 March 2019

Microsoft Access Weekday and Week Number Function

Ms Access Weekday Function is purposed to return a number presenting the day of the week to a date. The result will be returned as number (integer data type) from 0 to 7. In the Access Query, you can add the field name into the Date parameter, as long the field value is Date. Following

source https://database.access-templates.com/microsoft-access-weekday-and-week-number-function.html

Tuesday 8 January 2019

Microsoft Access VBA Open Form to a New or Specific Record

The VBA code is the feature in Ms Access for programming to adding more function to Access database, using Visual Basic. To open the VBA window, press the Alt + F11 buttons in your keyboard. The Open Form function is to open specific form when an action is occurred, such as when clicking button in

source https://database.access-templates.com/microsoft-access-vba-open-form-to-a-new-or-specific-record.html