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 Rhinorhino 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. Aerowolf

    Reference query field

    I have a form where the user enters the sales order number and then hits a "Print Labels" button. The button opens qryVAN00 which queries the sales order table and filters it based on the sale order number entered. For each record in the query I need to grab the value in the ItemKey field and...
  2. Aerowolf

    Pictures on Continuous form

    I've got a txtPicture field on a form which is set to: ="\IMAGES\" & [PART#] & ".JPG" On this form I also have the field PART#, CATEGORY and PICTURE. I'm wanting to use this form as a subform on another form. This subform will be filtered by CATEGORY from a combo box on the main form. My...
  3. Aerowolf

    Combo box based off another combo box

    I have the following tables: Categories with a Category field. Types with Category and Type fields. I have form Items with subform ItemCats. In subform ItemCats I want the user to select the Category and then select the Type using combo boxes, but I want the Type combo box to be filtered based...
  4. Aerowolf

    Multiple records on same label

    I am using POs for one particular vendor that use the following format: Line item #1 contains Part #, description, and finish. Line item #2 contains Customer ID and sales order #. Line item #3 contains a period as a separator on the page. Each of the above is entered in the description field...
  5. Aerowolf

    Printing labels

    I didn't understand the number table thing, but I did solve my problem after finding an article in the Microsof Knowledge Base Here's my code: DoCmd.OpenReport "VanDykeProductLabel", acViewPreview DoCmd.PrintOut , , , , [Forms]![frmVanDykeLabels]![QTYLABELS], False DoCmd.Close acReport...
  6. Aerowolf

    Printing labels

    I am trying to print labels to a network label printer. I'm using the printout command as follows: DoCmd.OpenReport "VanDykeProductLabel" DoCmd.PrintOut , , , , [Forms]![frmVanDykeLabels]![QTYLABELS], False The label report specifies the network printer. [QTYLABELS] is the qty specified by the...
  7. Aerowolf

    Referencing 2nd workbook problem

    Thanks very much guys...got it working! Edwin
  8. Aerowolf

    Referencing 2nd workbook problem

    OK...so here is what I have right now: Dim nm As Workbook, nbr As String, due As String, ord As String nbr = ActiveCell.Offset(0, 1).Range("A1") due = ActiveCell.Offset(0, 9).Range("A1") ord = ActiveCell.Offset(0, 13).Range("A1") Set nm = Workbooks.Open("X:\WOVEN...
  9. Aerowolf

    Referencing 2nd workbook problem

    Here's my code: Dim nm As String, nbr As String, due As String, ord As String nbr = ActiveCell.Offset(0, 1).Range("A1") due = ActiveCell.Offset(0, 9).Range("A1") ord = ActiveCell.Offset(0, 13).Range("A1") nm = "X:\WOVEN PRODUCTION\CRIMP & WEAVE INST & ROUTINGS\" & ActiveCell &...
  10. Aerowolf

    Subscript out of range error

    Here's my code: Dim nm As String, nbr As String, due As String, ord As String nbr = ActiveCell.Offset(0, 1).Range("A1") due = ActiveCell.Offset(0, 9).Range("A1") ord = ActiveCell.Offset(0, 13).Range("A1") nm = "X:\WOVEN PRODUCTION\CRIMP & WEAVE INST & ROUTINGS\" & ActiveCell &...
  11. Aerowolf

    Reference field from user input

    The code I have is below. The Shipment form has the field [LOC] which is one of a few set values (ie. RAW, SV, NB, or FB).These values represent the names of fields in the Parts table. Once the form is updated I want to use the value of [LOC] to reference that field in the Parts table. How do...
  12. Aerowolf

    Filtering a form on an inputbox value.

    Here's the code I've got: Dim QTY As String, q As Integer, p As Integer, ITEM As String ITEM = InputBox("Enter unit part #:") DoCmd.OpenForm "frmBOM" DoCmd.ApplyFilter , [Forms]![frmBOM]![PARENTPART] = ITEM If [Forms]![frmBOM]![PARENTPART] <> ITEM Then result =...
  13. Aerowolf

    Duplicate lines based on qty in cell

    Got it to work and it works great!!! Thanks alot! Edwin
  14. Aerowolf

    Duplicate lines based on qty in cell

    Thank you for this. Works great except that it only processes the first line. How do I make it do the whole sheet? Edwin
  15. Aerowolf

    Duplicate lines based on qty in cell

    I have a list of ship-to addresses from a customer. The last field contains the number of packages to ship to each location. In order to import this into my Fedex software, I need to have each line represent one package. Therefore, I need to duplicate each line in the original list by the...
  16. Aerowolf

    Simple question?

    I've got 2 tables; Employees and Timesheets On a form I want to display a list of the employees on the left of the screen and the timesheet entries on the right. When the user selects the employee, the correct entries show on the right. I want to be able to add to the timesheet entries. I...
  17. Aerowolf

    Display text instead of date in date field

    Is there a way to show text in a date field on a report? I want to be able to put "N/A" in a date field if the field is null. Thanks Edwin
  18. Aerowolf

    Grouping problem

    Worked great...thanks!!
  19. Aerowolf

    Grouping problem

    I am trying to sort and group a report based on 2 fields; we'll call them date and type. I want to sort and group as such: sort by date and group by month with each month on a separate page. for each month i want to group by type with each type going on a separate page. The result would be...
  20. Aerowolf

    Referencing subform

    When I use the following: [Forms]![frmOrderEntry2]![Order Details].SetFocus I get an error that says the database cannot move the focus to the control Order Details. Edwin

Part and Inventory Search

Back
Top