WHAT IS A QUERY TICKLER?

[Guest]

I get a error message of "Error 3078 Microsoft Jet database engine cannot
find the input table or query tickler, make sure it exists or is spelled
correctly". I can still get to my table but it always askes for this before
allowing me to eenter.

 

[Guest]

At one time there was a table or query named Tickler, that has since been
deleted or renamed. My guess is that there is (or was) a lookup field that
called this table, and you are seeing the remnant of it. This is yet another
reason NEVER to use lookup fields.

You might try looking at each field's properties in Design View, and at the
table's properties in Design View. Eventually, you should be able to spot it
in a Select statement or a table subdatasheet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Joan Wild]

It sounds like you downloaded the Contacts database template and have since
been modifying it (like deleting the table or query named tickler).

If that's the case you need to check the code in the startup form. I
believe it is trying to open a form based on this table or is running code
that accesses this table. Just comment out the code.

 

[Guest]

If you do not find it in the manner of the other two post then try using the
menu TOOLS - Analyze - Documentor. Save the results to Word and search for
Tickler.

 

[(PeteCresswell)]

Per Joan Wild:

It sounds like you downloaded the Contacts database template and have since
been modifying it (like deleting the table or query named tickler).

Also sounds like a pretty good story to tell somebody when describing the
benefits of following basic object naming conventions like "tbl...", "tlkp...",
"qry...", "frm..." and so-forth.

 

[Joan Wild]

Per Joan Wild:

Also sounds like a pretty good story to tell somebody when describing
the benefits of following basic object naming conventions like
"tbl...", "tlkp...", "qry...", "frm..." and so-forth.

Perhaps, but if one downloads a template from MS they're not likely to go to
the trouble of changing all the names.