Search results

Thanks both of you, I look into it. Leif

Probably not @Gasman but as @moke123 sugested with adding a space is simpler. As I'm not so god at coding I'm not shure how the code in the NotInList function would look like. So for now I leave it as it is. Leif

Hi! I'll think I stick to adding a space at the end of the titel if I need to add a song with a different artist. It's easier to keep it simple. Thanks for the interest. Leif

I have thought about adding an extra character to the name of the song to differentiate them, but it will not be so nice, I think. But your suggestion to put together the title of the song and the artist sounds like a viable idea, get to think about it a bit. Had another idea to make an index...

Hey! I went back to my old design and created a field for "featured artist". As @MajP and others suggested. Then adding the two strings of text to a field in the form solved my problem with duets. Thanks a lot! But another problem arose. I also do radio programs and the playlists for these...

Of course it worked, thanks @theDBguy But in the end I have to learn coding. Leif

Thanks @Gasman I do understand a bit of the code, but not so much to search for faults. A little problems with the English language too. Thanks a lot! Now I will build a code to update the table........wonder how? :LOL: And I will look at your link :) Leif

I'm not that good at "walking through the code". Actually I don't understand it. Have you any good groundly learning tip? Leif

Hello @Gasman I added the line. Still the same error message. This is the code from the old database. I saved the two databases in 2003 version if you want to look at them. Leif

Thanks @Gasman The old database is attached. The form is here called "Mina skivor" or frm_record2. Test and you'll se that it works. But I've may have missed something. I've think you helped me in the past so you may recognize the database. Leif

Hey! I have created a new database for my vinyl collection, following tips I received from this forum. So far, things are going well. I have some code from the old database, that works with that database, I thought I would recycle that code. It's about choosing a picture for the disc. I have...

Puh! @MajP Then I can go on with your thoughts about the free text fields. Leif

@MajP I've started with the work......where do I put the order of the track on the record? Example: The song Guilty is both on a LP and on a singel, it happens that it's the first track on both, A1. But the backside of the singel (B1) is a song called Life Story and that one is the second track...

Hm! Thanks @MajP Actually I don't know why I did the featured artist field on the album, probably because I then already was thinking of the tracks, so that one goes away immediately. As you say its a 1%. I will try what you suggest and add a featured artist as a text field instead, that will...

Hi @MajP I have now done as you suggest in your posts 82 and beyond. I have created a new database with other types of connections than in my old one. In this way, I have managed to achieve both showing duets in a simpler way and also records with various artists. However, I have not yet...

No problem @theDBguy your input is always welcome, but read my last post before you look in to the problem. Maybe I've solved it? Leif

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