Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

customize a parameter value box

Discussion in 'Information Technology' started by Stout_cns, Jul 28, 2006.

  1. Stout_cns

    Stout_cns
    Expand Collapse
    Guest

    how do i customize a parameter value box? by putting my own backgroud image,
    choosing the title i want, adding menus etc.? then how would i attatch this
    parameter value box to a form or report, or to a switchboard item when the
    user clicks to retrieve certain/limited information from a report (for
    instance only the students in Mr. B's class)?

    someone said to create a modal form and use unbound ojects as criteria, but
    how?

    please help
     
  2. Loading...


  3. Wolfgang Kais

    Wolfgang Kais
    Expand Collapse
    Guest

    Hello "Stout_cns".

    "Stout_cns" wrote:
    > how do i customize a parameter value box? by putting my own backgroud
    > image, choosing the title i want, adding menus etc.? then how would i
    > attatch this parameter value box to a form or report, or to a
    > switchboard item when the user clicks to retrieve certain/limited
    > information from a report (for instance only the students in Mr. B's
    > class)?
    >
    > someone said to create a modal form and use unbound ojects as criteria,
    > but how?


    Create a form that has no record source.
    Add textboxes or combo boxes that allow the user to enter the criteria.
    Add an OK button that does whatever you want using the paramteter
    values. For example:
    use a query that uses Forms!YourParameterForm!aTextbox as criterion.
    Or pass the criteria to a form or report using the WhereCondition
    argument of the DoCmd.OpenForm or OpenReport methods (VBA).
    The only thing I'm not sure about is "menues". I think you will have to use
    the menu bar from Access (which is btw. not available to modal forms).

    --
    Regards,
    Wolfgang
     

Share This Page