Recent content by Virginia

Is there a way (besides doing it manually) to eliminate an empty column after running a query, before exporting it to Excel?

I'm trying to transfer a calculated sum from a form to a table. User is to enter amount on Field A and Field B and the calculated sum on Field C is to be transferred to a table (to SumField). I have created a SetValue macro with the following properties: Item: [MyDatabase]![SumField]...

Works great! Is there a way I can bind the end result (Field D) back to the table? Thanks for your help!

Hello all, I'm trying to calculate a total on a form: Field D = Field A - Field B - Field C This calculation will only work if I enter all fields (A, B, and C). I would like to have Field D showing a result regardless if the user enters all three fields or only two, or only one. Right now if I...

Thanks for the tip, it was very helpful!

I have created a form that has an AutoNumber field. When the user first opens the form, the new record will display "(AutoNumber)" until the user fills out any of the fields on the form and then it changes to the current record. Is there a way I can have this field show the current record number...

I meant I'm "new" in Access.

It works beautifully. Thanks for your help, Richie. I'm now in Access and still learning the basics. Thanks again!

I believe you would have to right click on the form (on design view), select "Tab Order", select the field that you want to tab after the third field and place it after the third field. You will need to check the format on the fourth field to make sure it says "visible". I hope this helps.

I have set values on text fields, where a user will have to enter numbers which should have 6 decimal places. However, when the user enters the number 15.369887, Access automatically rounds it to 16.000000. The user must see the entire number, including the values after the decimal point. Is...