Search results

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

He he @onur_can When I have access maximized, it works as it should. But I have chosen to start the database with a menu form and access minimized and then the menu where the hyperlink dialog box is located don't show upp when I dubble click. Should it be so? Or is there a way past this as...

Found it! THANKS, you saved me a lot of work, not to mention the time I was looking for this today. This forum is the GREATEST. Leif

AMAZING! Now I'll look for the difference, or I'll just use the one you uploaded. :) (y) Leif

Yes I understand that is in the propertys of the Form, but wich property? I can't find the one that you named "shortcut". Leif