Search results

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

i made them like this Left(Transfer;InStr(Transfer;"/")-1) Mid(Transfer;InStr(Transfer;"/")+1;IIf(InStr(Transfer;" ")>0;InStr(Transfer;" ")-InStr(Transfer;"/")-1;Len(Transfer))) IIf(InStr(Transfer;" ")>0;Mid(Transfer;InStr(Transfer;" ")+1;InStrRev(Transfer;"/")-InStr(Transfer;" ")-1);Null)...

i made modification of example kitayama send and it works. response from Cj_London came after that and i looked at it (always can learn something).

Hi, I am trying to make query that will filter range of records. how this is not with maximum and minimum i tried with between same like with date from to but that way i get only first and last not the records between record with docnumber 347 like in this example can...

thank you and there are always maximum four parts can be two or four parts. I tried yours too but two, three and four don't work