"Time and Billing" database question -- access

See

http://groups-beta.google.com/group/...97a482f446a678


MS Shane wrote:
I too am trying to find a solution for this exact scenario. I have
already tried the macros on low security and have gotten the same
results: 0's and no projects associated with the invoice. This is
better than the #erro messages in the fields, but not right.

I still haven't tried the solution mentioned by Russell (while
looking at the application, hit ctrl-g, and then go debug-Compile
"Time and Billing") and will try that next, but just wanted to let
you all know that I am also running Access2003 and make no changes to
the db as downloaded from MS, I have all latest security patches
running and no other complaints about my machines config. In fact, I
have tried this on several machines and it is the same results.

So I will try a few more things and hope that it works, but if anyone
has any more suggestions, please feel free to bring them to our
attention.

thanks

"Russell Ault" wrote:

I'm fairly certain I did, because when I go into the Global Code
under Modules the Compile option isn't even available under the
Debug menu, it's been greyed out.

"Albert D. Kallal" wrote:

Now, while looking at the application, hit ctrl-g, and then go
debug-Compile
"Time and Billing"

Do you get any errors?

did you try the above?

--
Joan Wild
Microsoft Access MVP

The info in the link works, but only partly. For it to have full effect, you
must also alter similar (but not the same) code in the "Print Invoice" form.
This has worked for me. Also, I have discovered that the "Begin Date" and
"End Date" fields cannot be left blank.

"Joan Wild" wrote:

See

http://groups-beta.google.com/group/...97a482f446a678

It looks like the discussion ended without a solution. Did anyone ever figure
it out, or is it just a crappy template?

"Russell Ault" wrote:

The info in the link works, but only partly. For it to have full effect, you
must also alter similar (but not the same) code in the "Print Invoice" form.
This has worked for me. Also, I have discovered that the "Begin Date" and
"End Date" fields cannot be left blank.

"Joan Wild" wrote:

See

http://groups-beta.google.com/group/...97a482f446a678

Have you followed the steps outlined in the google group thread? That
supplimented with Russell's notes should solve your problem. Are you still
having problems?

As for the usefulness of the template, it might be looked at as a starting
point. I doubt that any of the templates can be used as is; they'd all need
tweaking I would think.

"KHAN SUL-O" KHAN wrote in message
...
It looks like the discussion ended without a solution. Did anyone ever
figure
it out, or is it just a crappy template?

"Russell Ault" wrote:

The info in the link works, but only partly. For it to have full effect,
you
must also alter similar (but not the same) code in the "Print Invoice"
form.
This has worked for me. Also, I have discovered that the "Begin Date" and
"End Date" fields cannot be left blank.

"Joan Wild" wrote:

See

http://groups-beta.google.com/group/...97a482f446a678



--
Joan Wild
Microsoft Access MVP

I checked the Google group link and tried to follow the instructions but I
can't find the "Broken Expressions". I used ctrl-g to get to the modules and
tried to find it there. What am I doing wrong? Also, what is "sandbox mode".
I am reasonably computer literate but not particularly experienced with
Access. When I tried the debug-compile there was no indication of anything
happening.

Thanks!

"Russell Ault" wrote:

The info in the link works, but only partly. For it to have full effect, you
must also alter similar (but not the same) code in the "Print Invoice" form.
This has worked for me. Also, I have discovered that the "Begin Date" and
"End Date" fields cannot be left blank.

"Joan Wild" wrote:

See

http://groups-beta.google.com/group/...97a482f446a678

"Dana" wrote in message
news
I checked the Google group link and tried to follow the instructions but I
can't find the "Broken Expressions". I used ctrl-g to get to the modules
and
tried to find it there.

When you use find, be sure to check off 'search entire project' to find the
code you are looking for.


You may find that going to Tools, Macro, security and setting it to low will
get things working for you.

--
Joan Wild
Microsoft Access MVP