Parameter Query Complication?

A

Angela Semotan

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,
Angela
 

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

Similar Threads

Parameter Query and WildCards 0
Using DCount in report with parameter qry 1
Parameter Query 2
Access Report on Parameter Query 3
Has Hierarchy the Parameter between years? 5
entering parameter criteria MS Query 0
Parameter query not returning all results 4
VBA Coding a Parameter Query 1

Top