Recent content by klr397

  1. K

    Mail Merge With Access & Word

    I want to use an Access Table for a mail merge but when i try to use the merge option I get a pop up asking for a password. I put in my administrator password for the database and it tells me I dont have acess to the database. It has something to do with the passwords i put on the database...
  2. K

    AVG Function

    Probably simple.... I am using the avg function in a query to calculate the average risk score of all employees. But when i do it my quesry looks like this Joe shmoe 2.345 Joe shmoe average 2.345 jane doe 2.567 jane doe avg 2.567 how do i make it say only one of those lines. I dont care...
  3. K

    My Buttons will NOT work

    nope...nothing. I'm going CRAZY
  4. K

    My Buttons will NOT work

    Anyone? PLEASE help
  5. K

    My Buttons will NOT work

    I am not completly access challenged i have programmed myself many a successful button. Please someone tell me why i would get this message: The Expression On click you enteresd as the event property setting produced the following problem occured while Microsoft office access was...
  6. K

    combobox on a report

    I have a report which looks up candidates by skill and there are six skills, now i need to use a second list of 6 combo boxes that will be tied to each skill that will pull up the last date used. the user will ener a skill from the skill combo box and then type in a year that they want the...
  7. K

    report sorting issue

    i figured out the column thing... but is there a way to sort them by category and give each list of skills by category a header?
  8. K

    report sorting issue

    I have a report that needs to be used tooutput in word and be sent to candidates so tjhey can select the skills they have and send it back to us. Right now i have it sorted by skill category there are 10 of them in the page header. First is there a way to make access stop once the last...
  9. K

    Sorting problem

    I have a table with two columns skill and category i need to write some type of query or report that will group the skills into the numerical categories 1-9 and then in each of those groups listthe skills autamaticall and then have a way to print it out either in word or excel looking some...
  10. K

    multiple user specified parameters for search query?

    have you tried creating a form that would get the info froma user and then building a macro to search for the jobs?
  11. K

    killer query deleting dups

    Ok. I have a table with 6 columns. IdNumb Skill Version Last Date Experience candidate rating. My boss wants this magical program that will look through these records and find all the candidate ids that have two of the same skill and delete the skill with the last date that is the oldest...
  12. K

    drop down list is changing all entries

    I have a drop down list where you pick from 6 recruiters. i put it on my candidates from and when yiou change a recruiter on one candidate then all the candidates get changed to that recruiter. Any ideas what i did wrong?
  13. K

    Time elipsed since a job order has been entered

    fabulous! thanks a bunch
  14. K

    Time elipsed since a job order has been entered

    I need to create two diffrent reports one that states how many days since a job order was entered date entered and on that satates how long it has been since a resume has been sent to a job order date sent does anone have any idea how i would accomplish this i was trying to do date entered...
  15. K

    Has anyone ever Documented a Database before?

    thanks all
Back
Top Bottom