Search results

Cheers Sam, I finally used a different method to use an un-bound text box as the search field to display any matching records: Private Sub cmdSearch_Click() Dim strCustomerRef As String Dim strSearch As String If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then MsgBox...

Thanks for all your help Sam, I don't want you to get in trouble at work mate. I have tried to manipulate the code the best I can and I get the below come up: http://img79809.pictiger.com/images/14327703/ Now you may look at this and think "god Graham you are a FOOL" and if this is the case...

Thanks for the replies again, Gem, I have had a look at the code you have posted and I am afraid that my knowledge of VBA is so rubbish it makes little sense to me - I know this is not the kind of thing anyone wants to hear :( Sam, your idea sounds good, but again adding a search field is...

Cheers for the reply Sam, After taking a look at my database I have made a few changes (you can tell I am new at this lol). I have now reworked the Relationships to better suit each other and now the connection between the Leads and Operator's Tables should be correct. I would like users...

Morning all, I am a new user to the forums and to be honest my knowledge of Access still needs a lot of work. I am trying to create a Database with some simple built in functions but I am running in to a few problems that I will try my best to explain. My database will be used to record...