WHAT IS A QUERY TICKLER?

#1 (**permalink**) 04-Nov-2005, 15:20 PM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6645-what-is-a-query-tickler.html
allowing me to eenter.

*

#2 (**permalink**) 04-Nov-2005, 15:20 PM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6645
called this table, and you are seeing the remnant of it. This is yet another
reason NEVER to use lookup fields.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6645

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

"raygun" wrote:

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

#3 (**permalink**) 04-Nov-2005, 15:20 PM

It sounds like you downloaded the Contacts database template and have since
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6645
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.

--
Joan Wild
Microsoft Access MVP

raygun wrote:
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6645
> askes for this before allowing me to eenter.

#4 (**permalink**) 04-Nov-2005, 15:20 PM

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.

"Arvin Meyer [MVP]" wrote:

> At one time there was a table or query named Tickler, that has since been
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6645
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6645
> 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
>
>
> "raygun" wrote:
>
> > 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.

#5 (**permalink**) 04-Nov-2005, 15:20 PM

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...",
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6645
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6645
"qry...", "frm..." and so-forth.
--
PeteCresswell

#6 (**permalink**) 05-Nov-2005, 12:48 PM

(PeteCresswell) wrote:
> 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.

Perhaps, but if one downloads a template from MS they're not likely to go to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6645
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6645
the trouble of changing all the names.
--
Joan Wild
Microsoft Access MVP