Search results

Thanks for your help. Will try that.

Hi there. I know you all mean well. I will sort out my database again. But for now I just would like to solve that small little issue. Any other suggestions how to solve the problem. Much appreciated.

There were no trailing space. When I insert name I left a space. I checked. You can see in image. Still same message appear

This is in a txtbox ResultPromote in the detail section of a REPORT =IIf([total subjects]<7,"U",IIf(([IsiXhosa Home Language]>=40 Or [English Home Language]>=40 Or [Afrikaans Home Language]>=40) And [AmountSubjectsFail]<2,"P","NP")) I need to count each of the conditions. These are placed in...

Maybe you guys can help me fine the error when I am scanning and it does not sort in DESC order by returned date. Thanks for all your assistance guys.

Hi Gasman. Normally we scan in books without learners being present and we just scan in the books back into our textbook control program. If a learner brings the books personally we do have time to scroll down the list and check if the book is theirs or not. The last book scan must there be the...

Hi. Gasman good morning. I have tried that and order the query by date/time. Scanning list box is filled with a query ordered by date/time descending order. But for some reason the last item did not always go to the top. That is why I had to try an alternative method. Thanks

So let me explain what happening here. I scan the book in via a book code. The book codes picks up the details of the book which is displayed in our search box(Listbox with bold font) which is automatically move the record to the destination list box(below the scroll bar) in the first position...

Thanks to all your solutions. I have finally solve that puzzle of putting it into first position.

No, the destination list does not get cleared. I will only clear it when I scan in a new set of books. The destination list combines all the single list of books scanned. Everything works correctly. All I need now is the last entry must appear first in the destination list. This might not make...

Hi. The actual application scans in a book. The new book is in the first position. Then I want to put that book details in the destination list. The next book we scan which will be a different book is also in the first position then we add that book to the destination list. So we build a list of...

Not sure if you can manually delete while program is running. Or you can put in a button to remove the first element if that will work and try adding records to destination list again. Thanks for assisting

Thanks Gasman making that clearing that up. So all i need now is the first row must appear in the destination list. What you can do is. Press the select button add the first row to the destination list. Go to the Selection list and delete the first row manually and press Selection again. In this...

Yes, you right. I need code to place the new element of the top of the list every time. Any code that you think will work. Please send me updated solution please. Thanks

Can you send me the updated solution where you code these please.

Hi MajP. Thanks for the code. I will try it out.

Hi Gasman. The first row in my real application is always different. In the sample DB it stays the same. I hope you understand.

What you can solve for me know please is that when I make selection it must go to the top of destination list and not at the bottom please.

I have posted the solution database

firstItem = firstItem & SearchList.Column(i, 0) We just had to change the 0 to a 1 firstItem = firstItem & SearchList.Column(i, 1) End Sub