Search results for query: *

Mike, Found the problem - was my referencing. Forgot to include the full reference to the form/subform/control name. Full marks for coming up with a nice simple solution. Best Rgards, Brian

Mike, That's ideal! Thank you. Do I actually need to store the values in a table (they are transitory) or should I be able to refer straight from the form - =forms!frmNameofForm!controlname just gives me #name? in the report. My code in the form frmresults1 includes:- Me.ptimes = strmessage...

Folks, As usual, I find myself challenged by something that seems simple but I cannot see a way forward. On code behind forms I run vb and assemble a string as I step through a recordset. The string gives the user the final string in the form msgbox, stringname using Chr$ to provide a simple...

Thanks for the response Joe. I'll take the new sub route but I'm still intrigued ... my form is frmrace13 on which is the date field frmDate and within that the onmousedown event which generates this sub ... Sub frmDate_MouseDown(Button As Integer, Shift As Integer, x As Single, Y As Single)...

Folks, I think this should be simple but ... sound of tearing hair... Access 2002 under XP. How should I call one sub procedure from another on the same form? I have a form with a date field. On mousedown, I make visible an ocx calendar, select a date and make the date field equal to the...

Fixed ! I'd like to say thank you and award stars to Remou and TheAceman1 - Aceman1 for the code and Remou for telling me about Cascading Deletes (never looked at this before - so much tidier) and advice regarding the source query. Best Regards Helmpost

Remou Sorry not to have responded. The Form's underlying query does look a little odd (developd before my time). I found that the records in the top table are not unique - don't yet understand why in the design. I can get the results required on the form using this query SELECT DISTINCTROW...

Hi AceMan1 That looks good (there's nil on Recordset Clone in my system Help and my books are all old !). Since all the records have at least one join and possibly more, there's a need to delete these subordinate records before the top level record can be deleted. In my current code, this is...

Thanks Remou Here's the record source for the form. I hope this is what you wanted ? SELECT DISTINCTROW Contacts.* FROM Contacts INNER JOIN Members ON Contacts.ContactID = Members.ContactID WHERE (((Contacts.ContactID)=[Members].[ContactID])) ORDER BY Contacts.SortName; Records in the...

My club management access database has been developed by several owners and through several different access versions - I am the latest owner and am on 2002 SP3. The main membership form includes custom buttons to Add or Delete new memebrs in VBA. The Delete code includes a requery that...