Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rob77
  • Order by date
  1. rob77

    Duplicates

    It's not quite what i wanted, but thanks for your help. I've got my SELECT Fname, Sname, DOB, Birth etc FROM my table WHERE ((([table].[FORENAME]) In (SELECT [FORENAME] FROM [table] As Tmp GROUP BY [FORENAME],[SURNAME],[DOB] HAVING Count(*)>1 And [SURNAME] = [table].[SURNAME] And [DOB] =...
  2. rob77

    Duplicates

    I need to find Duplicates based on more than 1 column and i'm finding the MSAccess Wizard isn't giving me the correct info. EXAMPLE: I want to find duplicates where SNAME, FNAME and DOB match Access gives me.... ID SNAME FNAME DOB BIRTH 01 JONES JOHN 01/01/01 UK 02 JONES JOHN 01/01/01 AUS...
  3. rob77

    Force user to input 2 rows of data

    Thank you very much for you help it's much appreciated but it's now erroring, i've added the above line but it then comes up with a runtime error '2001' you cancelled the previous operation Cancel or Debug, on pressing Debug it has a problem with the DCount line, i've checked the spellings are...
  4. rob77

    Force user to input 2 rows of data

    I am trying to force users into inputting 2 rows of data into a form, once they have pressed the exit button I don't want the form to close i want the user to be able to input more data on to a blank form. I've never used DCount before as I am new to the VB side of Access but this is what i've...

Part and Inventory Search

Back
Top