Search results

i modified to : DCount("*", "[MRN_number_Of_PO]", "[Location - Clinics Code] =" & Me.Combo2 And [Year22] = Me.Year1) but still same issue error "type mismatch"

please find attached file

file attached

hi thanks for helping, but still getting error .

I need a help: i have a form , i need after update clinic, it will Dcount all record from in field "total". so i tried belwo code but still getting error: Me.total= Nz(DCount("*", "[MRN_number_Of_PO]", "[Location - Clinics Code] =" & Me.Combo2 & " and [Year22] = " & Me.Year1), 0) Also Dcont...

but if i want the show msgbox " no record found" and set focus on "Findcode".

HI i Have a form which filter after entering code number, as code below; but i wannt to show msg box if no record found and cancel filter, how to modify the code below: Private Sub filterThisForm1() Dim strFilter As String On Error GoTo err_handler If Len(Trim$(Me!Combo79 & "")) Then...

Done, i did as the code below, worked fine. If Me.Delivery = 0 Then Delivery = Nz(DMax("Delivery", "PO_Date", " Link_ID = " & Forms!Data_Entry!ID), 0) + 1 Else End If

thanks but what if a new record in subform has a new ID of main form, then wanna cycle start again from one .

Dears; I have created a form "Clinic" and sub from "Delivery_Number" , there is a field named "Delivery" , user update "Delivery_Date" so I want this field "Delivery" to auto update with serial number starting from (one) after updating "Delivery_Date". repeat the cycle with every new record...

can you advise about it

Dears; I need a help, I have a form named : clinic Subform form: Delivery_Date so there a field in clinics form named (Number of delivery) , so i want to limit the number of record in subform based on the number in main form. for Example, if (Number of delivery) = 3 then the user can add only...

Dears; Need help, How to filter the query to show only last record by date, as the filed name DATE_. thanks

Dears; I have a table" Listing_of_documents_of_Purchas" I created a query named " so I need to add a column in the query to get the number of record with status "pending" . and Voucher1 match each other . i tried below but not working. as take long time to run. Pend...

i got it, , but i want now to apply this after update.

thanks , but i need also to search also in "Other Code" . and is there a way to filter after update.

Please find the correct file attached, as i Update the filed "Code" so need the form to filer for item code and other code. as i need the filter to be applied in the form only.

Find the database in link below https://www.access-programmers.co.uk/forums/threads/filter-between-dates.324311/

Thanks for explanation. Yes the form is linked to subform. As there is 2 criteria to filter the for by ited code and other code. When the user enter the code in text field then, will filter the form to that record. As the subform has other data related to item code. What I want is that when...

thanks alot: I applied this code to filter the form after update, but it filter both form and subform. how to modify it to filter form only. Private Sub FindCode_AfterUpdate() On Error GoTo errhandler ''n = 1 / 0 ' cause an error Dim strFilter As String strFilter = "" If...