Search results

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

Aside from the error not being there any more, the whole clicking "open" on the form opening a record and "new" opening a new record is still not working. When I click on the "Open", the first record opens, and when I click "New" the first record still opens. It would be great to discuss this...

Thank you for the sample and I can clearly see that it works on the sample, but I have a few questions just to implement it on my form. 1) Are all the fields on the "Filter" table necessary as some are left blank. For example, the "Sort String", "Default", and "Description" are left blank. 2)...

I have attached a sample of the MS Access file with a few records inputted. Currently, the problem is by clicking the "Open" or "New" only the first record is brought up with the detail inputting form. Please ignore the "Type mismatch" since its only an issue in the sample file and not the...

I don't know if this might be what is causing the problem, but the #record on the form is 1 even though the number of records on the table is 565. I have set the Record Source as the Table or the Query of the table, but neither of them seems to make the number of records on the form change.

Alright I have copied the Embedded Macro '------------------------------------------------------------ ' txtOpen_Click ' '------------------------------------------------------------ Private Sub txtOpen_Click() On Error GoTo txtOpen_Click_Err On Error Resume Next If (Form.Dirty) Then...