I am developing an Access97 application. Yesterday, I was migrated to a new PC with Windows2000pro from a Windows95 PC. My app did not run on Win2000. It did on Win95.
Problem1
My main form has a begin date and an end date textbox for user entry,but I have set the default = Date(). When I run this form my date defaults display #Name?
Why? What is the/a fix?
Problem2
One of my queries involves parsing a field that has a lastname prefixed by 1-2 char dept code, they are separated by a space. My parse code creating two new fields is as follows:
Dept: IIf([LASTNAME] Not Like “visitor” And [LASTNAME] Not Like “janitor*”,Left([LastName],InStr(1,[LastName],” “)-1),”General”)
The second(false) condition works but I get #Error for everything else.
LName: Trim(Right([LastName],Len([LastName])-InStr(1,[LastName],” “)))
I always get #Error
Seems that my functions are not working. Help!