Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178

    Unanswered: InputParameters property

    Does anyone know how to set the InputParameters property in VBA? I need to use it for a report I'm working on, and can't get it right.

    Thanks,

    SL

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I think we need more details to answer this.

    For VBA, it's like this:

    Dim SomeVariable as string (or integer or variant)
    Somevariable = inputbox("Enter value:")

    Although I'm not quite sure how this is going to help you for your report. Usually you put this in the query criteria row under the appropriate column (ie. [Enter Value]). Or better yet, design a criteria type form.
    Last edited by pkstormy; 11-27-09 at 05:01.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •