Recent content by the1rock

how to fix the letters when its not working . its work fine in the vb code . but when getting the msgbox its not. i think its need converting or something thanks in advance

Thanks Alot Mihail :)

Thanks its work with me like this also If (DCount("*", "bills", "[group]=group.value") > 20) Then MsgBox ("Enter New Group") End If one more question . how do i lock the DB . i mean tables , queries . so only the user can use the forms only

x = DCount("*", "bills", "[group]=group.value") this will count in every single input i want it when its got more than 20 input for the group to show msgbox says u got 20 records for this group

first the Criteria doesnt work to count when i input its keep count all records 2nd if its worked it will keep counting every single input and i dont want that i am not an expert in vb so if you may help!

actually i dont know what you talking about!

Thanks for your reply i tried Dcount but its will count all the record in the table and i dont want that . i want it to count the record for the input lets say if i have 10 record having group num 1 so its must show that theres 10 records when i inter the group num 1

In my DB i have field Called Group . I want a Vb Code to count the record in the Table based on the input in the Group Field on The Form.(lets say Group = 1 , after many inputs of the first group i want it to count) And if its more than 20 . show Msgbox thats you need to use Diff num for the...