Recent content by Tom d

  1. T

    Solved Place cursor into a field on opening a form

    Thanks For Your Help Got it to work
  2. T

    Solved Place cursor into a field on opening a form

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

    Change a Date Format

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

    Change a Date Format

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

    Change a Date Format

    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?
  6. T

    Solved Some Code executing, some not executing on a form event

    Thanks for all your help.
  7. T

    Solved Some Code executing, some not executing on a form event

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

    Solved Some Code executing, some not executing on a form event

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

    Solved Some Code executing, some not executing on a form event

    I will try and make a switchboard.
  10. T

    Solved Some Code executing, some not executing on a form event

    Here is my Data Base Attached
  11. T

    Solved Some Code executing, some not executing on a form event

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

    Solved Some Code executing, some not executing on a form event

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

    Solved Some Code executing, some not executing on a form event

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

    Solved Some Code executing, some not executing on a form event

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

    Solved Some Code executing, some not executing on a form event

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