Search results

😂

This actualy worked, but I've then got other problems that I must look into. Leif

Good hint, but it was already turned off. Leif

In my database that manages my record collection, I have an album form. When I add a new album, I select the artist from a combo box that is linked to a table of artists. If the artist is not in the table, a form for adding a new artist will appear. Now to my problem. Adding an artist whose...

Hi @MajP Tonight I've noticed that my original tables are more complete then the one that you split. Exactly as you pointed out. This I'must do something about. Can I split my original database and use that back end with your front end? I've tried that but it doesn't seem to work, I'm getting...

Of course, it is best to make a split database. I'll look at this the day I have a database that I'm happy with. ;) What below? Yes, and so it is in the query but something changes that. No I've sorted it in the form. It works. The junction table for artist - record is gone. I'm happy with...

Thanks @MajP What did you fix? I dont see the difference. If you mean the sort order [qryRecordSubform].[music_ID] that didn't fix it. I've change it to: [qryRecordSubform].[TrackSort1] & [qryRecordSubform].[TrackSort2] so now it works. The split is interesting, I've read about it. But I...

I know!

Hi @MajP I like the tree view. It gives a different picture of my record collection. But I wanted to be able to look at the tree view from the record not just from the artist. It is good, however, that you can choose the forms based on double-clicking on a song or artist. I think I have to get...

OK, I understand. Tested MM now and it fetches a lot of information by default. But I think I like my layout..... :) Have a nice weekend. Leif

I'm amazed! You've imported my database into Media Monkey. I'm really have to look into this further. Thanks for the hint. Leif

Thanks! I've done a quick look before i went too work, it looks nice. I will fix the color schemes, no problems. Then I will try and use your code and your new "add artist form" on my other forms where I need to add artists. And of course I will try and change all of the names to be more easy to...

I will definitely test this when or if you have finished the work you are doing with the file now. No I do not use media Monkey or iTunes either. I'm not an Apple person. :) But I will try to watch MM to get inspiration for the layout. I'll hope you get the time. 🙏 Leif

I'm not really sure how to act on this. But I thought it was wrong of me to go in and change the tables while you @MajP were creating things in the database. I was afraid that I would then change something that would make the solution you presented not to work. There's no excuse on my part...

I did not perceive MajP as snotty, however, he was willing to help me.

Looking forward too this @MajP I know that my naming is a bit confusing for others and don't follow expected rules. That's my beginners fault and a bit of lack of experince. I've tried to change them a while ago but then I've ended up with a corupted database so I've skipped it. Is there a...

Yes, yes, yes. It's an older version. This is the version I got help with about a year ago. I posted it because I wanted you to see what it looked like before I started adding what was suggested in this forum. My problem in this version was just adding tracks performed by more than one artist...

You're so quick. I'm amazed. Thanks @MajP Haven't had the time to look in to this yet, the time in Sweden is 7:30 PM and I think it would be the night shift for this. I'm so curious. This is the file containing my working database. Look at the difference between the relationship schemes, then...

Nice! Thanks, swedish? Yes, for now there's only these two. I'm hoping to be able to add tracks directly with two or more artists on. When I search for the song I get the tracks doubled? I downloaded your file. Same result. Leif

Perfect! Some issues is yet to overcome, eg. how I can add tracks to a new record as artist or as various. But this is one step forward. Many Thanks! Leif