When an user is entering data in a form there are some logical errors that may occur. These are not serious until the ‘Save’ button is clicked. I would like to advise the user by the way of a gentle alert that there is a problem.
For example if the cost is 10 and the charge is 9 then there is a problem that needs addressing.
So I have created a label that is normally not visible. The caption on the label is then set to explain the problem i.e.
Me.lblAlert.Caption = “Cost is higher than charge”
Me.lblAlert.Visible = True
… but I would like to clear the alert after a few seconds with:
Me.lblAlert.Visible = False
I am not sure how long to leave the alert visible but I can experiment.
Does anyone have some timer code that would achieve this please?
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Sometimes MS breaks things just for fun...
In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset.
Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…