Search results

This was the problem - same search term was in multiple columns in a few of the rows Thanks for this - resolved

Hi Brian Thanks for this - this is a strong possibility now i think about it. When I get access to the file again ill test this and if it's resolved ill post back. Thanks Will

Hi I adapted a macro to help me sort data - it searches for a value in the rows and any rows in that worksheet, it copys them to another worksheet called "results" and then deletes the original row: Sub CutandPasteRows() Dim rng As Range Dim rng2 As Range Dim cl As Range...

You're brilliant thankyou - the form needed to be open... I knew it would be something like that - been banging my head against it all day everytime i had a spare moment then read through one of the help bits and read about filter needing the form to be open - tried it, it works, came on here to...

Hi Thanks for your reply, i have tried both these suggestions and i get exactly the same error message - that the form TRAUMA DATABASE cannot be found. "Run-time error '2450': Microsoft Office Access can't find the form 'TRAUMA DATABASE' referred to in a macro expression or Visual Basic...

Hi I have a database collecting patient information - its all based on one form called [TRAUMA DATABASE] which uses the table [TRAUMA DATABASE] (Access 2003) To make it simple enough for surgeons to use, i created a intro form with big buttons called [Intro] - these are seperate forms in the...