Recent content by quest

thank you i will try that version also.

understand it is logical but why it give results no mater autonumber has gap or not. i am testing all the time what i am writing for results for this sample database autonumber sequence is 14, 15, 16, 17, 20 yet it is still working.

thank you i will study it.

so do you have some suggestion something that will work better

actually start working now like it needed time to start working.

yes i have autonumber field as primary key. i tried few different expresions none working. here is one [dtmDatumNaPriemot]<Nz(DLookUp("dtmDatumNaPriemot";"tbl_Boleduvanja";"BoleduvanjaID=" & [BoleduvanjaID]-1);[dtmDatumNaPriemot]-1)

thank you i wanted to compare with previous record to show me if new date isn't correct that means new date should be equal or bigger no smaller. smaller is mistake that is why should be in red.

conditional formatting for text field solved can anyone help with date field?

Hi, i am lately little obsessed with conditional formatting. i have two fields that i can not do (not sure how). first is that field in the new record (date field) should be equal or bigger than previous record and second is text field that shouldn't be different value (from three rows in the...

yes that was what i wanted. bingo. thank you.

my form is updateable i mean nothing is changed when i use red it means something need to be fixed so when i change that value and new is not duplicate red disappear

i tried something like DCount("*";"tbl_Boleduvanja";"[YearSearching]=" & [YearSearching] & " AND [Dokument]='" & [Dokument] & "'")>1 this didn't work this one too DCount("*";"tbl_Boleduvanja";"[YearSearching]=" & [YearSearching] & " AND [Dokument]='" & [Dokument] & "' AND [BoleduvanjaID]<" &...

i will read these later but now i need help. here is the database. same value, same field two different records. it is about field with hyperlinks (Dokument or Документ) and not last two fields Where this field for two records has same value.

here is screenshot of this little database with all conditional formatting. help i need is for the last field (hyperlinks) where this field for last two records has same value. if conditional formatting works value in the third record in hyperlink field should be red.

can you elaborate that little more i am not at that level it is to complex for me. for now i understand that i should add field in the query on which form is based.