Search results

Solved In case anyone is interested, I solved my issue with a simple workaround. I converted all of my checkboxes to listboxes (and added the label text to each box), made them the same size and shape of a checkbox, changed to font colour to white and added coding for the dbl-click event to...

Good point. I already have a table with users, but adding a separate skills one along with the bridged one is a good idea. Thanks. You have provided me with a good example but not an adequate one for what I'm trying to accomplish. I don't think you truly understand what I'm trying to do if...

Thanks for the example. My tables all have different column names and I would be searching through all table columns for each search. I'm not looking to select each field name for each search because there will be 100's of fields in that list. Also, I'd want to be able to enter a search query...

No, you're right. I would only want ID 3 to show up in that case. My mistake. I have about 12 tables altogether and yes I'd want them all searched every time a search is conducted. I have also considered switching all of those fields to multi-select listboxes, however, only as a last resort...

Yes of course. I have attached a sample table with check boxes along with 2 example search forms. I would like to enter a few keywords and have the table searched (mainly the column names) for those key words, but only returning rows that have -1 (true) checked boxes. e.g. Keyword1: Database...

I'm searching for the column names. The database is set up as a multi-user database where users log on and fill out forms. So, each line on a table is specific to a user. What I would like to do is be able to search through those tables (which are set up with check box fields only), and have...

Hello all, I've recently finished constructing a database that uses forms with checkboxes i.e. when a user opens a form there are several checkboxes associated with labels, but the table only stores the check-boxes and the form labels are the field (column) names on the table. Now, what I'm...

I'd just like to take a moment to introduce myself. My name is Tony and I'm fairly new to Microsoft Access. I'm far from being a good programmer but I do know how to use VBA a little and I'm quite comfortable using the non coding elements of Access. Currently I'm residing in Canada and I work...