Search results

UPDATE I made a slight change to your code PBaldy and it work beautifuly. I just had to add .Text ============== Me.Filter = "Tri_ID In(" & Me.Cat_Tri.Text & ")" Me.FilterOn = True Me.Requery Me.Cat_Tri.SetFocus Me.Cat_Tri.SelStart = Len(Cat_Tri.Text) ============== So many thanks guys !

Hi PBaldy Thank you for your reply. I have tried this without success. ============== Me.Filter = "Tri_ID In(" & Me.Cat_Tri & ")" Me.FilterOn = True Me.Requery Me.Cat_Tri.SetFocus Me.Cat_Tri.SelStart = Len(Cat_Tri.Text) ============== I was wondering how the IN function...

Thanks Ranman for this piece of code. What I am trying to achieve is to filter ONE numeric column based on numbers (seperated by commas) in a control on my form. Am not trying to search in multiple column. But your example is very interesting though. I will use this for something else ! ;)

Hi, I am using this [On Change] very simple but useful script to filter a continuous form. ================ Me.Filter = "ID LIKE '" & "*" & S_ID.Text & "*" & "'" Me.FilterOn = True Me.Requery Me.S_ID.SetFocus Me.S_ID.SelStart = Len(S_ID.Text) ================ Works very...

I took a closer look at what you did and wow, you really cleaned it. Much better approach ! Bravo !! :) :) :)

Well done ! Today has been a great day ! I've learned a lot :D :D thanks to you guys ! it works like a charm. Union is the way to go and sorting the form did it.

You're right, I've managed to create a copy and purge any useless data (the original database is 37Gb...) Please find the example of my doing in the attached file

Thanks DBguy, unfortunately, I can't post a sample since the data is an SQL back-end. Thing is as soon as I remove the dummy table from my Query, everything work just fine. As soon as I reunify the qeries as UNION, for a reason I just can't figure, it sorts it blanks first and then the...

This is the first thing I've tried. However, the sorting has to be made at THE SQL SELECT. Otherwise am losing all the information in the header. In the previous version of my creation, I had en subform acting as details data in the details section. But in order to fit the example posted here...

All right... I feel am close to the solution... I have created my union query in a module. It works but the result is upside down (meaning that the blank lines are first and then the data). And my report is missing the header on the first page for all results returned that exceeds one page...

Yes, absolutely, I am starting to get the point now. Thing is I never thought of that approach. I'm getting through the link Isladogs posted here. It does the job. But seem very complexe. If it's what it takes, let's try it ! :D Lemme try your suggestion and get back to you with this. To see if...

Actualy I came across this one but I don't think it would fit what I need. I really need to add blank strings instead of crossing data. Unless I really missed something.

Hi there, I don't know if its possible but I would like to add "blank" records in order to fill the rest of the details section of the report. Lets just say for example that I have room for 20 lines in my report. But have only 13 records in my query results that will fill that report. I'dd...

Just wanted to say hi and how happy I am that I found this forum ! I was used to do a lot of simple things in Access but now it seems that I am required to produce stuff that sometimes I would bang my head on the desk... I hope you'll help me to prevent that. loll See you soon ;-)