Search results

Hi Now I have solved the problem with searching for my records based on the artist and managed to sort them correctly. Almost in any case. Of course I used cascading combo boxes as you suggested. I tried an alternative solution first but here I couldn't get the sorting correct. Thanks...

Cascading combo boxes would solve my problem. But as it works today when I only select the artists from the artist table and with a connection to record_ID sorted by release year, I get all the records that that artist has released and that I have in my collection one after the other when I...

Fix this by changing the order of the tables in design mode. But now the artists first record doesn't come first, so there still things to fix. Thanks for today.

Your code works @arnelgp. I've managed to fix the missing punctuation. But now I've only have the result from the first field in the combo box, the record_ID. This is despite the fact that the bound column is number two. When I change to one or three, it still doesn't change in the combo box...

Thanks @Pat Hartman I will look into that. But it's a bit to change then...hm.

I have a drop down combo at the top of my form for my vinyl records where I can list the artists. This has worked for a while, it was you people that helped med get it right. But I missed an artist that only apeared in a record with various artists. So i had to fix so that even those artist got...

YES!

Yes that would do it. But I need the Record_ID as a result in the combo box as it's the record of the artist that i'm looking for. And the release_date for the sorting of the records of that artist. But it could probably be done in some other way.

Hey! That was almost embarrassingly easy. Thanks. But when I try your SQL statement as a row source in my combo box, I get the following error message: The SQL statement I entered looks like below and it works as long as I'm in design mode. SELECT...

Hi! I have a question regarding the appearance of the dropdown list for a search function. I have collected the fields I need for the search in a question, see image. Now I just need to make the list distinct so that the appearance in the dropdown list does not contain more than one example of...

I'm totally with you there @isladogs . As you already understood it's only the image that's on OneDrive. Have a nice day. Leif

It was not a space but a TAB character in front of the text in the posts. So it's solved. Thanks for the code arnelgp! Leif

A funny thing is that I can't just delete the spaces from behind. Then the last carachter disapears. I'll have to copy the post to a text editor and from there copy and past it back. Leif

I Think I've solved it. There was some spaces at the end of the post. I will no try to rewrite the rest and se if it's solves everyone. Thank's for the replies. Leif

I've tried to rewrite some of the posts whitout any luck. Leif

The second one. Leif

I am having trouble sorting a table. When I choose to sort it alphabetically, it comes in two parts. First there are about 500 records in one part and then the remaining about 13,000 records come in a separate part, but in the same table. The picture shows when the first part ends and the...

Thanks both of you, I look into it. Leif