I have a query with a date field named 'Date_Entered By Month' in the format of 'mmyyyy' and the query is sorted by the date field. I want the format in the report to be "mmmmyyyy'. How do I write the format statement?
when opening frm Blood Pressures it was data already filled in should not have any data in the fields.
Data Base opens very fast on my computer.
I am running office 365.
I enter 9999 in systolic and the greater than 999 error message happened. Next a message box came up "You can't save the record at this Time' with 2 buttons 1 Yes 2 NO. If yes is pressed, you exit the form. If no is pressed, you get a message box saying error 3021 action name = CloseWindow and...
I have this code on a TextBox on a form in the 'On Exit' event.
The If (Systolic) > 999 Then, executes and the message is displayed.
The focus is not set to the Systolic text Box, it is set to the next text box on the form.
I tried 3 versions of the SetFocus.
Can any one please tell me what the...