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

Thanks for trying No it was the drink not food that destroyed me for a whole day (wasn't there a time when you could drink like that and the following day would just be like any other?) Anyhow guys i sorted myself out this morning and for info i used = DCount("*","QueryName") seems to have...

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

3 same as two combo wizard only offered me the option of placing data from one column to another field i tried to do an after update along the lines of textbox1=mycombobox.column(1) but this asked for a Macro My appologies i got my head into Access a year or so ago to design the db i hve...

Thought i Had Solved this Read he previous post and you would think i solved this already. I have a large db that has been running succesfuly for a while i need to tweak something slightly but don't want to have to change everything What i had Within my forms i had a field for Title: Mr...

Getting Desperate I have had a new boss who wants me to change the database i created over a year ago. At that time i had just done an Access course and picked up some good tips along the way since then i have hardly touched the programme until now. I set the conditional formatting like this...

Job done didnt quite do it as you said but went about it in a similar way very simply created a combo box with two columns data in one numerical value in other set focus to second column and told it to place the numerical value into a different text box on form i think i posted to early but...

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

Mingling reply What i have is a database containing qualification dates for my personnel after one year from the date they qualify in a subject they have to do a re-course. What i have been asked to do is apply a form of traffic light system to allow line managers to quickly View / Visualise...

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

does it need to be ? i want it independent of everything itis purely for his own comments so when he prints off an mployees profile he can read his own review nots

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

On the right track Shades many thanks for your help you were in the right ball park unlike me this is what i tweaked and it seems to be the solution for the date issues =AND($H18>=TODAY(),$H18<TODAY()+14) This turns red within two weeks of $TODAYS DATE$ =AND($H18>TODAY()+15,$H18<TODAY()+43)...

Condition 1 less than = TODAY() Condition 2 between = TODAY()+1 = TODAY()+14 Condition 3 less than or equal to =TODAY()+42 I have tried these in varying sequences been looking at it that long confusing myself

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