Search results

Tonight I've used the subform subProgramMusic that you created @arnelgp in my form frm_program and it work like a dream. Both adding songs to old programs and creating new programs and adding songs to them. Still struggling with adding dates. Leif

Hi @arnelgp New file to work with. No change of form or code. I have used the weekend to, using the forms you made, add songs to the programs. It has worked extremely well. But I miss the ability to switch between programs using the record selector. And then also the possibility to see what...

OK @Gasman I have not been affected by this before as I often work both in the parent and in the subform. Maybe tht's wrong, but it has not been a problem. Leif

Same message is in the file you've posted yesterday. Leif

@arnelgp In your new file I was trying to look in to the subform subFormProgramDate but when i started the form I've got a program run error 2452 with this text "The expression has an invalid reference to the parent property" I dont know the importance of the message, The form works fine i I...

Thanks @arnelgp When I tested it last night with a new program it stored both number, titel and date in the right tables and got the few songs I put in right as well. So I think you got it right the first time. But I look in to this version later today. My programs are made for about a month...

Really @arnelgp It's 2020 and MeToo rules the world! :LOL: The form is interesting and wow you're quick. A small change if I may! The programs are the essence of this. The dates on which they were broadcast should be linked to the programs. Now it's more that you choose the date to get a...

With "change posts" I mean when i go to the next record in the form. Because my version of Access is in Swedish posting the messege won't help. But it says exactly the same thing that is in terms of the question I created. Something like this: Enter parameter value...

Sorry for that @Gasman I'm apparently not that patient. But of course understand and should calm me down a bit with my demands. When the database is here, I do not feel that I can add any records to it, hence my impatience. I have updated the database with code that makes the two combo boxes...

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

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

My bad @arnelgp When I made the file "english" I've deleted a object on the form that you used in your code. I will try to fix this in the morning. So my fault intirely! Leif

@arnelgp After you've done "some modifications" there are some problems with adding songs that are not in the table tbl_music. And I've lost the possibility to add order of the songs on the records subform. I You would look at this I would be greatful. Leif

Now I played a bit with the form frm_program. I have removed the questions for the two subforms that @June7 suggested and created subforms with the design tool. I still want to be able to add new programs and songs to these programs. I had an idea to choose an artist and then choose from the...

Thank you @plog for your accurate and thorough analysis. I can do nothing but agree with you. I searched for a long time for a database template online for my record collection but I needed to add the management of my disco programs so I could not find anything online. Finally, I started this...

But @arnelgp fixed the subform frm_record2_subform to frm_record2 and that subform has the query "Query1" as source. He fixed a form that adds records that are not in the table. So in some way it's possible. Leif

@arnelgp What happened to the Side/Track order that i could type in before. Leif

@arnelgp By the way what happened to the first two posts in the table tbl_record? I can restore them so no problems but I wonder. Leif

Looks nice @arnelgp and it will be easier to handle. I'm not shure what you meen by " i added new form to Media combobox, when not in list. " Is it the new forms frm_new_artist, frm_new_media you are talking about? I would like the same for frm_program. That's what is "still missing" as you...

OK, thought that I fixed it but I can se now that I've used the quote in the subform again. I will change that later in the evening and post a new database.