Search results

I am trying to write code for Running SQL statements on linked tables in Access. It does not seem to be working for me. Here is the SQL statement I have so far. Can anyone please help me figure out what went wrong? Searchsql = "Select [" & SearchTble & "].* from [" & SearchTble & "] Where...

Here goes. I have a text box on my form right now. I also have option buttons to determine were to pull information from. What to do is this. When the CD option is selected, I want the form to find all the .mdb files on the CD, open them up, and list all the tables in these .mdb files in the...

When I am creating a form in Design view, what option on the Toolbox do I pick to create a field that will allow the user to enter search criteria?