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 in tutorial

    In the following tutorial http://www.functionx.com/access/Lesson34.htm where it says

    Practical Learning: Configuring Lookup Fields


    ...

    5. In the top section of the table click RoomID.

    6. In the bottom section of the table in the Lookup tab, click Row source and click it ellipsis
    button.

    7. In the list of fields , click Type




    Here is where it fails for me:

    In the list of fields there is no Type to click. Is this an error?


    Respectfully,


    Lou Reed

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Its possible. you cannot do lookup on an autonumber field.
    the elipsis button should let you build a query here. Not type 'TYPE'. (that is confusing)

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    If there is no 'Type' field to select then it doesn't exist in the Rooms table.
    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.

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

Similar Threads

  1. Error at end of Northwind tutorial
    By Lou_Reed in forum Access
    Replies: 2
    Last Post: 06-05-2015, 01:51 PM
  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. need Free tutorial
    By newtoAccess in forum Access
    Replies: 4
    Last Post: 10-26-2011, 12:00 PM
  5. VBA tutorial
    By gap in forum Programming
    Replies: 2
    Last Post: 07-14-2011, 07:34 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