Recent content by kitandy

Thanks I spotted the file format when you returned it and not sure how I missed it earlier. I converted to it accdb yesterday.as recently upgraded to Office 365 Many thanks again

Thanks its looking good. Will be able to test later this month when more mebers will meet the deletion criteria

Thanks Re the one to many relationship. We have a membership type called joint using one membership number.. This is 2 folk living at the same address. We have to record all individual names for insurance purposes so can have two people listed with the same membership number and address...

Hi I have tried your first suggestion (see the attached file) but still no cascade delete

The attachment shows where I think my problem is. The table Members to be deleted will only form as the many end of a one to many relationship with T membership details which prevents cascade deleting. If I manually delete a member from the membership deatails table all thier details are...

To Clarify The delete query is successfully deleting the records form the Table members to delete. However the related records in other tables are not deleted. Perhaps I am going about this the wrong way. What I am trying to do is create a list of members who have not renewed and delete them...

My web research indicates that the table that initiates the cascade delete must be on the one end of one to many or one to one relationship or the cascade fails. My Table members to be deleted is on the many end . Can I change this?

We have a database, created in access 2010, to manage a club’s membership records with each member having a specific membership number. The policy is to delete all details of any member who has not renewed after a specified period. I created a query that identifies members who meet this...

Hmmm Thats great Unfortunately it has impacted on the way the form functions I was set to go to a "New record" on loading but now when you select a class it brings up,in the subform, previously entered data for that class.. This from need to always go to a new record

Hi I have uploaded a zipped file On the main menu select "Enter Results" It is one of the red buttons in the enter data section This opens the form in question The box at the top of the form titled "enter class number etc" is the one. What I am try to achive is select by class ID and store...

Would you like the current copy (with the changes you advised) or a backup made prior to these

Quite happy to upload whole database if that would be easlier

Its on the main form

I have attached a couple of screen shots Capture 1 shows the control source Capture 2 shows the after update, the proceedure is the code you sent

Hi Thanks Now getting error message "Runtime 2113 The Value you enterted isn't valid for this field "