Search results

What i have! Employee table 60+ columns each one a specific employee qualification these are all set to Yes/No (Tick boxes). I want (would like) all these on one form if possible. The form as you can imagine looks ridiculously cluttered. What i have tried! Created lots of forms incorporated...

I have a training db (records personnel qualification states and when they are required to resit tests) that is accessed/viewed by any employee with access to the company network. They can only view the forms as each field is locked out so unable to edit. Within this db each line manager has a...

I have a db which keeps a record of my employees qualifications currently i can view a report which lists everyone in the company that holds a specific qual. What i have been asked to do is design a form that will show an overview of all qualifications and how many people we have currently...

Hey, May sound silly but please bare with me. What i have done! In Option group i can set label names that have a value i can then store this value in another field. This is great and exactly what i want however the amount of labels / options i want is quite large and these all apear on...

Hi Guys, Having some real difficulties with conditional formatting i know this must be simple but i think i am getting them in the wrong order. What i want to do is colour code certain boxes dependant on the date input The Date someone qualifies will be entered into the box If the date...

I have a form that contains six boxes with the run out date for six different types of employee vaccinations each box contains a conditional format that allows it to change colour to highlight how close they are to requiring another course of injections (Green = within 6 weeks, Amber = within 2...

Just when i thought the db was finished i decided to let the boss check it. What we have. An Employee Database that has employee qualifications that each have a specific run out date. I fill in the database with all correct information the bos checks the db and wants to be able to do the...

I am having trouble applying conditional formats to my access db they work in excel but cannot seem to put them in to access I have one table that my forms and queries look at These are the conditions i had used in excel formula is =AND($H18>=TODAY(),$H18<TODAY()+14) this turns red if within...

I have been on this for a week and cannot seem to get it correct. i think it is something to do with the order but i am sure i have tried all possibilities. Anyway here goes Setting the Scene At work we conduct practical and theoretical performance based assessments depending on how well you...

I have created a db and would like to apply the format of the attached zip file I cannot seem to work out how it was done cutting and pasting the code is not working either if someone could take a look and give me a simple method of creating the desired solution i would be very greatful The...

I have been tasked with setting up a database for all employees the info contained is along the following lines: Employee Number: Name: Qualification Status: Qualification Run Out Date: To name but a few of the parameters I have currently set up the start up screen, main switch board and the...