New If Statement Post

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
It says cant find the form TimeCards
Click to expand...

THANK YOU.

That's the problem then. The form TimeCards is evidently not open.
This query will not work unless there is a Form named TimeCards and
that form is open at the time the query is run. This does not appear
to be the case.

John W. Vinson[MVP]
 
The for TimeCards (This is the main form) is open and the sub-form
TimeCardPaymentSub (Sub-form) is on this form.
I even opened both forms and ran the code, but this time it says it could
not find TimeCardPaymentSub
Code is being triggered from another sub-from named Vendor_List on the main
form.
 
The for TimeCards (This is the main form) is open and the sub-form
TimeCardPaymentSub (Sub-form) is on this form.
I even opened both forms and ran the code, but this time it says it could
not find TimeCardPaymentSub
Code is being triggered from another sub-from named Vendor_List on the main
form.
Click to expand...

It sounds like the form may be corrupt.

I'd suggest (if you have not done so) Decompiling and then Compacting
your database, and then compiling and compacting again. Instructions
at http://www.granite.ab.ca/access/corruptmdbs.htm.

You might even need to use Application.SaveAsText to write the form
out to disk, and then Application.LoadFromText to restore it.

John W. Vinson[MVP]
 
I show no symptoms of corruption, even after checking with article.
Even so I decompiled, repaired and compiled again with the code still not
working.
Everything else works fine with NO errors.
Thanks for your help though.
 
I show no symptoms of corruption, even after checking with article.
Even so I decompiled, repaired and compiled again with the code still not
working.
Everything else works fine with NO errors.
Thanks for your help though.
Click to expand...

I've been working on this too long to give up now!

Dave, if you're willing, please compact the database, WinZip it, and
email it to me at jvinson <at> wysardofinfo <dot> com. There's got to
be some sensible explanation why this isn't working, and I'm just not
seeing it.

John W. Vinson[MVP]
 
Back
Top