Error 3071...Why on one machine and not on others 
Author Message
 Error 3071...Why on one machine and not on others

I am getting a error 3071 in a function with the following code:

Public Function NextSun(dte As Date) As Date
    NextSun = dte - WeekDay(dte) + 8
End Function

which simply rounds any date entered to the next sunday...

I get this on one machine and not on any others?

any help would be appreciated..

Thanks



Tue, 06 Nov 2001 03:00:00 GMT  
 Error 3071...Why on one machine and not on others

Public Function NextSun(dte As Date) As Date
    NextSun = DateAdd("d", WeekDay(dte) + 8, dte)
End Function



Sun, 11 Nov 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Excel file opened in IE3 - on one machine starts Excel, others does not

2. Error 3071 (typed incorrectly) when table copied

3. Reserved Error -3071

4. Simple Date SQL Errors on One Machine but not all the rest

5. Procedure working on some machines and not others

6. FileSystemObject: works on some machines, others not

7. FileSystemObject: works on some machines, others not

8. krnl386 error on some computers, not others.

9. Why does commondialogue not work on another machine?

10. krnl386 error on some computers, not others.

11. Why does Access run okay on one machine and SUPER slow on all others?

12. V7 Access code runs on one machine and not another

 

 
Powered by phpBB® Forum Software