Search results

Result #Name? But definitly quicker. If I try to run your query in the function below it says: Syntax Error If I run this query: Select * from qry_Concatenate where Music_ID = music_ID; I get a result, but it still says #Name? in the form. I can add the working database later if you want. As I...

Hi @MajP I will soon post the file/files. But I've tried to put the concate function in the field for artist in the subform (frm_record2_subform). When I first tried the function the only way for me to get the function to work is when the argument (eg. the ID-fields) are taken from the same...

I'll post it when I've sorted out all my bad examples. For now I'm not shure what I've done. :oops: Leif

This is a interresting way forward, I will try this in some way. Thanks everyone! Leif

I'm trying to put the concat function i the filed for artist in the subform. So far the result is only "#Name?". I've tied this to but then I Only get the limited group as the result and then I can't view all my records. Leif

This example is from the film where The Bee Gees was the main artist, and many others performed. The Beatles record wouldn't show you what I mean. It's bound to a query. Query1. But I agree with everything else that you say. I'm trying to put the concat function in the subform but at this...

Hi @Minty Of course, The Bee Gees & Paul Nicholas is not one artist. This is what I want to be able to present in a good way. This is what happened when I added the song because I did not have an alternative then. Everyone who has helped me wants the same thing, but I probably do not...

Hi @Pat Hartman This is what it looks like when I look at a vinyl record in my record collection in the database. This is the soundtrack to Sgt. Peppers where the Bee Gees did many songs together with other artists. The first song with Bee Gees and Paul Nicholas is a new entry in the artist's...

Did not think so far, it was wise. It is already done. I will keep that in mind. Sheet music will probably never be a subject that I will work with because I am not a musician but "just" a DJ. There are songs in my record collection, e.g. 7 "and 12" where the songs have different lengths...

Hi Pat, I'm glad you still want to answer me. I have the greatest respect for your knowledge and experience. I agree that much of the job is to plan how the different parts of the database should be connected and in that case I have failed. But maybe you can save some of what is already stored...

I understand and have now removed that relationship. Unfortunately, it is the case that some of the songs I play in my programs are not available as records in my record collection but are taken from Spotify and in some cases from Youtube. So the relationship with a record is not self-evident...

Sorry but the headache is still here. :LOL: You sad that - "Your separation of "music" from "record" makes no sense to me." I understand that it was a mistake to name the table containing the tracks on the records for tbl_music. And it was also a mistake to write song instead of tracks in my...

Sorry to hear that @Pat Hartman But still, with my new explanation of what the tables contain, I would like to see how you would make a correct schedule. Maybe that would make me see my mistakes more clearly. After that, maybe I can move on with my basic problem. Leif

Thanks for your reply @Pat Hartman 🙏 First of all, I would like to apologize again for the names on my tables are so misleading. Now take this in the right way, when it comes to vinyl records I know what I am doing. @Pat Hartman as you write in your first comment you seem to have misunderstood...

I have tried to create junction tables myself between the tables that had a connection to ID fields. I then deleted these ID fields, record_artist_ID, music_artist_ID and music_artist2_ID. It created some errors in the forms but these I am trying to fix. Just hope I can save new records. I...

Thank you for all your input. And thank you @Pat Hartman You are quite right in pointing out that you gave me the solution already last year. But either I did not understand it or it meant too great a change in what I, with your fantastic help, have already achieved. I may have been stuck in...

OK, I'll try to describe what I want to accomplish. At the end of 2020, I had two threads running about this. https://www.access-programmers.co.uk/forums/threads/problems-with-duets.314819/ and https://www.access-programmers.co.uk/forums/threads/duets-or-songs-that-have-several-artists.315102/...

Hi, I'm back! Are there any solutions to the problems of slow response when asking questions to large tables with Alen Brunee's ConcatRelate function? Leif

I have to study normalizing. :) And using the query in the way you suggest, that was interesting. I hope you and @MickJav have agreed, I hate to be the one that got between you two. And I appreciate that! Leif

Don't worry @MickJav I'm thinking of doing it exactly as you say. However, in my list of tracks (tbl_music, (must change that 🤯 )) I have a lot of tracks that I don't have in my vinyl record collection. These tracks, songs or whatever you want to call them is from my radio programs. Sometimes I...