Search results

here it was faster than i thought

ok i will try tomorrow to translate it to english only for that field to make it work

here is with code and i know if i start from beginning I would do it different.

here i recreated it with macro.

But i don't have that version anymore i rewrite it and defaultvalue on the combo box worked when was with macro when i added code then all mixed.

here what i found. i deleted default value in data tab on the combo box and now code works. filtering is ok. will try to put default value on form loading. i guess this can be considered solved.

so to try your code what should i put in NameOfAnyNotNullColumn not sure which name is this

there is no null value all date fields are populated

i tried treating it as number, text, date same result. not working

Hi, I have form with few combo boxes. afterupdate event were with macros so i decided to change them with code and add message if record is not found. i fix all except the one for filtering records by year. macro was like this ="[Godina] = " & "'" & [Screen]. [ActiveControl] & "'" and worked. i...

Thank you for all suggestions I finally did it now works with all conditions.

June7 was right i have code twice in the module and in the form i don't know how it get in the form maybe too many version one by mistake end there. i deleted code in the form i now checking one by one 348/349 like is fixed only left transfer fields with double values like 349/2016 79/2019

here is last code Public Function IsTransferValid(DocNumber As Long, Transfer As String, DateOfReceiving As Date) As Boolean On Error GoTo HandleError Dim parts() As String Dim startDoc As Long, endDoc As Long Dim thisYear As Long Dim rs As DAO.Recordset Dim dateStart As...

i don't know how many versions i have tried i have new code but still code not work. queries i tested work perfectly but code no. here are two queries first: SELECT d.* FROM tblDocuments AS d WHERE d.DocNumber = 347 AND Year(d.DateOfReceiving) = 2016 AND d.DateOfReceiving > ( SELECT...

i don't know how it meets criteria but should not. first record in red 450/460 is red and is true because is not 450/451. 348/349 is true because there is a record with docnumber 347 between docnumber 348 and docnumber 349 so should not be red. if record with docnumber 347 not exist between...

about subnumber. each docnumber means document about something like file for something. if that same file continues next document will have same docnumber but subnumer will rise it means first is with subnumber 1 which means first document next is second etc so in the example with docnumber 347...

yes frmDocuments display form on opening shows in red with conditional formatting mistakes made when entering data. it is to know that is not valid and should be fixed. when mistake is fixed red disappear. conditional formatting is based on the code in module1. however for this record and...

sorry for delay i have been absent. maybe is best to show you sample database. this database with conditional formatting shows in red field {transfer] which is with mistake. however all conditions work except the last one. like in the query range of records make problem. you can see record with...

Thank you.

no error mistake this time but return zero for 2, 3 and 4