Search results

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:

I like the second way @MajP with a combo box for the artist. Can you do that for me? Leif

Hm! I got an error message every time I tabbed to the next field in the row. And only if wrote in a new song. I will look in to your suggestion. With my experience of databases that is how it should be done, but I'm not shure how. Maybe I will come back with more questions. Thanks for now. Leif

Thanks @MajP But it didn't take it all the way. There has to be some connection to the artist table, so if I start to choose the artist for the track I will get the artists songs that's in the database and the other way around I have to be able to write in a new artist if it's not in the table...

Thanks! I definitely look into this. Leif