Search results

  1. G

    PDF question

    I have a command button that will open a particular PDF file. Is there a way to have it open a file for that current record without having to browse? I am thinking I would name the file the same as the reference #, and then possibly ask to open the file name that equals me.referenceno Is this...
  2. G

    DCount #NAME? error

    This is my string to calculate the next increment # based on request date and users initials. However, I get the #NAME? error when I run the form? =DCount("[INCR]","tblPURD","[reqdate]=" & Format(me.txtreqdate,"\#mm\/dd\/yyyy\#") & " AND [initials] = '" & me.txtinitials & "'")+1 Any help...
  3. G

    incrementing number based on 2 other fields

    I want my db to generate our reference # automatically based on input from other fields. The number is the date record entered, the users initials, and an incremental number. Ex. 120505GMM02 My form is based on a query and I have the query generating the first two components from the date...
  4. G

    yes/no question

    I have set three yes/no check boxes so I can use them in a query to see if results are in another field. One example: After Update Event: If me.pickupdate.value is not null me.pickupdateckbox.value = true end if This works except it gives the true value to all the checkboxes on every record...
  5. G

    auto sequence number for reference number

    The title probably doesn't give an idea of what I need, so here goes. We currently have reference #'s for our bills that include the date requested in mmddyy format, the first 3 letters of the customer, the initials of the order taker and finally a sequential number to show the sumber of bills...
  6. G

    field value based on other fields

    Here is what I am trying to do. I have a table with routes that tell me which carrier to use. This is based on from what state to what state it is traveling as well as the service lever (next day, standard, etc.) How would I code for the value in the carrier field to populate based on the...
  7. G

    check box problem

    I have the following code on the On Current event of form PickUpReqDataFrm: Private Sub Form_Current() If Me.RescheduleCkBox = True Then Me.RESCHEDULEDDATE.Enabled = True End If If Me.RescheduleCkBox = False Then Me.RESCHEDULEDDATE.Enabled = False End If End Sub This works fine...
  8. G

    Populating fields from another form

    I deal with freight carriers and each one is assigned a code. There are over 30,000 carriers so I don't want them all in my carriers table. I have them all in a CarrierCodes table. I would like to open a form that would allow the user to search for the appropriate carrier and when they choose...
Back
Top Bottom