Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2013
    Posts
    163

    Unanswered: Parameters Setting

    Dear Seniors,

    I had created the query with Parameter values, say cut off date and it works fine.

    But the problem is I face some problems when the parameter is entered in wrong format. Is it possible to have date picker for selecting the dates in parameter, similarly drop down box for selecting other values.

    Also some time my query is taking long time to show the result and export to excel, How to get the result very quickly? It will be done when I put primary key for all my tables?

    Thanks and Regards
    R. Vadivelan
    Thanks and Regards
    R. Vadivelan

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    Be sure of your Date entry format, if you have the param in the query use:
    format([Enter Date],"mm/dd/yyyy")
    or however you need...this way access wont get confused.

  3. #3
    Join Date
    Oct 2013
    Posts
    163
    Dear Ranman,

    I agree with this. However Is it possible to have date picker option when the parameter need to be entered.
    Thanks and Regards
    R. Vadivelan

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    yes
    the date picker should return a date variable so there should be no confusion with date foimats
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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