Recent content by James Reay

Partial Success For anyone interested, a partial answer to the problem can be found in http://support.microsoft.com/?kbid=311147, but does not work if the linked object embedded in the control is iconified and does not explain how to differentiate between linked/embedded and empty fields within...

Sorry, I should have been clearer - the field is of type OLE Object and I need to update the path of the linked Word doc etc that is stored within it.

Does anyone know how to change the path of an OLE Object that is stored within a table? I want to move thousands of linked files to another location, but must update all the references.

Many thanks.

Something that has been bothering me for a while... I have a query that has the following expression as one of its fields. Grade: DLookUp("[TABLE Grade Schema Details]![Grade]","TABLE Grade Schema Details","[TABLE Grade Schema Details]![Grade Schema] = '" & [Grade Schema] & "' And [TABLE...

I am using an unbound DTPicker in order to control what day's information a particular subform displays. My problem is that I want the line of code to be executed as soon as a new date is selected. At the moment I am using the DTPicker's OnLostFocus event to run the line of code required and...

Thanks - Worked a treat! I had thought of dlookup but didn't know where to put all the quotation marks and so had previously only been returned error. In the end I modified your design to cut out the need for a start and finish: Grade: DLookUp("[TABLE Grade Schema Details]![Grade]","TABLE...

.......(Pressed post accidentally) How can I lookup/match the applicable grade from the GradeBoundary table? Thanks in advance.

(Simplified version of problem) I have a table named GradeBoundary that describes grade boundaries for a particular course eg GRADE PERCENTAGE TO ACHEIVE U 0 D 20 C 40 B...