Search results

Ok I figured out one problem; I add a join table between tblemploy and tblTrainingRoster. But I still need help with the form.

I have a report I am trying to build; I need it to give me the percentage for the number of employees in a company that has completed training “A” Along with the names of those who attended the training. It should also show any other training the company has completed. tblCompany; CompanyID...

Ok I had to make some changes to my tables, they are as fallows; tblSoldiersData stayed the same tblWeaponData no longer has the qulification data NEW TABLE tblWeaponQualData, QualType, QualDate, WeaponQualDataID, fk_WeaponDataID Still need a query to make a report to tell me if soldier with...

Hello, I have the parameter query and the form that uses the parameter query to open with the records the user wants to look at. What I need is for the report to open with the same records the user wants with a click of a button. Im thinking i am have a problem with my (where clause) in the...

The query and from are working, but a button assigned to the report on the form is not working. How do I get the report to open based on the users input on the form. Example: * Open form * it ask for input * form opens and show the recordes the users requested on the form * user needs to...

The query and from are working, but a button assigned to the report on the form is not working. How do I get the report to open based on the users input on the form. Example: * Open form * it ask for input * form opens and show the recordes the users requested on the form * user needs to...

Thank you it worked perfectly.

I have a query that when ran I would like it to ask for input. I need it to show one of the records that is required for eveyone all of the time, and still ask for input for additional records that are only required for a selected few. Example: Show "A" all of the time user inputs "B", "C"...

Hello everyone, I have a problem I need help solving. I have a tblcompanydata, tblcategory, tblcommanddata and tbltrainingTaskdata. Everything is working just fine and normalized. But what I am wanting to do is; create a query that will show me base on the category and what command a company...

Ok here are my tables, tblSoldierData with Name, SSN, and so on tbleWeaponsData with typeOfWeapon, WeaponAssigned, QualType (Day, NBC, Night), QualDate, and SoldierID A soldier can have many weapons but a weapon can only be assigned to one soldier. To be qualified on a weapon a soldier has to...

I have a problem. There are three things that have to be done (B,C,D) before (A) can be considered completed. So what I have is a field named QualType, its a list box on one of my forms. I want to create a report that will show me who has or has not competed there Qualifications. I think I would...

Thank you so much that worked beautifully

Its bound to a student table I have two ckboxs one in the studenttable and one in the rostertable which is where I store the history of a students attendence. I use the appendqueryfrm to update the attendance roster for the class. SO once I have finshed with giveing attendance credit I would...

Hello all, I have a form that has a button that opens a appendquery form. What I would like to do is add a close button to the appendqueryfrm that will close and clear the ckboxs that are on it. Any ideas?

So what your saying about tblTask is to add a field and name it something like, TaskClass. Then define each class as Task and SubTask. I understand that but I am confused on how to use the junction table.

To answer your question about lans, task, and sub task; A lane is where a task like weapons qualification would be trained. The task would be the act of qualifying with your weapons. The sub task is all of the little task it takes to qualify with said weapons. i.e.: weaponA has 15 subtask a...

Ok, tblMobUnit - this will hold all of the data for the unit that is training tblSoldiersdata -this will hold all of the data for the soldiers tblSoldiersRosterjoin - a Soldiers can be on many rosters and an a roster can have mamy soldiers on it tblTrainingRoster - will hold the attendence...

Thanks did not think of that.

I tried to post my ERD but was unsuccessful don't know why.

I have several differnt departments with lots of employees attending training, and I need to be able to keep track of their attendance, and I have to be able to save a history of the data for the entire training cycle (training event and the date of training). What is the best way to do this in...