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: kjc
  • Order by date
  1. kjc

    Sub-forms

    You could use a script to SAVE and then set subform B visable property to NO and the subform C to YES, but you might also consider using a TAB with each sub form on a different TAB
  2. kjc

    HOW DO CHECK IF QUERY RETURNS ANY RECORS

    I like to use: MyVariable = Dcount("QueryFieldName","MyQueryName") Then you can 'If' or 'Select Case' on MyVariable (it will contain a 0 if there are no records...)
  3. kjc

    Rounding - How

    If you really want to "trim" off the excess decimal places, use this: Function RoundCC(X) RoundCC = Int(X * Factor + 0.5) / Factor End Function Use it like MyNumber = RoundCC(MyNumber)

Part and Inventory Search

Back
Top