Search results

this is what I did. I didn't remove any of the old code, I just commented it out so it is still there, but the program does not read it. Did I do it right? Why is it still not working? Private Sub Search_Click() Dim db As Object ' The .mdb file that was selected in optgrp1 Dim SearchTble...

What it is doing is this. It seems to be searching the databases and tables I asked it to, but when it is done it is supposed to open the trk_searchresults table and show me it's findings. This table does not open, and when I manually open the table there is nothing in it. I know for a fact that...

Thanks for the help. Here my whole code for the "onclick" it does not seem to work write. Any ideas why? Private Sub Search_Click() Dim db As Object ' The .mdb file that was selected in optgrp1 Dim SearchTble As String ' The table within the Database to be searched Dim SearchData As...

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?