Search results

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...

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...

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...

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...

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?

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...

I may not of title this wright, but this is what Im trying to do. I have a tblCompany, tblEmployee, tblTraining, tblRoster. The tblRoster is the join table between employees and training. I want to beable to select all of the empolyees that attended the training at once and give them credit for...

I have to track companies, employees and their training they have to attend depending on what category they fall in. (CAT I, CAT II...) Company can have many employees and employees can only have one company. A Company can only fall into one Category, but an employ can fall into its own Category...

I have a problem Im hopeing someone can help me with. On a form I have several fields that look like this; type , day, night. Now if (type = A, or B than day highlights orange). How would I write the expresion in the conditional Formating form for the day field.

tableB is an one too many with tableA One Item in tableB can have many items in tableA. I need to count how many itemA in in tableA is related to itemB in tableB. How many employees dose companyB have? I am trying to do this on a form. I have a company form with a sub form from the employees...

Hello all, I have a situation where I would like to have a check box turn on when training is complete. What I have is collective training events with several training requirement to be completed. I would like the competed check box to turn on after all training requirement have been meet for...

I have 2 fields Full_SSN wich is the IDKEY for the table and a last_5_SSN field. How do I auto populate Last_5_SSN while imputing the full_SSN?

Working with 2007 MS Access. I need help with forms and conditional formating dates. I have a qual_date field that has a 6mth window. Anything older than 6mths needs to be highlighted in red. Is there is an exp I can use in the drop down menu. Thank you for your help!:)

I am a SFC in the United States Army and I have been learning how to develop MS Access databases. I want everyone to know I love working with access and any help or advice will be much appreciated :)