Recent content by VinceC

I am trying to open up a form (from another form) with a dynamically created filter, however, the form is not applying the filter at all. Also, when I open the form (in design view), the filter property contains the correct filter, it just doesn't seem be applied. Any ideas what I am doing...

Thanks but I already tried that. Even a newly created form seems to disappear when I re-open the database.

All of the forms that existed in a database yesterday have suddenly disappeared today. I can see tables and queries only. If I create a new form it disappears when I re-open the database. I am using Access 2000. Any ideas? Thanks.

Sorry, I'm not sure that the DB is backing-up, perhaps its locked-up. Yes the DB has multiple users, however, there were none using it when I experienced the problem. Sorry for not explaining the problem in more detail. If I get the error again, I will record the error message and explain...

I have an Access 2000 DB that appears to be backing-up on an intermittent basis. Does anyone know why or where this feature is turned on/off? Also, sometimes when I open the DB it says that its locked by another user when this is not true. Can anyone help? Thanks.

No, I have not found a solution ... yet. Although I fear that Pat is correct. Its such a drag, because it seems like a simple thing to do. I played around with the sql statement in the Row Source property of the Lookup for my field in table design. However, I had no luck. I tried to "add" a...

Thanks. I thought that this might be an easy thing to do with tables. I was reluctant to add more objects to the database.

Sorry, I can't seem to find a similar example. My problem is with tables not forms (popular in examples). I just want the 2nd drop down list to be limited to items relevant to the item from the first drop down list when creating a record in my Employee table. I will continue looking through...

I have 3 tables; Employer - eID - eName EmployerGroup - eID (Combo Box lookup of Employer table above) - eGrpID - eGrpName Employee - eID (Combo Box lookup of Employer table above) - eGrpID (Combo Box lookup of EmployerGroup table above) - eeID My problem: When entering data in the Employee...

Thx. I don't want to waste time trying to do something I can't in the report itself.

I have a report that groups by first 3 characters of zip code, its named "FSA". Within the FSA group header section I calculate the sum of a field "InventoryUnits". I would like the report to list each "FSA" group in descending order of "InventoryUnits". Its seems you can only "Group and Sort"...