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...
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...
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...
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...
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...
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 =...
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...
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...
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...
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...
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...
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...
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?
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...
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?
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.