Hoping to avoid rewriting all of my queries. 1

[Vyurr]

Hello all,

I have created a database in Access 2000 that manages employees training and learning. This database has several reports that provide employee lists and statistics for management. I was recently asked to add a checkbox to the employee form that would denote if an employee is "Off Strength" (layed off). I've added an OFFStrenth field to the employee table.

Aside from rewriting all of the queries (there are several), is there an easier way to filter out any employees that are checked off as "Off Strength" so that they do not appear in any of the reports?

Thanks in advance,

D

 

[GingerR]

Rename your table, then create a query with the filtering you want and name it what your table used to be. Get it?

So say your table was named "EMPLOYEES"
Rename it to EmployeeTable
Then write a query based on that table, with OffStrength as NO, and name the query EMPLOYEES.

This will only work if everything you've written based on that table should be OffStrength = No.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Vyurr]

That worked beautifully!

Thanks so much for saving me hours of horribly tedious work!

D

 

[JoeAtWork]

Off Strength" - that made me chuckle.

Other suggested (less politically correct) field names:
"Yer Outta Here"
"Persona Non Gratis"
"So Long"

 

[Vyurr]

So, I have managed to create a new problem with the database that relates to your previous solution. I have a form that is used to update records in the employee table. Having renamed both my employee table and the "off strength" query to replace the table, I have now run into the issue of not being able to update any of the fields in the form, as they are now linked to a query instead of to the table.

Any ideas what I'm doing wrong, would be of great help.

Thanks,

D

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Vyurr]

Thanks PHV. Much appreciated.

D