Recent content by maniaouri

I tried it and it says enter parameter value. I want to do it automatically when i enter the value in the textbox or combobox.

I have a very simple question to make: how I insert into a table or a query the value of textbox or a combobox.I want to use the insert into command. I tried to type the name of the control but it produces the insert value message. I know the syntax if I write the value in the code but not if...

I have 3 tables: materialcategory materialsubcategory materialdate they are connected each other with one to many relasioships I have created a form in order to add new materials and which has 2 comboboxes combocategory combosubcategory and a subform materialdata When I choose category...

I did it. I tried a small trick and it worked. thanks for your time

I did it. I tried a small trick and it worked. thanks for your time

Dim rs As Object Set rs = Me.[Material Data Subform].Form.RecordsetClone rs.FindFirst "[Material SubCategoryId] = " & Str(Nz(Me![Combo16], 0)) If Not rs.EOF Then Me.[Material Data Subform].Form.Bookmark = rs.Bookmark i changed them all but now it...

I don't want to get you tired but I have 2 questions in order to see if I understood what you said: 1. rs = Me.Recordset.Clone should be changed to the name of the subform? or I have to put the table.I tried me![material data subform] and didn't work. 2.me![Material Data subform]![Material...

but I did it with the 2 comboboxes but it doesn't work with the subform can you please take a look

Here it comes: I have three tables material category / subcategory / data and I am trying to make a form in order to add new data to these one to many related tables. So I am thinking to have 2 combo boxes one for choosing material caterogy, the other to choose material subcategory and then in...

My problem maybe very simple but I cannot solve it.In the database I was working suddenly the date() function disappeared.I searched the references of the project but there is noone missing or having problems.What do you suggest?How can I insert it again?Does anyone know the dll or the reference...

1. No each factory has each one products. 2. The problem is not the table with the products the problem is how I will have the relationships in the database in order to have the opportunity to add the orders (with products) and then to import them in the invoices in order to create the...

The chain is DELIVERY-INVOICE-ORDER.Please take a look at the attached file i put the option I am trying now.Please feel free to make any suggestions.i don't know if I am correct.

First of all by saying: So there is a conflict because the primary key of orders should be linked twice. I mean that the primary key of the table ORDERS should be linked one time with the table PRODUCTS and a second time with the JUNCTION TABLE INVOICE-ORDER as you can see in the attached...

Do you mean a Union query.The problem is that when the user will be working he will enter first the orders and after when the order is ready and he receive the documents of the shipment he will connect the entered order with the case and the invoice. is it more clear now?

Hi all, please note that I am trying to create a database regarding the inbound shipment management of a warehouse.I have the following tables that I need to link: SUPPLIERS ORDERS PRODUCTS INVOICES CASES Every supplier has many orders.One order has one or many Products.So far is easy beacause...