Search results

  1. T

    CanGrow in Form View

    I created a "search" form that contains a textbox which is set up as 4" wide. However, there will be times when the data will be longer than 4" hence, I want to apply CanGrow so that the textbox will grow vertically to accomodate all data. I realize that CanGrow does not work in form view, I...
  2. T

    Validation and SetFocus

    I have encountered a very strange situation which I am wondering if any of you have an insight to. I have a form for which the first field is a bounded combobox (MOD_ID) must be filled. The value can either be entered by the user or selected from a table. In my onExit for this field, I...
  3. T

    Run a make table query from code

    I have a form that performs either a preview or print report. However, before the actual report can be executed (previewed or printed), I need to perform a make-table query. How do I go about coding the form so that the make-table query performs before the preview or print executes? Thanks!
  4. T

    Passing form parameters to query and returning results back to form

    I am really green with this so bear with me, please. I have been charged with creating a form for which a user inputs values into 4 fields. The user will then receive back values of 5 fields based on the input. I have designed a query for this purpose. How can one use the 4 input fields as...
  5. T

    Running or not?

    I am running Access 97. I have a very large report that could exceed 1000 pages. When I execute the report, I get the first page and I am able to scroll through each subsequent page, one by one. However, when I click on the arrow that will take me to the last page, the formatting report bar...
  6. T

    Option Group to prompt user for detail or summary

    I have a form that has command buttons to either (1) preview report, (2) print report, or (3) output to file. I have also added an option group which for Detail or Summary. My question is... How do I get the detail or summary to pass values to the report detail section so that the Visible...
  7. T

    #Error due to empty query

    I have a report which combines the results of a query with "test". For example, =RTrim([CS or Inst]) & " Employment/Affirmative Action Personnel Changes" There are times when the query does not return any records and because of such, #Error will display. How can I prevent #Error and...
Back
Top Bottom