If you put this in the criteria against the date column:
IIf(Weekday(Date()) In (6,7),[Please enter date to query],Date())
It works perfectly apart from the fact that it keeps prompting for the date whether it needs it ot not
The only alternative I have seen is to have a coloured rectangle on the form. You can not replicate where the system builds a meter but if you encompass it within a SysCmd Init and Update Meter it can be used.
If you use another rectangle for the total width set the width of the coloured...
Command buttons are not that flexible so an alternative could be to use a Rectangle rather than a command button. Set the BackStyle to Normal, the SpecialEffect to Raised, and the forecolour to something more unusual - the OnClick event is still available. It looks similar but you do loose the...
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.