How to shut down a custom Access application remotely

Posted by & filed under Access.


Sometimes, you may have to perform maintenance tasks on a Microsoft Access database, such as compacting or repairing, making backup copies, or making design modifications. Many of these operations require that all users exit the database. However, there is …

7 Ways To Do Sequential Numbering in Microsoft Access

Posted by & filed under Access.

Occasionally we come across project requirements that include the ability to do sequential numbering in Access on a set of data. We cannot just use the auto-number data type because there is no promise of sequentiality but only uniqueness. In …

Is Not Null

Posted by & filed under Access.

Put in where condition as below:

Sub CreateRst_WithSQL()
   Dim conn As ADODB.Connection
   Dim myRecordset As ADODB.Recordset
   Dim strConn As String

   strConn = "Provider = Microsoft.Jet.OLEDB.4.0;" & _
      "Data Source=" & CurrentProject.Path & _

   Set conn = New ADODB.Connection

The Bang! (Exclamation Operator) in VBA

Posted by & filed under Access.

One of the most peculiar aspects of Visual Basic for Applications in the ! operator, called the “bang”. There’s a lot of confusion about the bang operator, and nowhere have I seen the correct whole story about it. So, I …

MS Access Select top n query grouped by multiple fields

Posted by & filed under Access.

SELECT StudentID, Year, Subject,  AVG(TestScore) AS AvgScore
  SELECT StudentID, Year, Subject, TestScore
   FROM MyTable t
     FROM MyTable
    WHERE StudentID = t.StudentID
      AND Year = t.Year
      AND Subject = t.Subject