Search results

Thank you @MickJav I realized that I need to create this middle table. What I do not understand is how I can get the artists on the same line in my forms. I also do not see this in the picture you posted. There are no duets or other songs that have more artists than Toyah. Can you show me how...

Hi @MickJav When I started asking questions in this forum about how to create functionality in my database, I got a question about how I had intended to do with duets, ie songs with two artists. I then replied that I had intended to write the song with both artists. It now turns out to be a bad...

This is what I ordered: "Access 2019 Bible", Michael Alexander, Richard Kusleika "Access 2019 For Dummies", Laurie A Ulrich, Ken Cook "Access Solutions: Tips, Tricks and Secrets from Microsoft Access MVPS", Arvin Meyer, Douglas J Steele I have not received any of them yet but look forward to...

Thanks @NauticalGent do you have a swedish translation? 🤣 Leif

I've commented out the line with "Cancel = True" in the subroutine that calls for the function. After that it seemed to work. The problem was that I couldn't add data to a record without getting a message that the record already exist. Leif

Actually I didn't....

I've got more problems. After I've added the picture in "criteria" in the function that you created for me I can add a new record but I can only add it with these four fields. And if I try to add something later, like a genre, it says that the record exist's. Again I've messed up your code...

Thanks! I fixed this and figured it out as you say above. Leif

Thanks @MajP for your input. I've tried to fix this line by line with help from debug and internet. Now I'm stuck in this line of code. The error message says: Which I interpret as saying I have the wrong property somewhere. Probably in Image because it was not in the original code. Of...

Hi @MajP Today I tried to add the code you suggested. I didn't change it a bit and I got this error message at first and every time I switch to another record. And it comes again when I click OK. What am I missing here? Leif

I think I solved it myself. I noticed that the order of the fields in the function was different than they were when used in the sub so I changed it and then it seems to work. I did not know that it mattered so much. Could it be that simple? Leif

Hi @MajP I need a little quickfix. I discovered that I need to have another field among those that makes a record unique. Together with the name of the album (record_name), the artist (artist_name_ID), media (record_media), the link to the album cover also needs to be unique. I have several...

I took away the line "RunCommand acCmdSaveRecord" and then it worked fine. Wonder what's gonna happened next. 🤯 Leif

BUT! I've still got the error message that "The record doesn't exist". And now it's stopped at RunCommand acCmdSaveRecord. So there is something other than this that's wrong. :cry: Leif

Thanks Mick. That worked with a slight change of code. In the table, the field for the image is called record_picture not artist_picture. Leif

Oops, that was a lot of code. I have been confident in the little snippets of code that you and others have written to me before. But I will definitely test this, it's fun to code! :D But I was hit by another error that I think has with the code you wrote to find any duplicates. I tried to put...

Thanks (again) @MajP I chose a slightly different path. Instead of adding code to handle error messages here, I chose to add a check that the field is filled in in the "LostFocus" event. Here's what happened to Record_name: Private Sub record_name_LostFocus () If IsNull (record_name) Then...

I am thinking of buying some books where I can learn about programming VBA for MS Access. I'm not a direct beginner, I understand how the code is connected in principle, but I do not understand all the new features that have been added in recent years. My programming knowledge comes from Basic...

I think that I get it now. You mean that i can put the code above int the event "Before update". But what about the "Sub Test()" When I call the funktion RecordExist(... I only gets the result for the record "Let's spend the night... So...... Sorry that I'm such a bad coder.

What do you mean by this? What before update? I don't understand the code you presented in your last message. Leif