Web Development

Ask something
Discussion Locked

Access97 function probs in Win2000

0 helpful
3 replies

by bradsq&a

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!

3 replies

by sl-campbell

Make sure you have SP2 for Windows 2000 (which also loads the MDAC 2.5 SP3 from 06.95.2001 that you also need). (But first, if you are using ACCESS 97 make sure you have SP2 and then make sure you have JET SP3).

You can get all these from the MS site. If you need help in getting these or if after updating find out the problem still exists, add a comment to your question!

by bradsq&a

I had already installed W2000 sp2 and had removed and reinstalled Ofc97.
I was helped somewhat by MS Q194374 that referred to functions not avail in expressions. The document suggested various related solutions that dealt with References. It pointed me in the right direction and while there I observed a Missing reference: Microsoft Windows Common Controls V6.0 (sp4). I deselected. I had earlier selected the Microsoft Common Controls V5.0 that I had on my previous system. The combination seemed to do the trick.

This discussion is closed to new replies.