New If Statement Post

J

John Vinson

It says cant find the form TimeCards

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]
 
J

John Vinson

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.

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]
 
D

Dave Elliott

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.
 
J

John Vinson

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'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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top