Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JanBS
  • Order by date
  1. JanBS

    Append records to table based on a changing variable

    I followed Duane/dhookom's suggestion and I am now all set! Thank you all very much for your help. It was greatly appreciated!!! [roll1] Jan
  2. JanBS

    Append records to table based on a changing variable

    Skip, I wiped it all out because I was frustrated. I don't even remember what I had because I must have tried 20 different ways. Now I can't get it to do any appends. I currently have Repeat Expression = DCount("*","SerialNumbers","SerialCount =" & "WhatQty") which does nothing. Andy...
  3. JanBS

    Append records to table based on a changing variable

    Hi there. I need to created serial numbers for kits being shipped to a customer. They are 19 characters long with the last 4 digits starting at 0001 and ending with the total number of kits that we need to make, which is determined by the quantity in a production order. On a form I prompt...
  4. JanBS

    Excel Conditional Formatting of list of text

    I have an Excel file that uses an MS Query. This will get refreshed on a regular basis. On one column I would like to apply conditional formatting. The column is called Bin ID. If the value of the Bin ID contains "RED", "WHITE", "GREEN", "BLUE", "YELL","BLACK", "BOX" or "BENCH" (such as...
  5. JanBS

    Barcode Scanner does not scan some characters correctly

    Thank you for your reply. I was just notified that the issue seems to have cleared up. I have no idea How or When it got corrected. The gremlins must have done it. [bigears]
  6. JanBS

    Barcode Scanner does not scan some characters correctly

    Hello, We have a number of Symbol/Motorola LS4208 Barcode Scanners that we use. There is one scanner that does not scan the dash "-" or the slash "/" characters correctly. It scans a slash "/" as a dash "-" and it scans a dash "-" as a comma ",". Another same model scanner scans the same...

Part and Inventory Search

Back
Top