Search results

  1. B

    Refreshing embedded forms

    I have a form with several other forms embedded in it. In one of the particular sub-forms i wanted to have one text box where you type in a number and another textbox that displays an automatic description corresponding to this number. The sub form works fine on it's own - i set a condition...
  2. B

    Open data from table in VB code, then display output in report

    I'm not entirely sure I understand - I can't use a table to put the information in directly. I'm writing a database that diplays and prints reports that display the maintenance licences for the helicopter pilots at my base. The secretary uses a form to update pilot information. ID No is a stamp...
  3. B

    Rolling Average

    Is there any way i can calculate a rolling average for a field in a record, based on the 10 previous records? Cheers, Ben
  4. B

    Refer to previous record in current record query

    In my query, i want to automatically display the value of another field from the previous record in a field in my current record. i.e. Name Value Previous Record 1 1 Record 2 2 1 Record 3 7 2 Record 4 1 7 Is it...
  5. B

    Open data from table in VB code, then display output in report

    I have a table that has fields: ID NO (Autonumber), A(checkbox), B(checkbox) and C(checkbox), with many hundreds of records. I have a report based on a query for this table, that selects a particular record based on the user entering the desired ID NO. In my VB code for this report, i want to...
Back
Top Bottom