Results 1 to 4 of 4
  1. 12-24-2013, 12:27 PM #1
    Huddle
    Huddle is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Jun 2010
    Posts
    318

    #Name? Error

    I'm getting an error on the below. Can anyone tell me why?



    ="Changes being made this week for entries between " & [Forms]![Fm_Date_Parameter]![StartDate] & " And " & [Forms]![Fm_Date_Parameter]![EndDate]
    Reply With Quote Reply With Quote
  2. 12-24-2013, 12:56 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Looks okay offhand. Is the parameters form open? If so, double check the spellings of the text boxes.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  3. 12-24-2013, 01:03 PM #3
    Huddle
    Huddle is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Jun 2010
    Posts
    318
    It was that the form wasn't open. I was working in the design mode. Thanks.
    Reply With Quote Reply With Quote
  4. 12-24-2013, 01:05 PM #4
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    No problem.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Error Message on db.OpenRecordset (Compile error Type mismatch)
    By AdamT in forum Access
    Replies: 7
    Last Post: 07-24-2013, 02:01 PM
  2. INSERT INTO Run-time error 3075 Syntax error (missing operator) in query expression
    By SeanA in forum Programming
    Replies: 3
    Last Post: 03-05-2013, 11:17 AM
  3. Error "Run-time error '1004': General ODBC Error
    By D4WNO in forum Access
    Replies: 0
    Last Post: 07-16-2012, 05:42 AM
  4. Run-time Error '3075' - Syntax error (missing operator) in query expression
    By vickan240sx in forum Access
    Replies: 6
    Last Post: 05-30-2012, 12:32 PM
  5. Data Type Mismatch Error In Criteria Expression : Error 2001
    By mkc80 in forum Access
    Replies: 1
    Last Post: 05-11-2012, 10:59 AM

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

Other Forums: Microsoft Office Forums