My company uses a database to keep track of video stock, the old database has a "find" button which launches a "Find and replace" window (the same as if you were to press Ctrl+F) then you have to select "whole database" and "any part of field" in order to search for a term in the database.
This is obvoiusly a pain and i have tried making a form based input to get around this, but doing this you can only have a query running on one field in the database.
it needs to work in the same way as the find and replace box, but without the user having to select "whole database" and "any part of field" (this is always the case), ideally this will be done from a form, but that is just cosmetic and doesnt really matter
Its a tape catalogue, my company has various video cassettes both filmed by us and others, Each tape has a title and subtitle, an individual number, and a description field.
For example, if a tape has more than one programme or is "rushes" (unedited footage) it may have more than one different thing on the tape, hence the least important of the two would be listed in the description field, as opposed to the title. Also for "rushes" tapes, there may just be one 10 second long good clip that is listed in the description field taht we may want to re-use.
Also we have compilation tapes which include more than one programme, so if we were to look for one programme on a comp tape, the individual programmes would be listed in the description field not in the title or subtitle.
And please do not suggest changing the database format, it has over 2000 entries and im trying to avid that at all costs. You are quite right, im very frustrated with this project.
Originally posted by ravislayer
Right, now step by step where i type that stuff because im a video editor not a computer technician, im using access 2003
Please keep your frustration in check, I enjoy helping folks out, but it's much easier if they remain calm
The code that I posted was SQL that you can attach to a listbox or where-ever you'd like to see all the matching results displayed.
You could create a text box, a command button, and a listbox on a form to do this.
The text box would be for your user (or you) to enter a string you'd like to search for. Then you could press the button, and any relevant results would be dumped into the list box.
So you need to put some code in the "onClick" event of your command button. You can get there by right-clicking a control select preferences then go to the Event tab, and clicking the elipses on the right of the filed, then double clicking Code editor.
In the Onclick, you can write some code that will populate your listbox:
YourListbox.RowSource = "SELECT * FROM yourTable WHERE yourField LIKE '*" & yourTextBox & "' OR nextField LIKE " etc etc