Search results

Is there a way to test whether a filter has been applied to a recordset? I want to display different messages on my form depending on whether the current recordset is filtered or not.

I have a combo box on a main form from which I select a ContactID. I want to open a Contact form at the record selected in the combo box. Does anyone know how I can do this without applying a filter?

I created a form with a text box that accepts a search string. I run a query to select all records in a table that contain that string. On my form, I have a subform which displays the results. The problem I'm having is that the subform does not show the results as a list. It shows only 1...

I just started having this problem where, when I attempt to revise my SQL query (View SQL in the SQL Statment Builder), I click the mouse to place the cursor where I want to start typing, and it ends up highlighting everything to the right. Then when I start typing, everything that was...

I have a listbox on a form. It is not multi-select. I want the user to pick one item from the list and click on a command button which will open another form at the record selected in the list box. The command button on-click property involes an event procedure which includes the line...

I have a code database and a data database. Something happened and all of a sudden I can't view the tables from the code database. When I double-click on a table name to open it, nothing happens. Anybody know how to resolve this? I haven't made any security changes.

I've been trying to display a picture in a field on an access form. The table field is defined as an OLE object. In the form, I have created a bound object on the form. When I opened the form I inserted a link to a picture file, a different link for each record. The pictures do not display...