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

    Error in tutorial Lesson 37

    Again on the same Lesson found here:http://www.functionx.com/access/Lesson37.htm

    I enter

    Name: txtTotalRateApplied
    Control Source: =Sum(RateApplied)
    Format: Fixed

    and so for the next two entries. Now when use =Sum(RateApplied)
    I get a green triangle in the upper corner. It is an Error. However, if I just do it this way

    Sum=RateApplied

    without the parenthesis, then I get no errors. Again, I am using MS Access 2010
    and this is I think a version issue. You already said the tutorial was for Access 2007.

    Any help appreciated. Thanks in advance.


    Respectfully,



    Lou Reed
    Last edited by Lou_Reed; 09-25-2015 at 01:33 PM. Reason: error

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    No link to the lesson.

    The first expression should work. The second should error.
    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
    The link has now been put in.

    There is I believe a break in the lesson. Although the sequences are properly
    numbered.

    At 33. in Practical Learning : Designing a form or Subreport

    We are building a subform, sbfCustomersUse. At the end of the that section it says to

    put the value I listed previously; =Sum(RateApplied); Sum=(TotalPhoneUse); =Sum(InternetFee). below the form footer.

    It is not shown on any thing else.

    Again, I get the green triangle in the upper left corner of each of the 3 textboxes and #Name? when I switch
    to form view. I do not whether to correct the three or just delete them.

    Any help appreciated.

    R,

    Lou Reed

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Are you sure those fields are in the RecordSource?

    Type with the [] and see if that helps.

    =Sum([RateApplied])
    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.

  5. #5
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    RateApplied
    TotalPhoneUse
    InternetFee

    Your underlying record source must have these exactly named fields. the [] that J7 recommends is always good advice as well.

  6. #6
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I am attaching my Ceil Inn 4 MS Access 2010 database. I am unsure what is going on.

    I followed the instructions. I am not sure what the issue is.

    Thanks in advance.

    R,


    Lou Reed
    Attached Files Attached Files

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Posted field TotalPhoneUse is actually PhoneUse but it is correct in the form.

    I simply corrected the expression by typing = sign in correct position and deleting the existing = sign. As soon as I pressed Enter, Access immediately fixed the expression to include the []. No more errors and calc results show on form.

    =Sum([RateApplied])
    =Sum([PhoneUse])
    =Sum([InternetFee])
    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.

  8. #8
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I typed the equals sign in the correct (or what I thought was the correct) position on the form, but I did get any response, except what I showed you before which was an error. How is yours different?

    Respectfully,

    Lou Reed

  9. #9
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Okay, I see where the = sign must go. I guess that I have been programming much to long. I know now that I entered
    it incorrectly.

    R,

    Lou Reed

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

Similar Threads

  1. Error in tutorial
    By Lou_Reed in forum Access
    Replies: 2
    Last Post: 09-14-2015, 02:02 PM
  2. Error in Lesson 28
    By Lou_Reed in forum Access
    Replies: 18
    Last Post: 08-26-2015, 02:14 PM
  3. Error at end of Northwind tutorial
    By Lou_Reed in forum Access
    Replies: 2
    Last Post: 06-05-2015, 01:51 PM
  4. Another error in Ceil in Tutorial
    By Lou_Reed in forum Access
    Replies: 3
    Last Post: 04-22-2015, 11:15 AM
  5. Error in Ceil Inn tutorial
    By Lou_Reed in forum Access
    Replies: 16
    Last Post: 04-17-2015, 06:57 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