Recent content by pesto

You're a genius. Thank you.

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

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

Well, the problem seems to have fixed itself. Thanks for your help everyone. ;-)

I did a quick search and found this thread. http://www.access-programmers.co.uk/forums/showthread.php?t=111240&highlight=security I opened the .ldb file in Notepad and here is what it says. 08FSA53113LH Admin 08FSA53113LG Admin I can't think who Admin would be, unless that's a...

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

Will do. In the mean time, should we limit use of the database to one person at a time?

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?

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

Update. When I print, Access is using the filter in the filter property of the form, not the filter I am trying to apply using VBA.

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