Search results

Thanks all! Thanks to James whose trick has worked wonders! Kind Regards Aleister

@James: My Amended code:- Option Compare Database Option Explicit Private Sub Command7_Click() End Sub Private Sub cmdFind_Click() On Error GoTo Err_cmdFind_Click Dim stDocName As String Dim stLinkCriteria As String Dim custid stDocName = "Customers" If Not...

The search code is the Private Sub cmdFind_Click() What files would I need to show you? Tables? My Customer table consists of: CustomerID, Name, Address, Town, County, Postcode, Telephone, Email.

I don't normally programme in Microsoft Access much so that explains why my knowledge is quite poor when it comes to this. Dropdown box would be great but can't implement it! Thanks

Sorry this is my code: Option Compare Database Option Explicit Private Sub Command7_Click() End Sub Private Sub cmdFind_Click() On Error GoTo Err_cmdFind_Click Dim stDocName As String Dim stLinkCriteria As String Dim custid stDocName = "Customers" If Not...

Hi, I have a customer database running in Microsoft Access and at the moment in the design view I have created another text field so I can look up customers via a Post Code as at the moment I can only look up via Customer Name. I have created a new textfield called (txtpostcode) but I need...

Hi, I have a customer database running in Microsoft Access and at the moment in the design view I have created another text field so I can look up customers via a Post Code as at the moment I can only look up via Customer Name. I have created a new textfield called (txtpostcode) but I need to...