Search results

  1. S

    insert query has no data

    I wrote an insert query that enters all fields on a form into a table. The form has some fields that are populated by a query and some that are calculations of the other fields. All of the fields that are populated from the query enter fine, but the ones that are calculations are blank. I read...
  2. S

    save form data to a table

    I have a form that contains fields that are populated by a query and it has a few fields that require user input. What I'd like to do is have a Save button that when clicked will save all the fields on the form as a record in another table. This form would be used multiple times for each month...
  3. S

    Help with date procedure

    From the switch board, the user clicks on the Create Monthly/Quarterly report. This opens a form where they enter the begining month, ending month, begining quarter, and ending quarter. After they type that in they click continue which initializes a macro that runs several queries based on the...
  4. S

    field value based on other fields in form.

    I have a scenario like the following: field1 field2 field3 field4 field5 field5's control source is: =[field1]/[field3] The problem is that, it is possible that both field1 and field3 can be 0. I would like to set field5 to 0 if field1 or field3 are not >0. I just cannot figure out the...
Back
Top Bottom