Time and Billing Template Bugs?

[SJS]

I opened the Time and Billng template that came with Access 2003. It is a
2000 template so I thought that it might be a good idea to convert it which I
did using Tools/Database Utilities/Convert Database. Everything seems to
work just fine with the exception of the invoice and the projects screens
which are not listing the totals correctly. (Interestingly this seems to be
the same problem that Eric Zelman encountered in September. However, I can't
see that he managed to find an answer to the problem.)

I thought the problem might have to do with the conversion but I opened the
template again and tried the same data without converting it only to find the
same errors. So, it seems to me that the errors are resident in the
template. Has anyone used this template and overcome the bugs?

Here are the error messages that I am getting in the fields:

Total Hours: #NAME?
Hourly Billings: #NAME?
Total Expenses: #NAME?
Total Billing: #ERROR
Amount Due: #ERROR

Many thanks!

- s

 

[SF]

I opened the Time and Billng template that came with Access 2003. It is a
2000 template so I thought that it might be a good idea to convert it which I
did using Tools/Database Utilities/Convert Database. Everything seems to
work just fine with the exception of the invoice and the projects screens
which are not listing the totals correctly. (Interestingly this seems to be
the same problem that Eric Zelman encountered in September. However, I can't
see that he managed to find an answer to the problem.)

I thought the problem might have to do with the conversion but I opened the
template again and tried the same data without converting it only to find the
same errors. So, it seems to me that the errors are resident in the
template. Has anyone used this template and overcome the bugs?

Here are the error messages that I am getting in the fields:

Total Hours: #NAME?
Hourly Billings: #NAME?
Total Expenses: #NAME?
Total Billing: #ERROR
Amount Due: #ERROR

Many thanks!

- s

I have the same problem and am searching all google for the answer, but to
no avail, if someone know the answer, please post it!
SF

 

[SJS]

Eureka! Thanks to Tom Wickerath, there is a solution! Tom asked me to
correspond with him directly and then spent a great deal of time exchanging
emails and working with me in order to propose a number of different
experiments. His instructions were very specific and easy to follow for a
“newby†and always included screen shots, so that I knew exactly what to look
for. And when I was getting discouraged and giving up Tom kept pursuing
different options until the problem was solved.
As it turned out the solution had nothing to do with registry issues, which
was everyone’s original assumption. Rather it had to do with Macro security
and that there is an effective work about using Sandbox mode.

Thanks Tom!

 

[SF]

"SJS" <[email protected]> schreef in bericht

I thought the problem might have to do with the conversion but I opened

the find

I have the same problem and am searching all google for the answer, but to
no avail, if someone know the answer, please post it!
SF

SJS I found your solution in google groups (not in outlook), in which you
said I had to look at the security level. I first misunderstood and looked
at the overal security, but it's the macrosecurity that did the trick,
thanks it works now!
(at last) ;-)

SF