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 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: *

  1. vbreezy

    Duplicate Records Based on Quantity Requested

    I have an order file that consists of the fields: order#, customer#, item#, and quantity. I store this information in a temporary table. When the quantity is greater than one (for example, quantity is 6), I need to create 6 instances of that record so 6 items are manufactured and sent to the...
  2. vbreezy

    Comparing Fields to Find If More Than 2 Colors Selected

    (Access 97) I have four fields (Add1, Add2, Add3, and Add4) which each contain a color. I need to somehow check these four fields to make sure there are only two different colors used between the four fields. Does anyone know of any easy way to do this other than having tons of if/nested if...
  3. vbreezy

    How do I take specific characters from a string

    How do I reference the VBA Function, REPLACE, in Access 97?
  4. vbreezy

    How do I take specific characters from a string

    I have a field that is for a personal id with a length of three alphanumeric. I need to clean this field up to include ONLY numbers or letters. There should be no dashes or pound signs or spaces in these fields. I can trim off the spaces, but does anyone know how I can remove the unwanted...
  5. vbreezy

    Export Fixed Width Table with 2 Different Lines

    I have a table that has two parts to it: The first record is the "Order Header" and has certain information in it, with specific field lengths. The second record is the "Order Line" and also has certain information in it (some of the fields and field lengths are different...

Part and Inventory Search

Back
Top