Specify the following query and save it:
SELECT Lastrun.Username, LastRun.Date FROM Lastrun ORDER BY LastRun.Date Desc;
then use DFirst on this query instead of the table:
=DFirst("[Username] & ' on ' & [Date]","NewQuery")
perhaps, alternatively use DAO :D
As it turns out the x, y, width and height parameters for the CreateControl function, although all optional are nested so if ...
Application.CreateControl initFrm, acLabel, acDetail, , , , 56 + (X * 226), , 223
becomes...
Application.CreateControl initFrm, acLabel, acDetail, , , 0, 56 + (X *...
I am trying to write a class module which will create a series on controls on any given form with the end result being a menu. the class is called on the load event of a form:
Private Sub Class_Initialize()
Dim initFrm As String
Dim X As Integer
Dim p(1 To 17) As Control...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.