Search results

I have two tables. First table "Orders" is parent, secondary "Works" is child. In Works on button event in field work_status i have the number, for example "6", which i must have in parent table "Orders" in field status_id. Criteria of this tables is order_id. What i must use? Update or copy...

i found a problem, and thank you for help

I have this code Dim orders_nr As Integer orders_nr = Forms!orders!order_id Dim b As Integer b = DCount("[work_status]", "Works", "[work_status] = 2 And [orders_nr] = " & orders_nr & "") And compile write You canceled the previous operation

oh, thank, I made like this b = DCount "[work_status]", "Works", "[work_status] = 2"), and it's working. but i have another question. Could i add another criteria to this one? That dcout ount only those records, which have the same for example "order_id"? table is the same.

i have table works. and each record (work) has work_status. i need to count, how many works has work_status = 3 i wrote i query dim b as integer b = Count("SELECT [work_status] FROM [Works] WHERE [work_status] = 3") compile wrote: wrong number of arguments or invalid prperty assigment. I don'...

Hallo, i have a question I have a form with listbox. A lot of records in listbox have the same status. For example: Pending, Active, Frozen. Could i make colors in listbox, which depends of status. Pending - Yellow, Active - Green, Frozen - Blue active - Green .... ....

oh, now it's working fine. ;) thank you.

Hello. Can I make a filter in ListBox, that i see only those records, which have the same Id?

Yes, I used subform wizard to make a new form/subform relationship hmmm, strange, but this your attached files like attached files in my post

ok, i made this, but it not working. i don't have the same order_id in Orders and Works. I don't have order_id in Works at all.

Hello. I'm first time here. I have a problem. Two forms - the one is Orders with field "id", other - Works with fiels "order_id". I form Orders i can record company name an other information. In this form exist ListBox, in which i can see information about company. In this ListBox i can choose...

I attached DB for example. Forms are in Lithuanian, but Orders and Works I tried to translate in English. All ow Works i must see in ListBox. And this DB using Linked tables

No, no, no. I want automatically set "id" number from Orders, to "order_id" from Works, when i make double_click in listbox on needed company. And when form Works opening, the field "order_id" automatically must have "id" number of "Order".

Can i make report with checkbox, that if I want print report only with records, which are selected in report with checkbox?

Hello. I'm first time here. I have a problem. Two forms - the one is Orders with field "id", other - Works with fiels "order_id". I form Orders i can record company name an other information. In this form exist ListBox, in which i can see information about company. In this ListBox i can choose...