Search results

Ok, Thanks a lot "Pat Hartman".

Hi, I've a search form that lets the user search in the Orders. It consists of some combo and text boxes and a SubFrm (whose the record source is a query). The SubFrm is a continuous form. I've added a button to appear in each record (order). This button opens another form that contains all the...

Hi, I've the same problem that "Tikafyre" was facing. I tried to use the code that "Jack Cowley" posted but the problem is that I'm a beginner for using MS access so I don't know how to edit the code to make it useful for me. In the initial code, it checks that there is no duplicates in the...

Hi, I've a form used to add new orders (from the OrdersTable) containing a subform for order details, such as the item No, quantity, and unit price (from the OrderDetails table). I'm wondering if there is a way to check the current stock of an item while making the order to make sure that the...

Thanks a lot "namliam". I eleminated the "group by" and I can edit the records now. Thanks again 4 ur help

Hi, I have a query based on two tables and I have a problem in editing records on it. -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Here is its SQL: SELECT...

Hi all, I've a from that contains a combo box and a subform. The combo box is used for searching in a certain table. In other words, after choosing a value from the combo box, I get all the records related to this value. This part is working very well. Now my question is: is there a way to open...

Thanks a lottttttt "Rich". I found the way to do it. Thanks again :D

I requery the subform in the after update event of the combo box. So I get all the records related to what's in the combo box. Actually that part is working well. The problem is how to add the word "all" at the begining of the combo box so that it gives me all records available and not just a...

Sorry I don't understand what "populating" is. Actually I'm still a beginner. Anyway here's what I'm doing: In the subform I have a query that gets all the inforamtion for the chosen company. So I requery the query in the after update event of the combo box. I don't know if that is what u mean...

Hi, I have a form contaning a combo box and a subform. I'm using the combo box to search by the company name and in it's after update event I requery the subform. This part is working very well. My question is: how can I add an option called "all" in the begining of the combo box (that contain...