Search results for query: *

MajP: Would this combo box FAQ work with just 1 table as both of these fields are in the same table or do I have to separate first?

Both fields are in same table, I will check out faq when I get back home Sunday. Thanks for suggestions

I have an unbound list box of Customers in a form. I can scroll click on the customer and that data comes up in the form. Each customer is classified in a field called Class. What is the best way to filter the customer list box list by class to shorten the list. Can you use another list box...

Got it working, thanks for all that helped

That did the job on making it updatable, But it is not giving my the correct results yet, How can I group by the Quote # and Line # and still have it updatable??? So close, [Code] SELECT [t_BOM Part Cross].

that link was great info, got me on track , here is what I have so far. I am getting an operator missing error, in the 2nd select statement. any help would be great Thanks [Code} SELECT [t_BOM Part Cross].

After all this, it comes down to one thing. When the select query gives me the correct results it is NOT updatable, When its updatable it does not give me the Min function or group by to get the lowest unit 1 for 1 line #. Your above would work if the select query was editable. thoughts?????

I had already tried that also including the table name, When I run Query the Q.field names come up as a parameter box, What might be the next step to try??? Larry

Got the Parameter Query working. The update query is giving me an error message getting close. The specified field [Use Part?]could refer to more than one table listed in the FROM clause in your sql statement. is this refering to the SET [Use Part?] = -1 of the Update Query? Any suggestions.

Hi Jerry: After a 2nd thought the subquery above does not have any parameters on it, Thoses come from the main form query. Your way to do this is best. I oould not get the revised Parameter Code above to save as a query, This is the error code from that Syntax error in PARAMETER clause. (Error...

Hi Jerry: Yes the Quote # is in t_BOM Part Cross as a text field. Here is the Upd_qwS Query Getting Undefined function WHERE in expression error message. UPDATE Q_Sel AS Q INNER JOIN [t_BOM Part Cross] AS U ON (Q.[Alt Unit 1] <> U.[Alt Unit 1]) AND (Q.[Line #] = U.[Line #]) AND (Q.[Assembly...

Jerry: I am getting the same error as before except it a Parameter clause instead of Where. Still getting the Where error on the Upd_qwS query. ONce these are fixed then I can test.What am I doing wrong here? Might have to hit the sheets and pick this up tomorrow. Please hang with me on this its...

Jerry: The Parameter box that comes up was from using =[FORMS]![Parameter]!

Hi Jerry, I am getting error messages on both Q not allowing me to save them, The first one "Syntax error (Missing Operator) in query expression Where

Is the after "then update" included in the query or do you run that as code on a command button? I am using Acc 97 getting an undefined function Where in expression Error

Hi I have a query I want to run that will autocheck the box [Use Part?] by picking the lowest [Alt Unit 1] value for each group of [Line #] in other words there could be 2 [Alt Unit 1] prices for the same [Line #] When I group and use the Min function I can no longer update the [Use Part?]...

It is a yes/no field, What I need to do is automate putting a check in the check box from the subform to pick the parts with the correct criteria vs manually picking the parts. Hope that clarifies.

I have a query behind a subform for selecting parts. What kind of code with a command button would I use to put a check in Use part? field which is a check box on the subform, Parameters for a particular Customer ID, Assembly # and Quote #. I would like to run the code to do the check after I...

I actually tried this but kept getting a compile error on the replace command of the code. I am using access 97 so not sure if that was it or not. This could work for what I am going to need and was going to contact you but have been slammed and did not get back to it. I could try it again when...

After talking with the users of this, They informed me that it would be better to do this another way so might have to do this on the back end of the process not sure yet,I have some other items to change in the database first then will get back to this. This was a project I did almost a year...