Search results

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.

Well i have a database that has 40,000 some fields and all the datatypes are in text and i want to change some of the datatype to a number but if i try to i get a message that says: Some data may be lost and i will lost that data. So i figured if i tried to add a column i could transfer the data...

Hi i need to know how to do vb code to an access table step by step. Not sure how to make the code work to the table. I want to add a column to a table and i don't know where to start.:confused:

this database has over 40,000 some records and some of the fields have numbers and i trying to change them from text to number but if i change it delete the decimal point into a whole number and i don't want that.

Thank i will try that.

Hi need help to create a new field programmatically, transfer all the data from the old field into it and then deleting the old field. because my field is a text field and i want it to be a number field. I think i can add a new field and delete the old field. But i don't know how to do the vb...