Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am addressing an issue one of my students has. I cannot look at her db because MCI strips it from her email when sending it to me for a closer look, however, she has given me a decent description of the problem, I just don't see anything wrong with what she has typed for the formula...could you read her description and tell me if you can pick up anything?

    I am trying to create a Calculated Control in Design View
    in a Report that I have. The Control Source is DON and this is a time/date
    field. I want the report to show this date plus 2 years. This is the date
    that the next DON training is due. I put in the formula =[DON]+730 and I
    get the error code "This Control has a reference to itself.". I have tried
    different things and looked in another Report that has this exact formula
    and it works fine, but I couldn't find my error on this report.

    Thank you for your feedback...she also is not allowed to go to the lounge from her job, as MCI also blocks access to it, however as a prior student, I have always told them that if they write me and I don't know the answer, I will go to the lounge for them...so hear I am. I will relay anything you have to say about her question to her (and act as the middle person here)

    Thank you
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    You don't mention the version, but some versions of Access are picky about this sort of thing. The other issue may be the the text control on the report may have the same name as the field in the data source, and that is confusing Access. In any event, I usually recommend putting this sort of thing in the data source (typically a query with a calculated field). Also note that the formula is not exact because of leap years. I would suggest using the DateAdd function instead, and simply adding 2 years in the query behind the report.
    Wendell

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='teachesms' post='770186' date='12-Apr-2009 18:24']I put in the formula =[DON]+730 and I get the error code "This Control has a reference to itself.".[/quote]
    What is the name of the textbox where she enter the formula ? Is it DON ? Then she should change it to anything else.

    If she want to send you her DB, she should zip it.
    Francois

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='Francois' post='770190' date='12-Apr-2009 12:33']What is the name of the textbox where she enter the formula ? Is it DON ? Then she should change it to anything else.

    If she want to send you her DB, she should zip it.[/quote]


    No...MCI strips attachments of all kinds, zipped and anything else. Possibly changing the extension before she sends it (maybe as a .txt file)...then before I open it, change it back. I did not ask the version, so best do that as well. I will however pass the info about canging the textbox name to something else.

    Thank you
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='WendellB' post='770189' date='12-Apr-2009 12:31']You don't mention the version, but some versions of Access are picky about this sort of thing. The other issue may be the the text control on the report may have the same name as the field in the data source, and that is confusing Access. In any event, I usually recommend putting this sort of thing in the data source (typically a query with a calculated field). Also note that the formula is not exact because of leap years. I would suggest using the DateAdd function instead, and simply adding 2 years in the query behind the report.[/quote]

    Wendall,
    Will pass your info on. Also asked the version. Basing it on a query sounds good to me. Will let you know if this helps.
    Nannette
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='Francois' post='770190' date='12-Apr-2009 12:33']What is the name of the textbox where she enter the formula ? Is it DON ? Then she should change it to anything else.

    If she want to send you her DB, she should zip it.[/quote]

    Francois,
    Just so you know, this is the response that worked for her. I do appreciate you and Wendall's help on this. I am so appreciative.
    Nannette
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •