Results 1 to 3 of 3
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    Error at end of Northwind tutorial

    In the Introduction to Queries fir on the internet here:



    https://support.office.com/en-GB/Art...a-46502a66c250

    I am near the last step.

    "You can view which products will be detained by an update in Datasheet view.

    On the Design tab, in the Results group, click view and then click Datasheet View."

    When I do that I get the error:


    The expression contains malfunctioned GUID constant


    It then pinpoints this expression:



    Product ID] Like ({Products].[ID])



    In the Product ID column, criteria field.

    I am not sure what they are talking about. What is wrong with this expression?

    Thanks in advance.


    Respectfully,


    Lou_Reed



    Please note this expression was copied from the database.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,648
    Change { to [.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Yes, thanks I just saw it. Sorry about the trouble.

    Respectfully,

    Lou_Reed

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Error opening Northwind template
    By Lou_Reed in forum Access
    Replies: 7
    Last Post: 06-04-2015, 10:37 AM
  2. Another error in Ceil in Tutorial
    By Lou_Reed in forum Access
    Replies: 3
    Last Post: 04-22-2015, 11:15 AM
  3. Error in Ceil Inn tutorial
    By Lou_Reed in forum Access
    Replies: 16
    Last Post: 04-17-2015, 06:57 AM
  4. Northwind Database Tutorial step by step
    By AATQA in forum Access
    Replies: 1
    Last Post: 10-22-2013, 06:20 AM
  5. Northwind Inventory Error
    By jpl85716 in forum Access
    Replies: 8
    Last Post: 09-28-2010, 10:10 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
  •  
Other Forums: Microsoft Office Forums