Recent content by Basshopper

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