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 Rhinorhino 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. ReeceB65

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

    Managed to get my code working I'd like to share how I did this Be mindful that x was a varying number of fields from 3 to 6. x was stated as number of samples on my form. "x = Forms![Density Test]![No of Test]" So had to be able to calculate from whatever number of fields was required...
  2. ReeceB65

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

    Managed to get my code working I'd like to share how I did this Be mindful that x was a varying number of fields from 3 to 6. x was stated as number of samples on my form. "x = Forms![Density Test]![No of Test]" So had to be able to calculate from whatever number of fields was required...
  3. ReeceB65

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

    Managed to get my code working I'd like to share how I did this Be mindful that x was a varying number of fields from 3 to 6. x was stated as number of samples on my form. "x = Forms![Density Test]![No of Test]" So had to be able to calculate from whatever number of fields was required...
  4. ReeceB65

    Getting an average in VBA in Access

    I'd like to share how I did this 'Average Density Ratio For q = 1 To x Dat4 = Choose(q, Forms![Density Test]!DR1, Forms![Density Test]!DR2, Forms![Density Test]!DR3, Forms![Density Test]!DR4, Forms![Density Test]!DR5, Forms![Density Test]!DR6) S4 = S4 + Dat4 Next Forms![Density Test]!MDR = S4 /...
  5. ReeceB65

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

    I found the problem with the average issue but would still like to know why n comes back as 7?
  6. ReeceB65

    Getting an average in VBA in Access

    Never mind I found the obvious. I'm just a blind twit
  7. 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...
  8. 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...
  9. ReeceB65

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

    Awesome! Thanks Combo. Got the VBA to run and close on click However now using the script 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...
  10. ReeceB65

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

    So I tried this and now I still get a compile error Exit sub not allowed in Function or Property This was converted from a Macro '------------------------------------------------------------ ' INSITUDENS1 ' '------------------------------------------------------------ Function INSITUDENS1() On...
  11. 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...
  12. 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