Results 1 to 2 of 2

Thread: simple query with parameters values coming from a simple a form

  1. Nov 15th, 2009, 02:09 AM #1
    bambo
    bambo is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2005
    Posts
    586

    Red face simple query with parameters values coming from a simple a form

    Hi,

    (MS ACCESS 2003)

    I'm trying to make a simple query with parameters values coming from a simple a form.

    The issue is that the values that the query gets from the form are displayed as Jiberish.

    I've narrowed down the query to simply showing a text box value in the form that supposed to be a date filter for the query: [forms]![ShowResults]![SelDate] - it still shows Jibreish !

    However, when I either display this form from a vba code using "msgbox [forms]![showresults]![seldate]" it works fine, also when from the query I convert it to date by cdate ([forms]![showresults]![seldate]) it works fine.

    I can't leave it to convert it to date in the query from performance reasons, since the actual query is quite complex.

    Any ideas how to solve this?

    Thanks!
    Reply With Quote Reply With Quote
  2. Nov 18th, 2009, 06:59 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: simple query with parameters values coming from a simple a form

    What do you mean by "jibreish" - can you provide an example?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width