Welcome to SPN

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

Sign Up Now!

Parameter Query Complication?

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

  1. Angela Semotan

    Angela Semotan
    Expand Collapse

    I run a PARAMETER query with an INTO clause (see below). It works beautifully
    UNLESS the user clicks the “cancel†button on the pop-up input box. When this
    is clicked, an error message appears. The table referred to in the INTO
    clause is then deleted. Obviously, this creates more trouble as further
    queries are attempted. How do I avoid this? I really want the users to be
    able to “cancel†a search, but don’t want doing so to break the interface.

    SELECT Catalog.accession_no, Catalog.abstract, Catalog.subjects,
    Catalog.[journal title], Catalog.author AS Catalog_author, Catalog.title,
    Catalog.volume_issue, Catalog.publisher, Catalog.publisher_location,
    Catalog.pages, Catalog.date, Catalog.isbn, Catalog.issn, Catalog.oclc,
    Catalog.owned, Catalog.holdings, Catalog.language, Catalog.notes,
    Catalog.acquisition_method INTO SrchResTitle
    FROM [Catalog] INNER JOIN Index_Title ON Catalog.title=Index_Title.Title
    WHERE (((Catalog.title) Like "*" & [Enter Journal Title:] & "*"));

    Thank you,
  2. Loading...

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page