Recent content by sock

Hi, I have a little problem. I would like one field called Risk_Assessment to be set to visible if Age is under 19 and set to invisible if over 19. Please can you help with the code and explain where I should put it. This is what I have done and it does not work: Private Sub...

Hi, I have a little problem. I would like one field called Risk_Assessment to be set to visible if Age is under 19 and set to invisible if over 19. Please can you help with the code and explain where I should put it. This is what I have done and it does not work: Private Sub...

Hi, just thought you would like to know that I did have reason to use the second code you posted. I had to change it slightly to make it work for me in this scenario. Here it is; DELETE tblVolunteerProject.* FROM tblVolunteerProject WHERE EXISTS (SELECT T1.VolunteerID FROM tblVolunteer AS T1...

Hi, your first example worked better for my database. Thankyou very much for your help. It is the first time I have used this forum and I have enjoyed the experience.

Hi, the Volunteer profile is created as soon as name and personal details are added and is assigned a number as the primary key is an autonumber. I have three tables tblVolunteer, tblProject and tblProjectVolunteer. TblProjectVolunteer has for its fields, VolunteerID, ProjectID, StartDate...

Hi, thank you very much. I was trying that myself after looking at a webpage by Allenbrowne which is http://allenbrowne.com/subquery-01.html#DeleteUnmatched I never got as far as entering the AND criteria in relation to the date. The thing is is that this way it works too well as I have a form...

Hi, I get this message when I try to run a delete query. I would like to delete everything from tblVolunteer when in tblVolunteerProject.EndDate= <Date()-730. (ie basically all records 2 years old). The SQL code is this. TDELETE tblVolunteer.VolunteerID, tblVolunteer.Surname...