Search results

I think I have found a small part of the problem. @MajP Your function FindAsYouTypeCombo caused options in the table to be displayed when entering and this resulted in none other than those already in the table being displayed. When I removed that feature, it worked. At the same time, it was a...

Alright @Gasman Understood Thanks anyway. Will anyone else take on the problem? @theDBguy ?? Leif

I post the file for you @Gasman The form is the one called frm_record2. Start it and left click in the field for "Artist / Grupp". The reason is to add a artist to a song, but you can do this in a field that already has an artist too add another one, just for a test. When the message box...

I have now taken a closer look at it. And it works if I add an extra character that is not in the table and then delete it in the "NewArtist" form. When I close the NewArtist form, the new artist is added to the table, but in the combo box it still says "Leif;" and I can not "choose "Leif". A...

😂

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...