Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

WHAT IS A QUERY TICKLER?

Discussion in 'Information Technology' started by raygun, Nov 4, 2005.

Tags:
  1. raygun

    raygun
    Expand Collapse
    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.
     
  2. Loading...

    Similar Threads Forum Date
    Query about Jhatka Meat by Shooting in Head Sikh Sikhi Sikhism Aug 26, 2011
    Who is a sikh? A non sikh friend's query!! Sikh Sikhi Sikhism Apr 30, 2010
    General Query Hard Talk Sep 4, 2008
    Power of pauri's in Japji Sahib query Sikh Sikhi Sikhism Aug 17, 2006
    Sikhism a query Book Reviews & Editorials Aug 2, 2005

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    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


    "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.
     
  4. Joan Wild

    Joan Wild
    Expand Collapse
    Guest

    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.


    --
    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
    > askes for this before allowing me to eenter.
     
  5. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    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.

    "Arvin Meyer [MVP]" wrote:

    > 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
    >
    >
    > "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.
     
  6. (PeteCresswell)

    (PeteCresswell)
    Expand Collapse
    Guest

    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.
    --
    PeteCresswell
     
  7. Joan Wild

    Joan Wild
    Expand Collapse
    Guest

    (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
    the trouble of changing all the names.
    --
    Joan Wild
    Microsoft Access MVP
     

Share This Page