Search results

Thank you theDBguy for replying but your way is hard to do because I have many boxes and i should create query for each boxes, it means if i have 20 boxes, I should create 20 query . thanks anyway Thank you arnelgp, I used your query and module, that was great and my issue resolved. but I have...

Hi plog, your are right theDBguy, I couldn't do it with plog guidance , I attach part of my database in this post, can you do it on my database? (as I said I want to figure out products that are in all boxes)

Hi all and thanks for replying, I want to find product that is in all 4 boxes, it may be one product is in all box or tow products is in all box (i don't want to figure out maximum box)

Hi all, I have a table with two columns that the first column is box name and the second column name is product name and I want to select products that is common in all boxes, for example : box.................product box4.................. E box1.................. A box2.................. B...

Hi all, many thanks to all for your advice and guidance, My problem has been resolved with MajP class module.

Hi all, I have a lot of items in combo box list and because it's hard to find one item from list, I decided to add searchable feature to the combo box, in this regard I added this code to on change of combo box event : Me![Combo2].RowSource = "SELECT [ID], [S_symb], [S_name] FROM tbl_Symbol...

Thank you so much for crossing tab , I learned cross tab and did it myself, it was very easy and useful. :cool:

Hi, Thank you for reply, yes my table has a unique primary key, but your code give total count of product whereas I want to get count of each product in the field for every one,

Thanks, what's crosstab? I don't know access a lot.

Hi all, I have two columns in table that first column is personal id and second column is product which they buy to our company. it's sample of the table : personal id ...... product ....10 .................... A ....10 .................... B ....20...

Hi all, I wrote a simple code to prompt or alert name of each selected records, but it's not working : Dim rst As Recordset Set rst = Me.Child96.Form.RecordsetClone rst.MoveFirst With rst Do Until .EOF If .Fields("chk") = True Then zz = .Fields("t_name") MsgBox zz...

Hi all, is it possible to use variable instead of field name after where in select sql ?? pSQL = "select * from tbl_Data WHERE Type1 = '" & Me.Text0.Value & "' " in the code i want to use variable instead of Type1 and I wrote it but it didn't work : var = me.text2 pSQL = "select * from...

Hi June7, That was great, thank you for spend your time for me.

Hi June7, sorry, your code works fine, I was wrong. But I have another question, Can you add another field to the code?? my third field is "S_Type" and its textbox is "Text13" it means the subform filters by 3 fields (text25,text5,text13).

Hi to all guys for guide and advice me, I sincerely apologise for replying late to Response, CJ_London, I use this code becuase subform nothing shows when the textboxes are empty jdraw, You're right, I should to used meaningful names to controls, thanks so much for advice sonic8, that's great...

Hi all, I write the code to filter subform by two criteria on after update of textbox, but i think that's long and should be a way to brief that, Can someone help me or give a correct way to do this?? Private Sub Text5_AfterUpdate() If IsNull(Me.Text5) And IsNull(Me.Text25) Then...

Thank you all, my problem is resolved, sorry for my poor english.

Thank you, But you wrote the wrong code, : IIf([amount < 1000 ,.....) can you attach the file here?

Hi, if you check my uploaded access file, the field is number and when i remove quotes around "1000" then ok (as same below) but give error : =IIf([amount]<1000,[price],[amount]*[price])

Hi all, thanks for reply This is my table that I want to calculate price :