Recent content by iankerry

Hi Docman. Thanks for your message. I don't really agree with your perception of what happened. I don't think it was a case of me not wanting to hear something, more to do with the way someone was talking to me, and I didn't feel I deserved it. But I understand Pat is an important member of...

Thank you.

Hi I too wish to delete my account but I can't find an option. Can someone please point me in the right direction or delete my account please? Many thanks.

Hi Pat thanks for your message. Once again I can only apologise for any frustration you feel caused by my post. Whilst I have been using access for 20 years my programming understanding is not good. I run a charity with 10 employees and this takes up most of my time. Any programming I have...

Hi Pat, I am sorry if my ineptitude with coding has upset you. As mentioned in my last post to you I am using a bound form. "If you are going to use Access, you might want to learn to use it correctly. " - I have been using access for 20 years and whilst I don't feel confident in coding...

Thanks Pat. We do have other forms for Films, with a subform for copies information. This exercise was just about getting a new film record and corresponding film copy record. and on that form you can create a new copies information. So yes I have a bound form, and with the me.undo command it...

Hi Mike the tables are normalized at the moment. it is more complex than my original question and we probably have 10 different tables that link, and all of these have foreign keys. Thanks Ian

Thanks Mike, I seemed to have sorted my issue now. But thanks for commenting.

Hi Pat, A record in the Films table needs to have an associated record in the filmcopies table. This is because we may have several copies of the same film with different info such as dvd region, where the dvd is currently located etc. so in order to have a link betoween the two records, the...

Hi Doc_Man Thanks for helping me get a deeper understanding of things. IT is much appreciated. Yes, not being very good with the terminology is mis understood your question. Yes there is a query behind the form, with the Films Table and the Films_copies table, joined together on the...

Thanks Doc Man, I'll take a look at these suggestions. Re recordsource - i suppose the answer is both? firstly the dbo.films, then the filmcopies. But at least it works now, and i will close the rs. thanks

Thanks DBguy, that worked a treat.

Hi Guys, I am not a very experienced programmer, so please bear with my code! I needed to write this code, because I needed to create a new record in a FILM table, and at the same time create a new record in a FILM_COPIES` using the value of the newly created FilmID to place in the field...

Hi Gasman, thanks. I have some success with this at the moment - well I have managed to create an email for myself with some of the fields in need it. (a bit chuffed really coz this isn't my thing! but pride comes before a fall...) can i ask a couple of quickies? I obviously have my SQL...

That's not good. I wish you well and hope you get back here. and that you have a stock of toilet rolls.