Search results

  1. V

    Wildcard has me stumped

    Hi all, Shall keep this brief thanks to exhaustion: Say I have a pallet ID 123456789 That ID goes into our system (this is how it is received as transmitted data from a customer) However, the pallet itself has a barcode that scans as 00123456789 When I scan the barcode (into a form control...
  2. V

    DLookup for update query

    Hi all, This is probably a super simple question, but DLookup and I never seem to get along. I have an update query that I wish to run that will use the DLookUp function to update an item description based on a material number. I have three tables in play here: 1. tblImportTemp: a temp table...
  3. V

    Checking multiple values in textbox/list

    [SOLVED] Checking multiple values in textbox/list Hi all, First a bit of context: The data I am using relates to pallets with individual bags on them. Each pallet is identified by a unique number (like a SSCC number for people who may work in a relevant field). A pallet may be broken down into...
  4. V

    Values related to report values not in source query

    Hi all, Hopefully I can spell out my issue coherently enough for people to follow! I have a report that is based on a Union Query that is generating an invoice for transport jobs. There are two numbers that I need to quote on the invoice that relate to each individual job (Job no. & Docket...
  5. V

    Keep random numbers for multiple records

    [SOLVED] Keep random numbers for multiple records Hi all, I am using a form to allow operators to scan barcodes one-by-one into our database. The operator will initially enter some text information which will be attached to the barcode's record in the table. I am successfully using the...
  6. V

    Combo box losing functionality

    [SOLVED] Combo box losing functionality Hi all, I have a combo box (cboMaterial) on a form that updates a number of text boxes with values from a table (tblProductList). The purpose of the form is to allow easy data entry for staff where a whole lot of product data auto loads based on the...
  7. V

    Updating table fields using form

    Hi all, I've been staring at my screen for hours trying to find a similar situation/solution to the issue I am facing, which has two criteria: 1. Form will be editing existing fields in a table that are blank (not creating new lines of data) 2. Form needs the fields to remain pre-filled with...
Top Bottom