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 bkrike 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: zr500racer
  • Content: Threads
  • Order by date
  1. zr500racer

    Individual Labels for line items with a qty of >1

    Hello, I am trying to create a report that will print shipping labels for items that we ship from our factory. In the backend database the "orders" table each record states that in [Order],[Customer]ordered a [Quantity] of [ItemID]. My report is printing to a standard sheet of (6)4"X3.33"...
  2. zr500racer

    New Hard Drive shows up as "E:", need it to be "C:"

    I replaced the hard drive in a co-worker's workstation. It went well. The only problem that I ran into is getting the new hard drive to be "C:" On start up, it recognizes the new hard drive as "E:". I have it jumped as the Master drive. Windows will go through it's startup routine, then when...
  3. zr500racer

    Automatic appending of numbers

    Hi, I have created a form that, through the use of an append query, adds product numbers and descriptions to a table. The "item number" format consists of 4 letters followed by 3 numbers. i.e. POEN001 or GOSD003. The form is set up so that the end user chooses the Department (first...
  4. zr500racer

    Sorting Groups In Reports

    I have made a report that gives me information on products we sell (ItemNumber) and what we get for profit in doing so. We have about 300+ individual items that we manufacture, so I group them by ItemNumber. After they are grouped I need to sort these groups by profit, that way it's easier for...
  5. zr500racer

    Fractions in Access, I think I know how, but.....?

    I had this working by creating a macro to send table information out to a pre-formatted Excel Spreadsheet that converts the decimals to fractions. It then converts the fractions to text. I then linked this spreadsheet back into the database with the decimals converted over to fractions...

Part and Inventory Search

Back
Top