Search results

pr2-eugin, actually I visited all the links that you provided above, but don't actually know where I got lost :( Seems to me, [URL="http://www.599cd.com/tips/access/two-combo-boxes/"/URL] is good gor my case, but problem is I am not sure why it comes up with no result

No, it doesnt work. the Error message I got is : run_time error -214352567 (80020009) :(

Yeah, actually something is wrong with my designing of the table and queries. May be in the relationship.

I put this code on the Order Form: Private Sub Order_Product_AfterUpdate() On Error Resume Next Order_product_Name.RowSource = "Select Orders query.Product_Type" & _ "FROM Orders query " & _ "WHERE Orders query.Product_Type = '" & Order_product_Name.Value & "' " & _...

Indigo, It still opens in the background. Actually, I put the above codes into OnNotInList property of the Customer control. Things work find with open Customer form, but when I refocus to the Order Form, there is problem. Ms Access keep telling me that it cannot find "Product_Type" (another...

Guys, I did every thing as posted in previous posts but stucked with a problem: After puting a new entry into Customer, I close the Customer form and continue with Order form, which still open at the time. Problem is I have to close the Order form and then reopen it so that the data of the new...

pr2_eugin, actually this is what happening: After inserted the code in the afterupdate even of Order_Criteria combo box, whenever I choose any thing from this combo box, nothing happens with the Order_name, even worse, I cannot choose any thing in Order_criteria, much less about Order_name.

Thanks pr2-eugin, here is what I put in the after update of combo box: Order_Criteria: Private Sub Order_Criteria_AfterUpdate() Dim strSource As String strSource = "SELECT Order_Criteria " & _ "FROM Order_Criteria " & _ "WHERE Order_Criteria = '" &...

I have 2 combo boxes: Order_type and Order_Description (both come from 1 table) and displayed on 1 form. I want to restrict the values in Order_Description to related records in Order_type. I.e when an user select "Stationary" in Order_type, values in Order_Description would be restricted to...

Thanks, I got it

Thanks, I did insert this Code in to the after update section but got an error message: Run-time error -2147352567 (80020009) The value you entered isn't valid for this field! What is it?

Here is a problem: I have a combo box Customer_Name on Order Form; and I want it open the Customer Form when an user insert a new customer to input all data. This seems simple at first, but problems are these: 1- whenever an user opens Customer Form on a new customer, the user would have to make...

Thanks, Bob!

Bob Fitz: on a form please

What would be an expression if I want a default value is equal the last record + 1? Thanks

Guys, here is my tables and the fields included: 1. tblOrder: OrderID (Autonumber, PK); OrderCode (unique numer and letter, indexed (no duplicate)); OrderDate; OrderQuantity; OrderAmount; Customer (lookup to CustomerID in tblCustomer) 2. tblCustomer: CustomerID (Autonumber, PK); CustomerName...

Jdraw, thanks for the videos. Actually I watched them several time, but still cannot comprehend it :(. Is there any simpler way to go with my particular database? Say what to do with my OrderQuery? Thanks

Thanks Cronk, It seems resolved my issue but I still have another one, sorry :) I have other 2 tables: product_types and product_details; tblproducttypes contains things like stationary, household, bath etc... the tblroductdetails contains subcategories of product_types like pen, soap etc. in...

Cronk, Actually I have that kind of field in tblOrders and I also want users to input the Customers' names in a Combo Box created from a queryOrders. In fact, I want the users to do the job for me (put in customers' names including new ones but not to mess up with the ones that already there)...

Yes, I do. Part of it because I want not to look up customer every time I put in an order. Another part is because the users keep messing up with customers' names. However this drives me crazy because it is difficult to sort the customers into several types (ie loyal, oneoff or walk-in)