Search results

your suggestion is ok it works when set limit to list properties to yes but i want customised message box.

here how it is look like when nothing found only this example is with text boxes instead of combo boxes.

If nothing found i have only one new record.

i got no message i want to add one when nothing found.

I suppose it should be some iif statement in the after update of the combo box?

choose from combo box or write to it. I must say everything work just fine just want some message to appear to look better and show what is going on.

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.

I solved it. it shoul be like this IIf(Year(Min([EnterDate]))=Year(Max([EnterDate])),Year(Max([EnterDate])),Year(Min([EnterDate])) & "-" & Year(Max([EnterDate]))). need to switch year and min. thanks

Report is based on query. expression =Min(DatePart("yyyy";[EnterDate])) & "-" & Max(DatePart("yyyy";[EnterDate])) is written in the control source

now with correction do not except it all.

I got message wrong number of arguments.

EnterDate is the name of field.

I use this expression =Min(DatePart("yyyy";[EnterDate])) & "-" & Max(DatePart("yyyy";[EnterDate]))

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.

in my table id is hidden and no important to me. i need to insert record because that order will be impossible to get with query. so i select record where i want new record, select rest of records copy them, select again one record lower and to end of table paste and I have two same records in...

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

i have main form which on load open subform with all records. there are comboboxes for searching. can be searched with single or multiple comboboxes. in this case search should show only last two records without first one. date field is empty next to red field (conditional formating). for...

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