Search results

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