Search results

Thanks for the reply, but I'm not so strong with vba. It's already giving me a lot of research. If you can help me with one button, I can do the rest. I think my problem is to setup the query the way, so that both filters can works independenthly of each other. Greetings.

Hi, I have a db, addressbook. In my form (frmAddressbook) i have a listbox (lstNames) with the first- and lastnames. There are also buttons to filter the listbox by category (Family, friends, colleagues). Sofar everything's working fine. Now I will make 27 buttons (A-Z & all) to filter the form...

Thanks for the reply. I found the solution. SELECT tblCategory.CategoryOrder, tblProducts.ProductName, Sum(tblOrderDetails.Quantity) AS SomVanQuantity, tblOrderDetails.OrderID, tblCategory.CategoryName FROM (tblCategory INNER JOIN tblProducts ON tblCategory.CategoryID = tblProducts.CategoryID)...

Hi, I have a crosstab query that shows the sales pro month. That's works well, but I want to show all products and not only those who have a value. How can I do that ? Is there anyone who can help me with this ? Thanks.

Thanks for the reply. Yes I know, the current datatype is "Byte". But we're working with small volumes, this is sufficient. I appreciate your help ! Thanks so match !

YES ! It works well ! Great job ! Thank you so match too all of you !

Thanks Eugene, but the problem still the same.

Thanks Eugene for the reply ! But, I get an error when I make an new order. Error 3201 You can't add or change a record because there is missing a related record in tblOrders.

Hi, I'm newbee here and my English is not so good. So I'm going to try to explain my problem. I have made a order db with main (frmOrderMain) and subform (frmOrderSub1). In the Order main form I have a listbox with products, populated from the table tblProducts. There is also a combobox to...

Hi, Thanks for the reply. First question: yes, regular add new products, delete older products. second question: no, for the waiters an overview of the tables, orders, products and prices. For me, a daily overview of the sales, money received, number of clients etc. but not an inventory of the...

Hi, Thank you for the reply. Finally, I try to create a form to add the products and the quantity of these products. These products and the quantity have to be added into the open orderform. So, I can add the complete order from one table (several individuals) at once. I'm looking for the most...

Hi, I have a DB with the orders in a restaurant. Now I want to make a form where I can make a selection of the products and the quantity of the selected products. These selection have to be added into the open orderform. After that, all the values have to reset. I already created a kind of...