Recent content by hayashig

I used the option group to make the field on my form because MV field would not for some reason not become horizontal like so; Are you sick? [ ] No [ ] Yes [ ] Maybe Rather it would remain Are you sick? [ ] No [ ] Yes [ ] Maybe Also, each box would not be recorded as presented in the form...

I got the field to work as I wanted with the values, but it turns out a few of the fields will need multiple value input. Also after I click one of the check box from the option group I cant unclick the field, is there work around for this?

The image depicts exactly what i want to make, but i have no clue about making the option group control. Do you happen to know any tutorial on making this? Thank you for all the help.

When I try to turn it horizontally, I get a weird results. This is what happens when i set the column count = 2. [ ] 0 1 2 [ ] [ ] Also, I cant change the displayed value the way I have done with combo boxes. I set the column width = 0";2", Row source type = 2, and Row source =...

I finally understood to use the Query for calculation but I am having trouble just adding the values from different form fields. When i do E: [A]+[B]+[C]+[D] A=1 B=2 C=3 D=4 then all i get is 1234 rather than 10.

Thanks all for the replies. I guess my reasoning for keeping the calculated values seems odd, so maybe i can try to explain it more straight forward. I want to store the calculated value on the table so that later I can use the "Analyze Table" function to look up the data. So here is where I...

Thanks for the replies. I am not doing any heavy calculations nor am I doing any calculation that will ever change. Its just that I would like to store the numerical values and the calculated value to later organize the data by records. I am horrible at understanding codes, so is it possible...

Thank you for the reply. The field on the table only needs to store 1 value (0,1, or 2), and as for making the list horizontal, is that possible?

I am currently using MS Access 2007. I am not sure if this is even possible but I thought it would be worth asking. I have made a multivalue field on the form and made it into a list box with check boxs as the possible values, but the list box only lists the possible values down wards. I would...

I haven't asked a question here in a while so I hope I am not asking too much. Currently, I am using MS Access 2007. My problem is that I have a calculation in my form of which the variables are also recorded on a table, but I also need the calculated value to be recorded on the table. I know...

I put in one of the missing parenthesis = (703*[Weight])/((12*[Height1]+[Height2])^2) and it fixed the calculation which I can use now. Thank you so much PNGBill your assistance was most helpful.

The calculation you gave me gives me an error: Expression you entered is missing a closing parenthesis, bracket, or vertical bar. = (703*[Weight])/((12*[Height1]+[Height2])^2

My current calculation uses [Weight] rather than (Weight) the second formula I posted is the Actual BMI formula, not the one I used.

I am using MS Access 2007. I have a problem that may be simple, but I have yet to figure out the solution to by looking through the forum. I am trying to use a BMI calculation using the form. None of the controls ie. weight and height has a field on the table, and I also do not need to have the...

Poppa Smurf thank you so much for your help. I have finally solved this problem. On the original student template, there was a field on the table called ID which I deleted since my database uses a different ID system, but this is where the problem started. By deleting the ID field which was set...