This example demonstrates a way to sort listbox columns in ascending and decending order, and how to programmatically narrow a search in any field of the list box.
OldSoftBoss, ive been using your example posted hear and adapted it to suit my DB, is there a way that I can ajust the coloum widths in the list box. Ideally they need to be dynamic, i.e to auto adjust as information was displayed. Thanks!
Just to let you know that Ive been impementing parts of this into my own DB, personaaly I think its so much better than a subform. The sort function is excellent. Im still woring on the resizing function. Two questions though;
1. Can I create a report from the results? As I had it before with one query it wasnt a problem, now when I sort its using different queries.
2. How can I show how many records have been found in the search?
OK I understand the count function, but with the report I have one button to open a report, but because the list can be based on a number of different querries it dosent know which one to look at. i.e I can click on the lbls and reorder decending or ascending , so the list is now looking at a different query. How can I tell it which one?
Quick Question on this guys..I more than appreciate what you've done OSB however, I need a simple Search Form and I was wondering what files would I need to delete and which query would I edit to implement and alter this to my fashion...I have already stretched the Search box and moved it to my liking...I just need to remove the other files that aren't needed for a simple project..
Quick Question on this guys..I more than appreciate what you've done OSB however, I need a simple Search Form and I was wondering what files would I need to delete and which query would I edit to implement and alter this to my fashion...I have already stretched the Search box and moved it to my liking...I just need to remove the other files that aren't needed for a simple project..
Hi - the query you need to edit is: "qryCDNoAsc" that is the one used to populate the list box when the form first loads, the others are only used when you click on the labels to re-order the list.
Hi Have attached a cut down version you could have a look at - and also incorporated a few other ideas i have picked up from this site.
I have tried to modify your example; however, I can't get the search function to work in my version. Does it only depend on the txtSearch_Change() procedure or is there any other code that I have missed.
I wanted to view different forms using the same list box. For example the user can select from a combo box what form they wanted to open. I am not sure how to do the 'Raw source type' bit.
I created a query for each form i want to run and then wrote an if Statment that runs a query depending on user's selection. How do you get Row souce type written in VB?
thank you Oldsoftboss, this has been a real help, its just the kind of search i been trying to do ............................. but, and there had to be one lol, i cant get my links to work from within the search, is there anything you could suggest please?
thank you Oldsoftboss, this search is great, i been trying to get something like this to work for a while now, but ....................... and there always has to be one, there is one problem, the search is working perfect, however, i cannot use my links when they are in the search result box, is there a way around this please,
Well done Oldsoftboss, this is a great little tool. One question, how have you been able to change the colour of the text box txtSearch when it has the focus? I can't find any code for it! I'd like to give it a different colour - this would have numerous other uses!!