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 IamaSherpa 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: *

  1. KarlTrep

    .HideDuplicates syntax

    Hi Doug and Paul, I've tried both DISTINCT and DISTINCTROW but my combobox shows a blank list (about as long as the complete list hmmm?) Reading through the Access Help I found that DISTINCTROW is disregarded when only one table is looked up (as in my case)so I'll stick with DISTINCT. This...
  2. KarlTrep

    .HideDuplicates syntax

    I'm using Access 2000 and since I don't know VB and there is no option in the combobox wizard that does this, I would really appreciate something along the lines of: Private Sub ComboBox6_BeforeUpdate(Cancel As Integer) Dim stDocName As String stDocName = "Customer name&quot...
  3. KarlTrep

    .HideDuplicates syntax

    I have a combobox presenting the values from a field which has duplicate entries. I've found that there is a property that eliminates the duplicates from appearing in the combobox (.HideDuplicates) but I don't know how nor where to write this command. All help appreciated TIA Karl Trepanier
  4. KarlTrep

    All queries return blank results!?

    After compacting an access 2000 database, all queries now return blank results when ran. Same as if you left the prompted criteria field blank. Anyone know what's up with this? Really need the help. Thanks
  5. KarlTrep

    All Queries now return blank results!?

    After compacting an access 2000 database, all queries now return blank results when ran. Same as if you left the prompted criteria field blank. Anyone know what's up with this? Really need the help. Thanks

Part and Inventory Search

Back
Top