Search results

Dear Guys need help, I have query that have combined table, so have create another query and i want to make an expression to get the data from that query based on 3 criteria. i tried this code Query Name : " Calender Query" need add expression to get the data from MRN Query1 Expr1...

Dear Guys, need help i have a form a need to go to record upon double click in list, i tried below code but not going to record as the record is combobox. On Error GoTo errhandler: n = 1 / 0 ' cause an error 'Move to the record selected in the control With Me.[Combine...

Dear guys need help I Have a list in a form, once you click on any items it will go to record in the form, but if there is no record it go to first record, so i need that if no record then show a message " No Record Found" i tried this code . Private Sub List6_DblClick(Cancel As Integer) On...

yes

I tried but only filter the first combo but for second not working

Dear gyus, need you help I have a form that have2 comobox, so combo1 and combo2 one i filter the date with combo1 then need combo2 to filter current fitered data instead of all data again. On Error GoTo errhandler: n = 1 / 0 ' cause an error 'Move to the record selected in the...

solved thank you

thank for help. can you please do the change in attached file, i tried but could not solve it.

Dear Guys need help with D sum function. I have a query and added extra field where i want to get the sum based on 2 text criteria (item code and company name) i tried this : DSum("[Link Value]","MRN","[Item Code]like""" & [Forms]![MRN Query]![Item_Code] & """ AND [Account Name] like """ &...

thanks alot done successfuly

thanks alot work successfully. but now i want to add additional criteria based on "item class" in combo box named "type" how to do it

i tried this but it show me 0 but in reality's there is many record .

ok but how to do it please

Dear guys: I have Main form named "Statistics" and table named "pt data" Due date Date2 = date Time2 = Time Number of Rx text box. button11 so i want upon clicking the botton11 to count the number of record in "pt data" field " due date" with criteria more than Date2 and time2.

resolved thank alot exp_date = Format(Now() + BUD_Time, "short Date")

yes past midnight today

thanks alot work good but if result exceed 24 hours then update exp_date to next date. how to do this

Dear guys; I have a problem need help please , i have following field : Time = Format(Now(), "short time") BUD_Time = (Time entered by user in hours) exp_date = Date Item= product name so i want when user double click on exp_date then do following action: Private Sub...

Thank you that work . but this code also add a blank record if no data there in the field. so my question can we modify the code and if blank will not add to record and show a message that there must be a data to enter.

I corrected the debug with with. But Instead of copy the value in subform. I need to copy the value in statistics table. Actually I don't want a subform in main form.