Recent content by 007stuart

Thank you Problem solved Thanks Stuart

Apologies for the confusion Let me restate my objective. I have a form, that once complete, allows the user to to either instruct a repair or record a an arrangemnt to repay arrears. Initially I had thought of a message box but now think that an Option Group with 3 options (Instruct...

Hi all I am considering placing either an Option Group or a Message Box on a form that becomes visible after a "Close" command fires. There would be three options : 1 Yes I am done 2 Organise a Repair 3 Record a Payment Is this the right way to go about this and if so can you give me an...

Thanks Perfect:)

I Nedd to devise a method that allows the user to select a repair type that needs to be done. Each repair type has a list of contractors that can undertake the particular repair. I had thought of a combo box to hold the repair types but am unsure of how to then show the appropriate contractor...

Thanks for your replies. To Missingling I like your code and understand what it is looking to do. Do I place a before update event on each control that requires data?

Hi I have a mix of combo boxes and text boxes on a form that records service calls. I propose using the before update event to check that each Combo and Text box is completed but am unsure of the correct coding to achieve this. Can anybody assist Thanks in advance

Hi Wazz, Thanks for your reply, it makes a lot more sense. Regards Stuart

Hi Wazz, Thanks for your help. What does "(N:N)" mean after - tblContractors_Jobs? Likewise "do" before tblDevelopments : tblContractors_Jobs Regards Stuart

I have a problem that I am sure is easy to resolve but is beyond me. I have a number of housing developments in many parts of the UK that I manage and have many contractors each with differing skills that cover not all the the developments. I have created a many to many relationship between...

I am looking to use on a form Calender Control 10 to allow a date to be selected. Is is possible to configure the calender to invalidate selection of a date that is in the past?

Thanks for the help

Hi I have a smilar problem but relates to a Query that powers a form. Can you suggest a solution to my form being blank showld the query return no records?

Hi I have a form that (FrmAddressInput) that contains several Combo Boxes, many of which have Not in List Events set to allow me to add new data to the appropriate lookup tablss ( all perform perfectly). I now have added a new Combo Box (CboPropertyName) to allow The Development the address...

Thanks for your help. I will take on board your recommendation and see where I go from there. Stuart