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!

Register Log in
  • Congratulations MikeeOK 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: scottparks
  • Content: Threads
  • Order by date
  1. scottparks

    Read Input from Com1 Port

    I have an existing database that we are using to collect truck weights. We now have a truck scale that is capable of sending the weight electronically through the com port. Right now it is setup to send a continuous data stream on Com1. I want to display this data in a text box on a form and...
  2. scottparks

    Adding Lead Zero's in a Query

    I need to fill in with lead zero's if the number is not 6 digits long. I am having trouble with doing this. SERIAL is the query field I want to have 6 digits. Below is the code to generate the correct numbers, just no leading zeros if less than 6 digits. SELECT tblProductTicket.ProductCode...
  3. scottparks

    Barcodes in Access Report

    What is the best way to do barcodes in Access? I am currently testing BarCodeWiz ActiveX. Any other suggestions?
  4. scottparks

    Make-Table Query to produce grouping of records

    I am pretty new to Access and I need some assistance. Here is my problem. I know what my beginning and ending serial numbers are, and I know how many cases per pallet. What I need to do is group my serial numbers by pallet number. Example. ProductCode is the relationship link between all...
  5. scottparks

    Generatiing Sequential Number Table Using Query

    I have a table of product codes. I have another table that is populated by user input through a form. The user enters the product code, beginning serial number and ending serial number. I want to take that info and create another table with all of the entries. Example of user input: Product...
  6. scottparks

    Report Printing in Access

    I am new to Access and need some advice. I have a database with product codes and other info in it. I have another db that I am populating everytime the user wants to print labels. The user is prompted for product code (this is my relationship field) and enters a starting and ending serial...

Part and Inventory Search

Back
Top