Search results

  1. B

    Automate data entry in one field

    I have a continuous form with properties set for data entry mode. The user opens the form and enters 60 records from a datasheet. The pattern of the values in one field [DropPt] start with 0.5 and sequentially increase by 0.5: (0.5, 1.0, 1.5,... 30.0). I would like any suggestions if anyone can...
  2. B

    Continuous form - enter foreign key once?

    I have a continuous form that is designed for data entry. There are 60 records to be entered from one datasheet and there are hundreds of datasheets. One of the fields is a foreign key that is the same for all 60 records. I would like the data entry person to be able to enter the foreign key...
  3. B

    read cell contents

    Hello, I'm struggling up the steep VB learning curve and trying to write code that will "read" the contents of a cell in a form so that I can search another table for the same string. Hoping someone can read what I have and point out what I'm doing wrong. The user uses the form to enter data...
  4. B

    Question SearchForRecord error says open object is not open

    I'm trying to write a macro that runs after data has been entered into a given field on a form. The first line is OpenTable and the second line is SearchForRecord. While stepping through the macro, the table opens in response to the OpenTable action but on the SearchForRecord action I get the...
Back
Top Bottom