Search results

  1. C

    adding record based on combo

    Wow! Worked like a charm. But where should I put the DoCmd.OpenForm "Task" statement. I have a form that the user needs to type in the task once the correct serial number is accessed from the combo box.
  2. C

    adding record based on combo

    I am trying to add a record to a child database by inserting the serial number that the user chooses in the combo. Private Sub Combo40_AfterUpdate() Me.RecordsetClone.FindFirst "SerialNumber = '" & Combo40 & " '" Me.Bookmark = Me.RecordsetClone.Bookmark End Sub Private Sub...
  3. C

    auto increment field

    Is it possible to have an autoincrement number field with an input mask of 080000 so the first number would be 080001 and so on. Also to code it that the fives should not be used. For example 080005, 080010.
  4. C

    field can have 2 different lengths depending on first characters

    if the field starts with "yor" it should allow the user to type 12 characters or else the user should be only able to type 11 characters. How and where do I code this?
  5. C

    dlookup data type mismatch

    I have done as you asked and I get the error "You can't assign a value to this object". As soon as I start typing the serialnumber the next field which is docketnumber shows up as #name.
  6. C

    Only one record showing

    I meant to say that both fields serialnumber and docketnumber are unique in the table DOCKETS. However there could be many records in the table TASK LIST
  7. C

    Only one record showing

    In the table DOCKETS the serial number is unique. In the table TASK LIST there could be several records containing the same serial number because there could be several tasks each due on a different date per docket. So I wanted all the TASK LIST records that have the same serial number to show...
  8. C

    dlookup data type mismatch

    I have 2 tables. One is called DOCKETS and one is called TASK LIST. The field serialnumber in DOCKETS is the primary key which is related to the field serialnumber in table TASK LIST. The table DOCKETS has a field called DocketNumber. Both fields, serialnumber and docketnumber are unique and...
  9. C

    Only one record showing

    I have 2 tables. One is called DOCKETS and one is called TASK LIST. The field serialnumber in DOCKETS is the primary key which is related to the field serialnumber in table TASK LIST. The table DOCKETS has a field called DocketNumber. Both fields, serialnumber and docketnumber are unique and...
View older results
Back
Top Bottom