Recent content by SFCMatthews

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.