Search results for query: *

Thanks GingerR - it works exactly like I want.

I want to be able to populate a form field using a query. The fields on the form are: Part Number, Quantity, and Vendor ID. My form, on click, will check to see if I have multiple vendors available for the specified part number. If there is only one, I want the field to be populated with the...

I have a query that produces the desired results, but I need to be able to edit the results. So, the query is form resource. SELECT Parts.Part_Number, Parts.Component, Part_Detail.Manufacture_From, Part_Detail.Manufacturer, Part_Detail.Vendor_Part_Number, Parts.[Tracked?], Part_Detail.Vendor...

The problem I am having is that when one query does not return any results...it does just that - not return any results. That means that it does not provide my drawing-specific information (drawing_number, _title, _description, additional_info). So, this results in one "side" of the report...

yes. what I need now is to retain each BOM's number and information - drawing_number, drawing_title, drawing_description and additional description.

SELECT [BOM Compare].Drawing_Number, [BOM Compare].Drawing_Title, [BOM Compare].Drawing_Description, [BOM Compare].Additional_Description, [BOM Compare].Part_Number, [BOM Compare].Component, [BOM Compare].Quantity FROM [BOM Compare] LEFT JOIN [BOM Query] ON [BOM Compare].Part_Number=[BOM...

first query: SELECT [BOM Query].Drawing_Number, [BOM Query].Drawing_Title, [BOM Query].Drawing_Description, [BOM Query].Additional_Description, [BOM Query].Part_Number, [BOM Query].Component, [BOM Query].Quantity FROM [BOM Query] LEFT JOIN [BOM Compare] ON [BOM Query].Part_Number=[BOM...

When I do my unmatched queries, I need these fields... [BOM Query]. Drawing_Number, Drawing_Title, Drawing_Description, Additional_Description, Part_Number, Component, Quantity. Currently, if the number I am comparing against contains all the parts listed in the main number, I get zero...

thanks GingerR. ha ha...we meet again.

I have a report with two subforms that have distinct ID numbers. I want to seperate the ID numbers from the subform and place them in the main form. The ID numbers exist in seperate tables. Is there a way to either do this, or use a query to populate the text box/label?

ok, thanks, ill try it out.

so, GingerR, you are saying to have two unmatched queries? about outer join - im kind of lost on the whole query. can you give me an example of what you are talking about?

I need to be able to compare two bills of material against each other and only view the differences between the two. I'd like to have a report setup with drawing_info_a on the left and drawing_info_b on the right. pertinent applicable information: Tables: BOM Query - this holds Part_Number and...

You can add a new table lastQuantity. Everytime an item is used, either update the quantity or add the item into it. Its difficult to know what needs to be done without any additional information though.

thanks Gingerr - its working like I want it.

Cool - thanks GingerR. Is there a way to override this if ever need be? I am thinking of a worst case scenario in which I have only allowed administrators access to the design view of forms and queries - I don't want to lock myself out of my own house. Is there any way I can leave a key under...

Is there a quick way to disable F11 in a report (or any keystroke)? I don't want a user to be able to hit F11 and then do whatever they want.

hmm - well, I know I try to get around these problems by trying to spread out the code a bit. Put the combo_Orgs_and_Accounts.Visible = False code into a public function. When you go back to set your flag variable on exit, then change the focus or visibility of Orgs_and_Accounts.

sorry for posting in fragments. the code will look similar to this if (flag = false) then somethingThatIsntDropDown.Setfocus menu.visible = false else dropDown.setfocus menu.visible = true end if

well, if focus is the problem, on form open, have your code check your flag variable. if flag = false, diffControl.setfocus else dropdown.setfocus