Search results

  1. V

    Empty Columns on a Query

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

    Form User Input Field to Table

    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]...
  3. V

    Calculating Totals on a Form

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

    AutoNumber Display

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

    Default Values & Rounding

    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...
Back
Top Bottom