Search results

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 "

Hi I have entered the following (it auto entered the = but get the error message "The expression you have entered contains an invalid syntax" = private sub txtClass_AfterUpdate() me.Class.Value = Me.txtClass.Column(1) I have tried removing the = to no effect. I have also removed the macro (on...

Thanks but being a bit slow My combo box (containing the list) is named txtClass not sure what yourTextBox rehers to

Just another little problem I have a form for entering results which contains a combo box for selecting the entry class from a drop down list. This list consists of two fields. both from a table called "T_Classes" "Class ID" is the unique number of the individual class and is the one which is...

Slight change of plan Below is the SQL of the query I would now like to select the highest scoring exhibitor for each year SELECT Q_Results_All_this_year_2_for_stats.[Sort Year], Q_Results_All_this_year_2_for_stats.EntrantName, Sum(Q_Results_All_this_year_2_for_stats.Prize) AS SumOfPrize FROM...

I have a Sum query analyzing show entries that reports as followsshow year (grouped by) Entrant (grouped by) Number of entries (sum) and sorted descending I need to select from this the "Entrant" and "SumOFnumber of entries" and "year" only the entrant with the highest number of entries in each year