Recent content by wandana

Thanks Sam, I will try to attach the code again, I have seen the DoCmd idea described somewhere else but my attempts to utilise it failed. If I can send the code and tables, maybe you could use it as an example, I am sure my errors are syntax, spelling or somesuch! Thanks and Best wishes, Jim

I am new to ACCESS, I have some experience with SQL, VBA and RDBD having been trained by ORACLE The attached tables come from a RB I am making, I can run the SQL and it works, I have failed to create form or report tha enables users to simple use a button to invoke that code. Several people...

Thanks Jdraw, I have attched, ( I HOPE ), the three files associated with this query and the data is all fictitious! I hope you understand what I need, I need an example of how to enbed my SQL code in a form or report so that it will create a reult from those tables. It is possible that...

You are right, table names like dn and TL, ( District nurse and Team leader) are meaningless but I use the shortcuts to save time typing as I spend most of my time re-doing the code to try and make it work. And for that to happen, I need someone to just show me how to put the following SQL code...

Hi, Jdraw, Below is a JSP of a screendump, I could not find a way to export straight to a file that could be attached to a message on the forum. I sent a working sql query in an earlier post. I wish to enable the user to invoke that query by pressing a button a form that will result in the...

OK, VISIO does allow a save as jpeg but then it is not recognised by any other software. One point, ALL my MS software (apart from OS), is 2003, I had a legel version for home use from work and MS still support it and it does most of what I need, so we are both at least on the same ACCESS! I...

Hi JDraw, Correct on all counts! the OOP/D does help and the Oracle training plus lots of other stuff enables me to have a GOOD understanding of conceps and some execution. I was a programmer in Assembler in an earlier life. OK I have managed to create a jpeg of my model done in Visio but not...

OK, I just rewrote the bit of code I lost SELECT surgery.surgeryname FROM surgery WHERE surgery.suid IN ( SELECT cmsu.suid FROM cmsu WHERE cmsu.cmid IN (SELECT communitymatron.cmid FROM communitymatron WHERE communitymatron.matronname=name)); This snippet wrks...

Hi All, I have experience of OOD and OOP and training by ORACLE in SQL, RDBD and Java, but not a lot of experience in them. I am now semi retired. I am doing a small database for a medical app and MS ACESS should be more than adequate I have 9 tables 1 many to many, 1 one to one, the rest...