Search results

  1. 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
  2. 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?
  3. 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...
  4. T

    SQL error message

    ' strSql = "Delete * from [tlb Blood Pressures] where [date Entered] >= " & fromdate & " AND [date Entered] <= " & todate strSql = "Select * from [tlb Blood Pressures] where [date Entered] >= " & fromdate & " AND [date Entered] <= " & todate MsgBox " strSql=" & strSql DoCmd.RunSQL...
  5. T

    Error massage invalid Brackeing of name in query

    Getting this error massage in a criteria field in a query Between[[Forms]![frmSelected_Statistics]![(CDate lst_From_Date.Column(1))] And [Forms]![frmSelected_Statistics]![(CDate lst_To_Date.Column(1))]
  6. T

    Solved the data base engine could not lock table

    trying to split a database get this error message the data base engine could not lock table 'tlbblood pressures' because it is already in use. I am using a stand alone computer. nothing is open in access
  7. T

    Solved convert a date

    I have a text field in the format mmddyyyy and I want to covert it to a serial number.
  8. T

    Hello

    I am a newbie to Access. I live in the us Georgia.
  9. T

    Solved Delete table entries based on from and to list box selections.

    I have a table with blood pressure readings. I load 2 list boxes with the tables entries. One for the delete from list and one for the delete to list. I want to delete records from the table based on the entries selected. How do I do that?
Top Bottom