Search results

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.

Hi, I have put conditional formatting to almost every field. of course if there is no logic no need to put one. last one that i don't know how to make is this. i want my field to check previous field and if value is same to be red. every value is unique no duplicates and this count only for...

it is set but i can not do it. maybe because my version of access is older i dont have fourth field in custom there are only the first three fields. but ok i will do it creating new form i will need more time but will be solved some parameters here are changed that is it. i will close this and...

Even with this i can not fix it. thanks for try. i will make new form.

in my experience datasheet view was best for work especially because before i copied records a lot so that is why i used split form. i could have a form where i enter data and in the same time have controls for searching. now i don't need that anymore so i really can stop using split form.

I wanted to know why this is happening last option is to make new form. this is sample database where i try new things. probably something is changed. any case thank you.