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 strongm 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: ReeceB65
  • Content: Threads
  • Order by date
  1. ReeceB65

    I get n =7 out of this. Why? And why do I get 14.002 for S1?

    x = Forms![Density Test]![No of Test] For n = 1 To x Dat = Choose(n, Forms![Density Test]!DENS1, Forms![Density Test]!DENS2, Forms![Density Test]!DENS3, Forms![Density Test]!DENS4, Forms![Density Test]!DENS5, Forms![Density Test]!DENS5, Forms![Density Test]!DENS6, Forms![Density Test]!DENS7...
  2. ReeceB65

    Getting an average in VBA in Access

    In an Access module I'm using this code x = Forms![Density Test]![No of Test] For n = 1 To x Dat = Choose(n, Forms![Density Test]!DENS1, Forms![Density Test]!DENS2, Forms![Density Test]!DENS3, Forms![Density Test]!DENS4, Forms![Density Test]!DENS5, Forms![Density Test]!DENS5, Forms![Density...
  3. ReeceB65

    Trying to write a VBA macro. What am I doing wrong?

    OK What am I doing wrong here! It keeps throwing a sub end/exit error INSITUDENS1 ' '------------------------------------------------------------ Function INSITUDENS1() On Error GoTo INSITUDENS1_Err Forms![Density Test]![Result 1] = Forms![Density Test]!DENS1 Forms![Density...
  4. ReeceB65

    Mean and Std deviation on a varying data set in an Access form.

    thread702-1136748 Like the above thread I need to get a std deviataion of a data set on a form. However, my issue is that my data set could be between 3 and 10 of the circled items. The remaining 7, 6, 5, 4 fields could be blank. How do I write this in the macro so it does't throw an error...

Part and Inventory Search

Back
Top