Search results

  1. C

    sending 2 variables through openargs

    I have a combo on a form that has contains serial numbers. If the user selects the appropriate serial number a form opens for the record to be edited. If the serial number does not exist the user adds it to the combo and a form opens so the user can add the rest of the information. Opening...
  2. C

    combo not updating form

    First Combo - working appropriately Private Sub cmbDSerialNumber_AfterUpdate() Dim rs As DAO.Recordset If Not IsNull(Me.cmbDSerialNumber) Then 'Save before move. If Me.Dirty Then Me.Dirty = False End If 'Search in the clone set. Set rs = Me.RecordsetClone rs.FindFirst "dserialnumber = '" &...
  3. C

    combo not updating form

    I have 2 tables. Dockets and Tasks. Dockets contains the serialnumber (DSerialNumber) and the attorney docket number (DocketNumber). Tasks contains the serial number (TSerialNumber) which is related to the serial number in dockets, the task no (no) because there could be several tasks, the...
  4. C

    sending a variable to a form

    I have a command button on a form to add a task Private Sub AddTaskBttn_Click() Dim Result As String Dim Sn As String Sn = Me.cmbDSerialNumber.Column(0) DoCmd.SetWarnings False DoCmd.RunSQL "Insert Into Tasklist( TSerialNumber ) Select '" & Sn & "' As Expr;" Result =...
  5. C

    not saving record

    When the add task button is pressed the form is supposed to collect the rest of the information for the record. The form opens and the serial number is added to the database however the rest of the field content on the form does not save Private Sub AddTaskBttn_Click() Dim Sn As String...
  6. C

    How can I let the code pause for user input

    I have the following code if a command button is pushed DoCmd.OpenReport "RCE", acViewPreview DoCmd.OutputTo acOutputReport, RCE, "SnapshotFormat(*.snp)", "C:\MyDocuments\" & DocketNumber & "RCE.PDF". How can I make it pause to see if the user likes the preview in order to save it as a PDF file.
  7. 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...
  8. 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.
  9. 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?
  10. 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...
  11. 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...
Back
Top Bottom