I have a continuous form that I want to sort by the column (field) when the lable is clicked. If the field is currently in DESCENDING then I want to reverse the sort when clicked. If no sort is currently on then sort Ascending.
What is the best way to do this?
me.orderBy or DoCmd.runcommand ascmdsortascending?
assuming the field you want to sort by is LastName and the the label is LastName_label
private sub LastName_Label_click()
if me.orderby="LastName desc" then
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database. This article shows how to recreate this functionality in Windows 7 through 10.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro: