 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / November 2005after update stopped working
Hello I wonder if any one can help me. ms access 2000, pro win xp home I use a form in datasheet view to enter dates of death, ages of death and date of birth. I calculate year of birth if no date of birth by the following code in the after update event of the year of birth field YoB = YEAR(DoD) - AoD Year of birth = year of death - age of death -- in english this worked fine until a few days ago and has now stopped working. Any help will be greatly appreciated Thanks in advance The expression looks okay. Did you recently add something (e.g. a field) named Year? If so, the object and the function name may be conflicting. If so, it would be better to rename the object, but you could get away with: YoB = VBA.Year(DoD) - AoD If that is not the issue, you may have a problem with references. See: http://allenbrowne.com/ser-38.html  SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > Hello I wonder if any one can help me. > ms access 2000, pro win xp home [quoted text clipped - 7 lines] > Any help will be greatly appreciated > Thanks in advance Hello thank you for you reply I did do some messing but can't remember what I did will try out your suggestion thank you very much Best Regards |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.