Recent content by shenlee

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.

Is there a way to get rid of the filter? Wayne, That's how I am doing it now but it opens the form with just the one record being accessible. Do you know if there is a way I can open the form to that specific record but still have access to the other records in the table? I have been trying...

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...

Can you tell me how to post a totally new thread? The only thing I seem to be able to find is "Post Reply"...Where do I go to post a brand new thread?

THANKS! It works now! It's amazing how one small error in code can cause so many problems!

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 think you are right. The only way to fix this is to start fresh. Thanks for all of your input. I appreciate it greatly.

This is a single user installation. I'm in development mode right now so I'm the only one using this application. I think that something is screwed up in Access, like a switch has been set and I can't reset it. When I create a new database and link to new tables, everything is OK. It just...

The first time I double-clicked and encountered a problem, I got an error message saying I could not open the sheet in datasheet mode. On subsequent attempts to open any table, Access would pause briefly and then just do nothing, no message, and no window opens.

I am able to run a query on the table and see all of the records. I used the default security settings when I created the database and didn't change them. I compared the security settings on the problem databases to databases that are ok and they are the same.

Not that I'm aware of. When I first created the two databases, it worked fine. Then I made copies of them in a different folder. I then relinked the tables to the new location. After that it didn't work anymore.

Yes they are linked tables, I have refreshed the link and there is data in the tables.

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.