Recent content by lg5050

I am going to send a attachment so you can understand. I created a table and a form. In the US Weight field I enter 80000 and I have a formula in CA Weight Field which would be =[Weight] * 0.4536. So if I enter that 80000 in US field it should calculate the field for me. How do I do that In...

im not sure i have never used that before can you please help me on that.

I'm not sure about the record source. I don't know how to do that. I basically need every time i type in a number in the US Weight field it makes this formula =[Weight] * 0.4536 in the CA Weight Field.

Hi, I put the formula in the Text box field in the control source in the property's tool box and i don't know if it will save that calculation to the table. I was wondering if i can do VBA code to save the the calculation in the table. Please help me out!!! I have a field called CA Weigt and i...

I have an table and i have a form. On the form i don't have a textbox and on the table i have a field called CAFlag. Is it possiable that i can make the table have an Y or N if CALine field on form is not null in vba. Please help.:confused:

Yeah i notice it too and i got it to work perfectly. Thanks a lot.

ok thank you.

Here is the database i tryed it and it don't work. Is there something i doing wrong.

No i try that and it did the same thing. It did nothing. I'm putting it in the LostFocus event is that right???

i have a form in access 2010 and i have a text box called USLINE and other one called USOFlag and i want the USLINE field to do like if it's is not null then it is a Y else N i try to do it in the LostFocus function but i cant get it to work Please help me on this!!!!!:confused: Here is the the...

ok...i have a field called USLine and if i use that code for the USoFlag showing in the picture that show work for the field USLine.

Hi, i'm trying to figure out how to make this two fields in my form to say Y or N if the field is Not Null. Like if the field is not null = Y Else = N for the two fields. I have a picture to show what i'm talking about. Please help!!:confused:

Ok i add the code to the table and it copied it but i get an error message which i will have a image to show what it is. The code that i used was: Private Sub cmdDuplicate_Click() On Error GoTo Err_cmdDuplicate_Click DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy...

Hi, i am trying to copy a record as new record in vba in access so i make a button for the user so that they can copy a record each time and change a certain field if they wanted. How would i do that.

Yes you are correct. When i do that like if i have 7.56 it would be a whole number and i don't want that. Is there any else that i can do to solve this problem.