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

    Ceil Inn tutorial conundrum

    What is going on in this step in the Ceil Inn tutorial? I believe


    that a new customer is being registered, but they only put
    the employee number first and last.

    This is when the database is loaded with data.

    The Ceil Inn tutorial is here.

    http://www.functionx.com/access/appl...ns/ceilinn.htm

    Any help appreciated. Thanks in advance.

    Respectfully,

    Lou Reed

    Employee # Customer Acnt #: Date Occupied Room # Rate Applied Phone Charge Notes
    24095 100752 Monday, January 02, 2012 106 The customer is here for a conference and will occupy the room for a week.
    100752 Tuesday, January 03, 2012 106 85.95
    100752 Wednesday, January 04, 2012 106 85.95
    100752 Thursday, January 05, 2012 106 85.95
    28405 100752 Friday, January 06, 2012 106 85.95

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Do you have a question?
    EVERY record should have Emp#.

  3. #3
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Why do the middle three inputs have no employee number, they have just the customer number is not that an error?


    Respectfully,


    Lou_Reed

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    If you need these to have it then yes it's an error.
    EMP fld should be In the subFrm, and the master form. And in the properties of the subFrm, under
    link master fields,
    and link child fields.

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

Similar Threads

  1. Do.. Loop Conundrum
    By DubCap01 in forum Programming
    Replies: 4
    Last Post: 04-18-2015, 01:10 AM
  2. Error in Ceil Inn tutorial
    By Lou_Reed in forum Access
    Replies: 16
    Last Post: 04-17-2015, 06:57 AM
  3. A Datasheet Conundrum
    By Paul H in forum Forms
    Replies: 1
    Last Post: 10-11-2011, 01:46 PM
  4. Conditional Criteria Conundrum
    By nypedestrian in forum Queries
    Replies: 2
    Last Post: 09-01-2011, 12:23 PM
  5. Replies: 4
    Last Post: 11-03-2010, 08:17 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