Search results

I like the second way @MajP with a combo box for the artist. Can you do that for me? Leif

Hm! I got an error message every time I tabbed to the next field in the row. And only if wrote in a new song. I will look in to your suggestion. With my experience of databases that is how it should be done, but I'm not shure how. Maybe I will come back with more questions. Thanks for now. Leif

Thanks @MajP But it didn't take it all the way. There has to be some connection to the artist table, so if I start to choose the artist for the track I will get the artists songs that's in the database and the other way around I have to be able to write in a new artist if it's not in the table...

Thanks! I definitely look into this. Leif

THANKS!!!!! So Nice

I found the code you put in, nice. I'll try and connect the arist field to the music field and maybe I can show the artist.

That was quick @arnelgp! What have you done, or was it just a suggestion on how to do it? I wish I could see the artist in the list in the subform. That's why I added an artist field. Now, of course, it only says various artist.

Can anyone help me with this?

A little clarification with a picture. When I have previously selected an artist in the middle of the form, I can then choose from the artist's songs in the subform. If I have selected Various artists (Varierande artist) in the field for artist, I want to be able to select the artist in the...

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

@neuroman9999 With your help when you show'ed me a way to do this I managed to get it right. A little googling and a little trial and error. I've had to create a query to get all the songs on all the record and then these two lines in it's fields shows record name and record media...

In the swedish version of Access it will be a semicolon. Maybe someting about translation? Wonder what happens when you use it in the code-section?

Sorry, didn't read your comment at the end @neuroman9999 Yes in a way it's true. My wife and I have two cars, she takes the car to work every day but I ride a bike. When I inspect my car, the inspector always points out that it has not gone that far. The same is said when it is in for service...

Thanks @neuroman9999

@neuroman9999 Okay, I think I almost understand. I wrote this in the control source for the field where I want the name for the record. "= dlookup ([record_name]; [tbl_record]; [tbl_record]![record_ID] = [music_title])" And the result is that all the fields look like below. In this example...

I feel stupid. I cant put the code "in the field". Probably it should be in the code section or in the controlsource of the field. But more exatly where? Leif

@neuroman9999 I've looked at the funktion but I'm not shure about how to use it in the form. can you explain further? Leif

@neuroman9999 I've looked at the funktion but I'm not shure about how to use it in the form. can you explain further? Leif[/code]

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

I now understand why this happened. In my eagerness to remove features that I did not think were needed, I found that you could remove the ability to sort the list in the subform. I did not realize then that the possibility of using hyperlinks disappeared with this. Maybe I'm trying to recreate...