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

  1. mirgss

    BO XI 3.1 Webi SP5 users can't access folder

    Hi: We are having an issue where the users of one of our agencies (we support multiple agencies) cannot access a folder on a shared network drive through Web Intelligence Rich Client for saving or opening files. Our users can access the folder through other applications, including Windows...
  2. mirgss

    Updating Combo Boxes in a Form

    Hi Golom: I removed PartDescription from my SQL for the Control Source for Part# and checked my query in Datasheet view to make sure the appropriate columns were checked/not checked to be visible. I also checked the Property Sheet for the combo box and messed around with the column count and...
  3. mirgss

    Updating Combo Boxes in a Form

    Awesome. Thanks! Is it a faux pas to ask another question in the same thread that is related? For some reason, whenever I select a manufacturer, my part number drop down is blank. My row source for part number is: SELECT tblParts.PartID, tblParts.PartDescription FROM tblParts WHERE...
  4. mirgss

    Updating Combo Boxes in a Form

    Hi all: I have a form for ordering parts. My combo boxes are Manufacturer, Part#, and Part Description. When selecting a Manufacturer, I want only Part #s from those manufacturers to appear in the combo box. Ditto for part description. When updating either Part Description or Part#, I want the...
  5. mirgss

    Auto add new line/record?

    Okay, I got rid of the code per your suggestion and added the proper control sources, but I still have the same problem. For example, if I select "Bosch" as the mfgr for the first part, I get options that are manufactured by Bosch. However, in the next record, if I select GE, it still gives me a...
  6. mirgss

    Auto add new line/record?

    Okay; I created a continuous form and it mostly works. I'm having just a couple of problems when I add more than one part: 1. In VBA, I have Private Sub PartDescription_AfterUpdate() PartNumber = PartDescription End Sub Private Sub PartNumber_AfterUpdate() PartDescription =...
  7. mirgss

    Auto add new line/record?

    Awesome. I will give this a try. Thank you! Miranda
  8. mirgss

    Auto add new line/record?

    I do have a separate record for each part, in tblParts. What I'm trying to figure out is if there is a way I can have only as many lines appear in my form as I need, instead of having extra or not enough rows in my form to accommodate the number of parts in each estimate. This means that...
  9. mirgss

    Auto add new line/record?

    Hi: I have a table and form "Estimates" for quoting installation prices. Currently I have quantity, manufacturer, part #, part description, and price 1-8, for entering up to 8 parts on one estimate. However, using this method I can only enter 8 parts per estimate, and if I have fewer than 8...
  10. mirgss

    Selecting Part Number Based on Manufacturer

    I will take a look at that; thanks! I do have tblEstimates which stores each record created in the form. My customers are not tech wizards (even less than me!) so I thought a form would be best for entry instead of asking them to enter information into tblEstimates. I'll definitely take another...
  11. mirgss

    Selecting Part Number Based on Manufacturer

    Oh, then Skip must have meant the statement for the row source. Sorry...I am still pretty new to all this (obviously). In my form I have Mfgr 1-8, Part Numbers 1-8 and Part Descriptions 1-8 as combo box fields (for ordering of up to 8 parts). I don't know if there is a better way of doing this...
  12. mirgss

    Selecting Part Number Based on Manufacturer

    You're right; I apologize for mistyping. For each part number and description, I have something like what I posted above: Private Sub PartNumber2_AfterUpdate() PartDescription2 = PartNumber2 End Sub Row sources for the part numbers and descriptions look like this: SELECT...
  13. mirgss

    Selecting Part Number Based on Manufacturer

    This points me in the right direction but I have a lot going on in this DB right now. I added the code you suggested (to the best of my ability) and now I get an error when I try to choose a part description: I can't assign a value to the object. The code that the error directs me to is this...
  14. mirgss

    Selecting Part Number Based on Manufacturer

    Awesome. I do have tblParts, which has the manufacturer, part #, and part description. Can you point me in the direction of a tutorial or something so I can figure it out?
  15. mirgss

    Selecting Part Number Based on Manufacturer

    Hi: I have a table and a form with Part Number and Part Description. Right now, I have the form set to autofill the part number and price when a particular description is selected, and autofill the description and price when the part number is selected (using combo boxes). My customer now wants...
  16. mirgss

    Report shows part numbers in part description field

    I guess I should have realized I needed the Column(1) in there. Thank you so much everyone for your help!
  17. mirgss

    Report shows part numbers in part description field

    PartDescription1 is a combo box that's linked to the PartNumber1 box in the form, but it is a text box in the report. I have the record source as SELECT Estimates.ID, Estimates.Date, Estimates.Representative, Estimates.Customer FROM Estimates; Does that help?
  18. mirgss

    Report shows part numbers in part description field

    Sorry; I'm not trying to be annoying. In the property sheet of the text box in the report it says "control source" so I figured that's what it was. I have the text box set to what you suggested in your first post; but it just comes up with the part number. If I try setting it to the table that...
  19. mirgss

    Report shows part numbers in part description field

    No, there is not a SELECT statement in the control source. I am an idiot - sorry! Dhookm: yes, I am trying to display a part description field (combo box) in my form in the part description field (text box with previously noted control source). To generate the report, I have a button on the...
  20. mirgss

    Report shows part numbers in part description field

    Okay, I'm going to do my best to explain this. I have a form "Estimate entry form" into which my users will enter data for an estimate - part number, description, and quantity. I have part number and part description in a combo box, and if the user selects a part number it will update the...

Part and Inventory Search

Back
Top