Recent content by chinkygogo

Thank you! yes i indexed my fields and made them unique and then wrote validation in Form_BeforeUpdate using DLookUp and then set Cancel = True and called the Undo function so that erroneous duplicate could not be made. thanks again pete

thank you very much. i will give this a go in the next few hours and let you know how i get one. pete

hi i think that i have almost answered my own question. I have set both resource_id and category as a primary key. this disallows the duplication i am thinking of. however, the only way of exiting from the error is to re-categorise as a non-duplicate. does anyone know of a way of exiting but...

Hi I have a table full or resources that can be categorised as many different types of categories. i.e. tblResources has a one to many relationship with tblCategory. if i could categorise a resourse as either a 'Listening' resource or a 'Reading' resource this relationship would capture it...

I obviously wasn't using my aliasing properly, your example seems to have sorted it out! thank you

Hi there, if i have a table with columns: Teacher ID1 | Teacher Comment1 | Teacher ID2 | Teacher Comment 2 | i also have another table that links the teacher ID with their names called [Staff Profiles] how do i create a query that returns the names of both teacher 1 & 2. i have tried: SELECT...

hi there, i have a form (to be used as a subform). I have added a button to the form so that records can be edited. attached to this button i have written a macro to unlock the text boxes (when pressed). Please find diagram attached. My problem is that the button unlocks all boxes in all...