Search results

How do I place the cursor on a field on a form when the form opens

Look At the Monthly Query, it is in the correct order but I cannot get the report in the same order.

Tried =Format([Date-Entered By Month],"mmmmyyyy") Received error #Type!

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?

Thanks for all your help.

I add a switchboard to your data base. The Data Base never adds a new record to the table, I am totally confused.

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 will try and make a switchboard.

Here is my Data Base Attached

I know that the code is being looked at because the other code works. I am new to access and vba so I do not know how to do things.

I do not know more then you, but I may be stupid but your code does not catch a blank field.

I do not know more then you, but I may be stupid but your code does not catch a blank field.

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...

Dumb question, found my answer.

I have attached my Final Data base, if anyone is interested. Question, were do you execute the qyery qryselected_statistics on form frmSelected_statistics?

IT WORKED. Thank You The problem was the SQL statement, other code fixed the problem.

I just use the list boxes to get the dates . in the SQL statement that does not work. I am trying to get selected records from the access table.

The code is on the button on the form frmSelected_statistics

There is a text box on the same form as the button containg AvgOf Systolic I want to load the text box with the average of the selected table records Forget abut the commented out delete statement that is on another form and works fine.