Thread: Access problem

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2006
    Location
    Colonie, New York
    Posts
    1
    Rep Power
    0

    Access problem


    I'm doing a crosstab query that uses a date the user has to fill in on a form. The format of the date is mm/dd/yyyy. I get an error message "The microsoft jet database engine does not recognize '[forms]![frmreportoptions]![txtfromdate]' as a valid fieldname or expression".

    How do I code around this?
  2. #2
  3. Type Cast Exception
    Devshed Supreme Being (6500+ posts)

    Join Date
    Apr 2004
    Location
    OAKLAND CA | Adam's Point (Fairyland)
    Posts
    14,954
    Rep Power
    8617
    Take the user input and put it in the query through normal string operations. You can't reference the forms collection in a query.

    Moving to VB because when you get to that point it's a VBA matter.
    medialint.com

    “Today you are You, that is truer than true. There is no one alive who is Youer than You.” - Dr. Seuss

IMN logo majestic logo threadwatch logo seochat tools logo