Calculation using Table Data

[ssanfu]

The database I posted updates for me. As soon as I tabbed out of the height control, the max weight updated.



Here are some examples of age calculations
http://access.mvps.org/access/datetime/date0001.htm

[scoobz1234]

Consider this query:

SELECT tblBCP*, tblHeightWeightStandardsCondensed.MINIMUM, tblHeightWeightStandardsCondensed.MAXIMUM
FROM tblHeightWeightStandardsCondensed RIGHT JOIN tblBCP ON (tblHeightWeightStandardsCondensed.HEIGHT = tblBCP.HEIGHT) AND (tblHeightWeightStandardsCondensed.GENDER = tblBCP.Gender);

Could probably include tblMale_Standards similarly. What circumference is measured - neck?

Not considering age factor in determining standards?

We don't consider ages, only because the difference is very small. we measure the neck and the waist for males and the hips waist and neck for females. you take the waist-neck=circumference 30" waist and a 15" neck circ=15

the only place age comes into play is for BF%

MALES:
17-26 yrs old = max BF% of 18%
27-39 = 19%
40-45 = 20%
46+ = 21%

FEMALES:
26%
27%
28%
29%

[June7]

Does ssanfu's db resolve issues?

[scoobz1234]

Hello again!

No it does not update for me, not sure why. after i input the Height into the form Height field it will update the table and the query but the form itself does not update. so the Max Weight box does not show the new max weight. the reason i need this to update is because people change on average a half an inch, the way we have to do it is if your 65.5 we mark you at 66 if your at 65.4 we mark you at 64...


EDIT: I got the Update to work, i had to for the txt box itself put in:

Private Sub txtHeight_AfterUpdate()
    Me.Requery
End Sub

EDIT AGAIN: scratch that, when i tab or click out of that text box it requeries but sends me to the first record. any way to make it stay on current record?

Also after i uploaded i went in and changed everything to have propor names and then i found out about the LEFT and RIGHT commands, so now i use those for LAST 4 and for the First Initial.

I plan on utilizing the TblMaleStandards to calculate BF% i should be able to do similar using a query or even the same query adding the third table and setting the relationships

[scoobz1234]

Ok i have figured out how to make it requery and stay on current record, i had to set a bookmark and then call the bookmark after the requery. you lose your place within the record but atleast it stays on the current record.

Private Sub txtHeight_AfterUpdate()
Dim rs As Object
Dim lngBookmark As Long
lngBookmark = Me.txtBCPID.Value
Me.Requery
Set rs = Me.RecordsetClone
rs.FindFirst "BCPID = " & lngBookmark
Me.Bookmark = rs.Bookmark
Set rs = Nothing
End Sub

[ssanfu]

Glad yo got it working.
But it is strange that the form updates for me and not for you. I'll try and look into it again tonight.

[scoobz1234]

Same database, but i have an issue that came about today, maybe you can help me out with?

When i enter a new record into the TBL Via the FORM, i can never go back and view that record, it only shows record 1 and 2 nothing after that. it gives me an error saying mismatch data.

Body Composition Program.zip

[ssanfu]

I'll look at it tonight......