MS Access Question- Homework related -tearing my hair out!

nekulturny

Distinguished
Feb 9, 2012
8
0
18,510
0
Working on a chapter assignment, I submitted last week. I couldn't make the formula work, professor gave it back to me with an extension as well as a formula to try and resubmit. Well using the formulas she gave me, I still can't make it work.

Trying to get a simple record count from a sub forum to a main form. BTW, I absolutely hate MS Access, and I could never see myself using it as a database if I were to own a company. At least Excel tries to help you when you have an error in your formula, access just sits off at the sideline mocking you with no offer to help whatsoever. I have literally been working for hours trying to make what in Excel would be a simple Cell reference work on this miserable access program.

Here is a couple screenshots of what I'm trying to make work:

Form View


Design View
 

nekulturny

Distinguished
Feb 9, 2012
8
0
18,510
0



Here is the email I received from my professor about what to do to make it work:

1. =[frmProgramMemberSubform].[Form]![txtFirstNameCount] Use this code for the Total Members field in the main form.

2. In the subform create a calculated field in the footer of the subform. Please try this and resubmit Case 2.
I know that the professor said to use [txt,, in front of the FirstNameCount]. that gives me a #ERROR message, not having txt in the beginning gives me a blank field entirely.

Unless I'm not understanding her. Yes, there is a formula in the footer. It does indeed show that there are 4 records in the subform. I guess Ultimately what I'm asking is to be able to use that in the footer to display that value in the box of the main form.

There is a field named FirstNameCount in the sub-form, maybe my syntax is wrong? I'm not sure, the FirstNameCount is the name of the field in the subform footer. I just don't understand why Access can't be simple like Excel, if I wanted a 2 cells to reciprocate the same information it would be a simple syntax "=A38".. and every cell I put that in would show what was in A38.... :(
 
Thread starter Similar threads Forum Replies Date
S Apps General Discussion 0
D Apps General Discussion 0
C Apps General Discussion 1
S Apps General Discussion 2
H Apps General Discussion 1
A Apps General Discussion 1
J Apps General Discussion 6
RainOfPain125 Apps General Discussion 5
D Apps General Discussion 2
B Apps General Discussion 1
M Apps General Discussion 3
W Apps General Discussion 1
K Apps General Discussion 1
C Apps General Discussion 2
C Apps General Discussion 1
G Apps General Discussion 8
K Apps General Discussion 2
gigaman Apps General Discussion 6
L Apps General Discussion 3
D Apps General Discussion 1

ASK THE COMMUNITY