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 gkittelson 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. Abinadi8

    Find number of records in a subset of large table

    I am already doing this: lngEstimateID is the only field that I have the Count function onand am showing. On the stForm, intPage1, intPage2 and lngCustomerID I am using the where function and I am not showing these fields. Sql comes out as follows: SELECT Count(Estimates.lngEstimateID) AS...
  2. Abinadi8

    Find number of records in a subset of large table

    I am new to this Tek-Tips area, I apologize for my rudeness, if rude it was. Even though I have studied the help under totals queries, I am still recieving the message "can't group on fields selected with '*'. I am afraid that this reply has been no help at all.
  3. Abinadi8

    How to carry forward a values on a record that is Not New

    I do this in the following manner: I put a hidden field on my form Me.intRecsH (property: Visible: No) where the bound Name is Me.intRecs (property: Visible: Yes) then I do two things in the vba code as follows: Private Sub Form_Current() On Error GoTo Trap If IsNull(Me.intRecs) Or...
  4. Abinadi8

    Find number of records in a subset of large table

    I have been trying to create a temp Table of the subset desired; however, I find this does not work well if there are no records. then I get an error that I trap and report back as to what, when and where this happens. I would rather create a specified # records if the COUNT is 0. I have been...
  5. Abinadi8

    Find number of records in a subset of large table

    I have been trying to create a temp Table of the subset desired; however, I find this does not work well if there are no records. then I get an error that I trap and report back as to what, when and where this happens. I would rather create a specified # records if the COUNT is 0. I have been...

Part and Inventory Search

Back
Top