Search results

I've tried that and it works. This stops me from enter a duplicate. It would be nice i I could get a messages that showed me the post that is already in the database. Is that to much to ask for? :unsure: ;) Leif

Should I try to make a composite index för these three fields?

Thank you @MajP for the input in this subjekt. You've found my real problem. In the table, it is no problem to find duplicates, but I want it to appear in the form if I try to enter a name of a record that has been used before, for the same artist and with the same media. I managed to create a...

Hi @MajP . I need to know if a vinyl record is already in the database, I have some duplicates and they do not need to be in the database twice. But I have not found a way to create a key that works for this so I thought of using your FAYT for it. I changed the field for the name of the record...

Thanks @MajP I suspected it was your "fault". ;) Like I suspected that a requery was needed, but I was unsure where I should place it to be right. I had tried to do a requery on the combo box but it did not work at all. Now it works as intended. And I'll try to add FAYT to that box. I need to...

Hi @MajP I have trouble saving new artists in one of the combo boxes on my form. This applies to the form frm_record2 and the combo box called "Kombinationsruta25" and is located at the top in the middle of the form. The other that you created and is in the original position hidden and only...

Thanks for the clarification, I thought it did something like that. But with the new code in the query that sorts the items it will still be in the right order, but not at first. I think! I have a few thoughts left that i will return with. In the mean time I will concentrate in adding records...

I've deleted "Me.Requery" in the example from my database below. Now it jumps to the next track when i add new songs to a record. @MajP But I wonder what this does that I've not yet discovered?

Fantastic, I managed to convert your code example into the Query1. Thanks AGAIN @MajP Any thoughts on the second question? Leif

Hi @MajP Now I have continued to add records to the database and it works great. However, I have discovered two things that are a bit annoying. One is that the tracks on the discs are sorted a little strangely if there are more than 9 tracks on one side. As the picture shows. Is it possible...

Thanks, again and again. I was probably too tired last night, I've looked so hard for a way to sort the subform that I missed the simplest one. I've learned a lot but has still a lot too leran. You fixed my error. What was the problem with the message box that I got? If you like to listen too...

Thanks for the input, your view over the tables and relations looks a little bit too much for my project.

Hello @MajP I've tried it and I'm so satisfied! I even managed to copy some code so that your button for adding artist no longer is needed. Good by me, I think! But then everything went wrong. I've tried to sort the field music_record_musicorder in the subform so that the tracks get in the...

Thanks. Now I have something to do toninght. ;)

Hello @MajP Now I've looked into it a bit. And it looks promising. (y)🙏😀 I have tried to add a song to the album Thank God It's Friday with an artist, Pattie Brooks, that wasn't in the list. The artist went fine :) but when I've tried to add the song the form "frm_new_music" turns up, that's...

I can't wait untill I've looked at the file. At work know and in the eveneing I work at the radiostation, looks like I have to do some nightwork here. :D

I forgot one thing. I'm still having trouble updating the fields that are blank. But it only happens before they are saved, if I return to the line later and add e.g. length for the song so it goes well. This applies to length, release date and music file. I also need to be able to add new...

Hi @MajP The best is very good! 🙏 :) Now I have added, or tried to add two discs to the database using your form. First, I have to say that I like my appearance on the subform better, but it's more of a formatting issue than coding. Though you have chosen a different way to add records than I...

Thanks again @MajP. The weekend is occupied with other things than databases bat I try to take a closer look at it on Sunday. Have a good weekend! Leif

Thanks! I have a lot of compilation records....:eek: