Search results

  1. P

    Filter form based on another table

    I have one form I'd like to filter, and three tables. Tables: Students, Hosts, Matches Form: Students (pulls data directly from the Students table) Matches is a junction table between Hosts and Students. I'd like to filter the Students form such that only those records show up that have no...
  2. P

    Dynamic field contents

    Is there a way to make the value of one field change dynamically based on the values in other fields on the form? Here's the general idea. I have two tables. RecordTable -------------- SiteID, etc. SiteTable ------------- SiteID, SiteBlurb I want have a form, where you can change the SiteID...
  3. P

    problem with .ldb file

    When I try to open an one of our access databases, I get this error. The database has been placed in a state by user 'Admin' on machine '98suf89s87d89s' that prevents it from being opened or locked. I did an exclusive open earlier today and since that time, I haven't been able to get back into...
  4. P

    Multiple users in one database

    Is Access set up to handle multiple people entering data into the same table? We are processing returned mail and enter all the bad addresses into an Access table. The data is simply entered into the bare table. Can two people be doing this at once without the risk of compromising the data?
  5. P

    Applied security to DB, now locked out

    I used the available wizard in Access to set up security for the database I'm building. The only problem is that it won't recognize any of the usernames or passwords that I specified. In other words, I'm completely locked out of the database I've been building. It created an unencrypted...
  6. P

    Printing filtered reports

    I have an odd problem. I have a small for make up so that you can select how to filter a report. There are two combo boxes where you can select a range of dates, and any records within that range will be displayed on the report. There are two buttons on the form. One to preview the report...
Back
Top Bottom