Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    Lakeland, FL, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculated Control (Access 97)

    Hello Fellow Loungers! i need help...

    i have place a calculated control on a main form of a tab control w/2 subforms. the calculated control calculates the age based on the date of birth entered into [dob] field. the code workes perfectly on my computer. however, it does not work on other computers nor other servers (??????) i get the error : #Name?

    this is the code i've used:

    =DateDiff("yyyy",[dob],Now())+Int(Format(Now(),"mmdd")<Format([dob],"mmdd"))

    i (and others) are w/o a solution. can you tell me what i should do to correct this problem?

    my director told me that i need to fix the problem TODAY! i'm not sure if he was speaking in jest or not... please help.

    any help you can provide me is greately appreciated.

    dezBar

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated Control (Access 97)

    Have you checked for Missing References? This Post explains how.

  3. #3
    New Lounger
    Join Date
    Jul 2002
    Location
    Lakeland, FL, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated Control (Access 97)

    Thank You! Thank You! Thank You! that solved the problem!!!!!!

    barDez

Posting Permissions

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