Recent content by shenlee

  1. S

    Identify filtered recordset

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

    Open Form at Specific Record Without Filter

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

    Open Form at Specific Record Without Filter

    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?
  4. S

    how do you get a subform on a form to show a list of records?

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

    Cursor placement highlights all text to right

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

    "Merging" queries

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

    Use item selected from listbox to open new form for selected record

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

    Use item selected from listbox to open new form for selected record

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

    Can't open linked tables from code database

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

    Can't open linked tables from code database

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

    Can't open linked tables from code database

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

    Can't open linked tables from code database

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

    Can't open linked tables from code database

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

    Can't open linked tables from code database

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

    Can't open linked tables from code database

    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.
Back
Top Bottom