Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

query to search table in access 200

Comment:

I am trying to create a search function in a form. it wil search the specified table and return the results in a subform on the same form. This is the code i am using Private Sub btnRubriekZoeken_Click() Me.[OverzichtRubrieken].Form.RecordSource = " SELECT r.rubrieknummer , r.rubrieknaam , r.volgnummer , r.ouderRubriek FROM Rubriek r " & _ " WHERE r.rubrieknaam LIKE '*" & Me.vakZoekRubrieknaam.Value & "*'" End Sub This same code with a different names ofcourse works in another form but somehow on this form it wil only check the first row of the database and show it if the it meets the search requirement, help would be appreciated. maybe it is a setting in access itself that i have to change. thx in advance JB

database backup

bios password

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Sorry, I was'nt very clear. I have set up a macro with an import specification for a text file which has records for 4 fields, into a table. For example the file which has: Product Date Quantity Co...

Summary: I want to use macro in access to create a new column in several different tables. These columns shall consist of a prefix that I choose, typically "PM_" and then an objectID from the ObjectID column s...

Summary: I have an old DOS program that saves data to a .dbf database file. I would now like to add data to the .dbf file through MS Access. I have successfully created a link to the table in Access and have...