Hello,
I am trying to import a csv file from http://export.gov/ecr/eg_main_023148.asp Downloading the Consolidated Screening List and be able to create a search form.
The idea is to tell me if a name, or partial name exists.
I know how to import the CSV or Excel file into Access (into its own table), or have Access link to it, so that it does not have to be re-imported everytime.
I am having problems creating a search box that will provide me with the full line of detail.
Example: I want to find the word plenty. I could easily search in Excel and it will find no results. But I would like it to tell me no results found, a time and date stamp of the time of my search. However, if the word "lent" was searched, any row in which "lent" was found would show up below it, with a time and date stamp on the page.... this could even be a report instead of a query.
Another example: If I am searching for the word "tent", I would like to see a report that brings up any row that has a partial of the "tent" showing.. so if a row had any word in it like reTENTion, or deTENTion, the entire row would appear.
So, in my mind, and it may not be this simple, but I have a search box, where I enter a word... and either below, or in a separate report, any time the word, or partial word appears, I see the entire row... and if possible, say No results returned if none... and the date and time...