Search results

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

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

Alright! Now the database is all english for you to try on. The form is frm_program. There I have collected the content of my disco radio programs and want it to be possible to create new programs and add songs in them, either from my table with music or that it is possible to add new songs in a...

Hello @arnelgp I've been trying to understand the code you helped me with. I was going to use it on another form that has similar needs. But unfortunately I can not interpret it so that I understand it. What does it start for example, what happens first, what initiates it to happen. I wonder...

THANK YOU @arnelgp I had never been able to figure out that code by Goggling. I consider myself able to structure databases and SQL because I have worked with PHP and MySQL. But then just tied to the web. I am very grateful and now I can move on in the project of fixing the look of the forms...