DMAX expression being returned in wrong format Using quotes as the delimiter will result in it being interpreted as an arithmetical expression This in itself won't cause an error, because the date time data type in Access is implemented as a 64 bit floating point number, so the expression would result in a date time value corresponding to the number returned, usually around the end of the
default value on a subform - Microsoft Community I have a database that tracks flights of aircraft The main table has the aircraft in it I also have a subform that is linked back to the main form thru aircraft ID# On the subform I would like for
SYNCHRONIZE TEXT BOX AND SUBFORM - Microsoft Community SYNCHRONIZE TEXT BOX AND SUBFORM Hello everyone! I just created a new text box, it's bound to the expression ' [fCustomer] [Form] [CustomerID]' fCustomer is subform (being datasheet view) When I click on any row of the subform, the text box will show the information in the subform by the expression above I finished this step
Entering parameter values when running a parameter query This is a always a good idea with date time parameters to avoid any possibility of a parameter value entered in short date format being misinterpreted as an arithmetical expression and giving the wrong results