Module Calculation Doesn't Work only on a specific PC

[Neilbees]

Hi

I wonder if anyone can help me with a weird problem I'm getting at the moment. I use a module to calculate working days in various databases I've set up - has always worked fine.

However, I do my job from 2 separate sites and last week set up a few unbound text boxes in a form as users wanted to see a quick working days calculation betwewen 2 dates they enter. Set that up and all was fine. However, I'm now sitting in the other office looking at the form and I'm getting a #Name? error in the text boxes in question. I phoned the other office and it's working fine over there - calcualtes working days and displays a number.

To increase the strangeness, the calculation works fine in queries in the same database. Can anyone suggest why I'm getting the error on my form only on my pc?!?!?

 

[Darth Vodka]

Hi

I wonder if anyone can help me with a weird problem I'm getting at the moment. I use a module to calculate working days in various databases I've set up - has always worked fine.

However, I do my job from 2 separate sites and last week set up a few unbound text boxes in a form as users wanted to see a quick working days calculation betwewen 2 dates they enter. Set that up and all was fine. However, I'm now sitting in the other office looking at the form and I'm getting a #Name? error in the text boxes in question. I phoned the other office and it's working fine over there - calcualtes working days and displays a number.

To increase the strangeness, the calculation works fine in queries in the same database. Can anyone suggest why I'm getting the error on my form only on my pc?!?!?

erm...

is it your log on or your PC?

how does it calc working days? by looking at another DB?

 

[Neilbees]

The only place that the calculation produces the error is when I use this PC at work. It works fine on my other PC, and on my laptop at home. I've also checked on a few other PCs and it works!

The Working Days calculation comes from a Module. There's no problem with the calculation in queries or in all the other databases I work on - just on this PC on this form!

Any ideas?