Recent content by Jules48

:banghead: When I select an object and then go to the code window for that object (either by selecting "Code" from the ribbon or by selecting an event procedure from the properties list) the VBA screen opens all code windows for the project. Is there a way to stop this so that only the relevant...

Hi lead 27, How many different DofQ types do you have? If it's 3 or fewer you can use conditional formatting from the "Format" menu by adding extra conditions - see "ConForm.jpg" attached. If you have more than 3 then I guess you'll need a series of If...Then...Else statements behind the qty...

Unrecognised UCase Function Sussed it! Missing comctl32.ocx reference in VB editor (VB Editor -> Tools -> References) ;)

In my Access 2000 database I have a form which displays patients' treatment details. I have a text box in which the Forename and Surname are concatenated to display the full name and the Surname is included in a UCase function so that it is displayed in capitals: =[tblPatient.Forename] & " " &...