Search results for query: *

This is going to be hard to explain so please bear with me. I have a training database that keeps track of certain required training for each individual job type. Each job has certain reqired training classes that need to be completed. The company however has about 40 manadatory classes that...

Hi, I have a table with 2 attributes: Position# and Course#. Currently there are 42 positions (1-42). I need a query to show the course# if that course # appears for all the positions (1-42). Thank you in advance

Hi, I have a table with 2 attributes: Position# and Course#. Currently there are 42 positions (1-42). I need a query to show the course# if that course # appears for all the positions (1-42). Thank you in advance

Hi, I hope somebody can help me. I am designing a database that keeps track of training clases that employees have taken. I have a table called "Training completed" to keep track of the classes taken. This table has the fields Training# (autonumber), Emp_ID, Course number (this is...

Hi, I hope somebody can help me. I am designing a database that keeps track of training clases that employees have taken. I have a table called "Training completed" to keep track of the classes taken. This table has the fields Training# (autonumber), Emp_ID, Course number (this is...

I have the attached sql that works perfect(at the bottom of the page). However I thought that I would be comparing about 5 fields but it turns out I have to verify around 100 or so fields. Here's what the code does. I have a table tblEmployee with the fields (EmpId_Num,last...

I have the attached sql that works perfect(at the bottom of the page). However I thought that I would be comparing about 5 fields but it turns out I have to verify around 100 or so fields. Here's what the code does. I have a table tblEmployee with the fields (EmpId_Num,last...

Does anybody out there now how to enable design view on a database if it has been disabled. I have all the steps and VBA code to disable it but not anytthing to enable design view. Please help. I can easily shift into the database and look and modify table contents but cannot modify any...

I am going to apologize in advance for some stupid questions because this is the first time using enteprise. I believe I posted the reports right but when a user clicks on them it asks for a "Database logon - MS access Database" User Id and Password. Everything I put in here does not...

I am getting the error message "The following security plugin is not availiable secWindowsNT. Please contact your system administrator for details." when I try to have users log into the enterprise system. I can not find this plug in. Does anybody know where it can be found.

I have a question concerning a previous question I had posted a couple weeks ago and I thought the problem was corrected but a few days before the report is needed I found out that it still has one minor problem that I can not for the life of me figure out. Heres the problem. This...

I have a question concerning a previous question I had posted a couple weeks ago and I thought the problem was corrected but a few days before the report is needed I found out that it still has one minor problem that I can not for the life of me figure out. Heres the problem. This...

Dan, You might have a join problem with your table. For example: Is the data that disappered have any records associated with it on the other table. For example you might have an employee table and then a Department table. If the employee table has a Dept number field that links it to the...

I have a report that shows the name a an employee then a count of how many forms they have turned in. This works fine and even shows an employee if the count is 0. When I try filtering the data between a certain date the only date returned is if a form is turned in during the certain period...

Just compact and repair it "Tools Menu then Database Utilities". You need to do this two times in a row in order for it to work properly

Ok this is going to be very hard to explain without the database. What I want to do is see which employees do not meet the required training classes and list the employee name along with the class(es) they have not completed. For some reason this is driving me crazy. I can not write the right...