Search results

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...

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...

hi, I have a problem. My fields with conditional formatting are lighter then other fields look l ike they are selected. here i will send a screenshot. can someone tell me how to fix it.

Hi, I have a lot of reports. What bothers me is why with some reports i can use gridlines with others not?

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...

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...

Hi, I have field [Transfer] (text field) like this for example 349/2016 79/2019 i want to get four parts like 349, 2016, 79 and 2019. i got first and can get the last too but how to get 2016 and 79. one more thing if field is only 349/2016 i need only 349 and 2016 so what i will get for part...

Hi, I have split form. On opening default cursor position is on the first combo box in form header. Can default cursor position be in the first field instead. thanks

Hi, I have union query and sorting not working. same expression in select query do the job but not in union query. expression is ORDER BY Left([Field],4), DatePart("yyyy",[field1]), table.Field2, table.Field3 what is wrong.

Hi, Is there a way to check and repair links to pdf files. I don't mean manually one by one. Thanks

Hi, I have a split form with few combo boxes. I want to get message if search find no records. How that should be done.

Hi I have report with date field from which i get range with min and max. result is ok for example i get result 2017-2023. problem is that when a range is only one year i get result 2025-2025 for example. how do I get simple value like 2025 only instead of 2025-2025.

Hi, I need to insert record in the middle of table. I do it with copy paste. that way I get two same records of which I use one to edit and make it new record. Can that be done automatically. I don't know coding. thanks

Hi I have form that search records with subform. it works perfect if there is not empty date field. if there is empty date field each search return the empty date field too. how to exclude empty date field. thanks