Search results

Thanks @The_Doc_Man They are no longer in use and need to be cleared out. My bad! Leif

Thanks @Pat Hartman Both because you returned but also for the detailed explanation. I have some basic work to do and I will greatly benefit from your views. It can also be the case that @MickJav writes that what I want to do, by putting the artists in a duet in a row in the same row, is too...

Thanks @MickJav I'm very grateful for all the effort that you an everyone else has put in my problem. I've used your latest ERD when i started to build the db all over again. But it's not finished yet. I think I will take a step back and try a little bit harder by myself. While I do this all...

Hi @Pat Hartman I definitely need your help and others in this forum. It's probably just that I'm having trouble expressing what I want to accomplish. I hope you want to come back and help me again. The example in # 30 only refers to MickJavs picture, where I say that my solution with the...

Thanks for your input @Pat Hartman I agree with you that I may not have answered everyone who suggested other solutions, but at the same time I have both with pictures and text and in the database presented what I did, so if you had looked closely you would have seen that in the three main...

Thank's @MickJav I will definitely try this. Sometimes....working with a radioprogram for the moment. Leif

Hi @Pat Hartman I do not know what gave you the impression that I do not want to use subforms. :unsure: The form I am struggling with contains a subform. It is the question that populates the subform that is the problem after I realized that I need to redo in my table relationships and create...

Thanks @bastanu I have looked at that function and it works under certain conditions, like using a query because the two subjects in the where part must be in the same query or table. Then it becomes a problem because I have to compare the names of the songs to find the artists and one song can...

Nice, more to look through. My problem is probably more that I have not worked professionally with databases but have it more as a hobby and that I do not always understand the linguistics in the technical with databases. Then English is not my mother tongue, so there are also misunderstandings...

Hi again @MickJav I'm trying to translate the ERD image (I now know what ERD means) that you shared here to my access database. From what I understand, you also work in access, but I do not recognize the image. What version of access do you have and what settings make the image look the way...

Hi @MickJav I meant that the part where you added for the programs was similar to mine, not the other tables and relationships. I will definitely take a closer look at this. I'm beginning to get it. It would have been nice to look into your database. I understand that the artists appear as it...

Thanks @MickJav Looks a little bit like mine doesn't it? But when i choose songs for the radio playlist how do I know if a song is a duet, like No More Tears (Enough Is Enough) with Donna Summer and Barbara Streisand or Guilty with Barbara and Barry Gibb? There you see my problem. Leif says...

What I want to do with my database is to create a good overview of my vinyl records. Since I use these in my radio programs, I also want to list which songs are included in the programs and be able to search the database for songs that I want to include in my future radio programs. When I...

Yes, I know, but i am struggling with the query and how to display the result in my form. I'm learning a lot o the way....... Leif

I will look in to this and answer it soon. Leif

I don't need to see the word "duet". I want to se who the two artists or more who sings the song. I've tried using dcount() with the name of the song in the function but there are more song with the same name so dcount() didn't work. Leif

OP? :unsure: 🎅

Am I right @MickJav if I interpret your picture above as that you must have both Kylie, Jason and Kylie and Jason as three unique items in the table for artists? Leif

The picture shows the form for all a group's recordings and if I understand you correctly, it would have been shown in the box for "Artist Types" if the group was a duo or similar. What I want to achieve is that for a compilation album that contains a song sung by two artists, both artist names...

Maybe I'm asking really stupid questions but what's an "ERD"? I have created an account on your website @MickJav to be able to download the database called "Disc Jocky Bookings And Music Library" but it is a .drawio file that I can not open. I would be grateful if there is an opportunity to see...