Search results

Good advise problem is that i am beginner haven't learn about vba yet so i still trying to guess right way. and about fields i think no need to check. As i said i have few combo boxes. each combo is for number or text or date only. one for numbers other for text etc.

It shouldnt? works perfectly with no mistake.

I have few combo boxes so there are text, numbers, dates. in the example i tried with first combo which is number.

I tried few different ways none worked. last attempt was with this code: Private Sub Combo13_AfterUpdate() On Error GoTo Combo13_AfterUpdate_Err DoCmd.SearchForRecord , "", acFirst, "[Number] = " & Str(Nz(Screen.ActiveControl, 0)) DoCmd.Requery "" Combo13_AfterUpdate_Exit: Exit...

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