Search results

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

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

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

Hi! For some time now, I have been struggling trying to create the best possibility for my database to contain duets without creating duplicate entries in the table for artists (tbl_artist). The best way to create this possibility I think is with a junction table between the song table...

Hi! How do you handle this best if you want an artist table that only has unique values without duplicates? Duets such as No More Tears with Barbara Streisand and Donna Summer or Lady Marmalade with Christina Aguilera, Lil Kim, Mya and Pink. These four are listed as solo artists in the artist...

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 idea to do...

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

Hi @MajP . I need to know if a vinyl record is already in the database, I have some duplicates and they do not need to be in the database twice. But I have not found a way to create a key that works for this so I thought of using your FAYT for it. I changed the field for the name of the record...

Hi @MajP I have trouble saving new artists in one of the combo boxes on my form. This applies to the form frm_record2 and the combo box called "Kombinationsruta25" and is located at the top in the middle of the form. The other that you created and is in the original position hidden and only...

Hi! A while ago I got help creating forms for my database for my record collection. Among others, @arnelgp and helped me a lot. Now I have started to put in my vinyl records and then I realized that I made a mistake when I wanted to be able to choose the songs after the artist of the record. I...

Hey! I have a new question regarding my database that several of you have contributed with tips and code to. The basis of the database is an excel file where I entered all the songs I used when I made my radio programs. The idea with the database was to catalog my vinyl record collection and...

Hey! In the form frm_record2 I have a subform that contains the songs on the disc. Previously, it was possible to add a hyperlink to the recorded song on my hard drive by right clicking in the field. Something happened when I experimented with using the FileDialog function. In the end, I...

Now that my database is almost finished, thanks to you in the forum. I have now started to add vinyl records and radio programs. I thought I would spice it up with some nice features. I have created a start form and hidden the access program itself. I thought it would have been nice to have the...

Hi I'm back! I have now fixed the errors I made on the form that @arnelgp helped me with. Now it works and I have continued to add more vinyl records to the database. As I told you before, the basis of this database is an Excel sheet with music in my disco radio programs on Halmstad's local...

Hello I'm aware that I'm a little assertive when I post this as a new thread in a new forum. Previously, my question was in Forms with the name "Problems creating entries in the" wrong "table". With the help of @arnelgp, among others, my question was solved there. But my continued work with the...

Hey! As you can see, I'm new to the forum and have not yet read through everything in here. I also suspect that my question may be due to a misconception when I created the database. I have created a database in Access (of course) that handles my vinyl record collection. I searched for a long...

I'm an IT nerd at the hobby stage. I have used computers since the late 70's and worked with IT in parallel to my job as a technician on the radio and as a radio host. In the latter part of the 90's, I changed jobs and then started as a teacher in a radio education in high school. Of course, we...