Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2009
    Posts
    14

    Unanswered: No of Arguments that can be passed to a form

    Greetings to everyone.

    I downloaded the SQLBuilder Sample of GeorgeV, where the user can custom build SQLstrings on the fly.

    I have some clarifications on the same.

    The sample form given with the db works for most of the tables. But I have a table with some 30 fields, when I try to use the SQL builder, the results are not displayed (ie the result is empty). The SQL String is working properly if I try to use the same in a query builder.

    I would like to know if there is a limit to the number of arguments that can be passed while opening a form.

    Could someone point me the right direction.

    Regards,
    Sakthivel.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    I'm not sure to understand your question. How do you pass the arguments when you open the form ?

    Have a nice day!

  3. #3
    Join Date
    Jun 2009
    Posts
    14

    Passing Arguments

    Hi,

    Quote Originally Posted by Sinndho
    I'm not sure to understand your question. How do you pass the arguments when you open the form ?

    Have a nice day!

    You pass arguments to a form with the following command

    DoCmd.OpenForm FormName, View, FilterName, WhereCondition , DataMode, WindowMode, OpenArgs

    For more information kindly visit
    Code:
    http://www.blueclaw-db.com/docmd_openform_example.htm
    and
    Code:
    http://www.datawright.com.au/access_resources/access_docmd.openform_arguments.htm
    Last edited by sakthivels; 07-09-09 at 03:51.

  4. #4
    Join Date
    Jun 2009
    Posts
    14

    Oops !

    Hi Guys Sorry for troubling everyone. I solved the problem. What a fool I am, I was using a reserved Keyword as one of the field name and that was creating a problem.

    Anyway thanks so much for anyone who tried to help me out.

    Regards,
    Sakthivel.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Thanks for posting the solution!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Now I've learnt something !

  7. #7
    Join Date
    Jun 2009
    Posts
    14
    Glad to hear I was of help to someone.

    Cheers for everyone.

Posting Permissions

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