Search results

  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

    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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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?
  9. 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...
  10. K

    Has anyone ever Documented a Database before?

    I need to document an access database but am unsure as to what i should be putting in my final copy. Has anyone ever done this and have any tips?
  11. K

    removing parameters

    I had a report that before had a parametrs box that would show on opening that would ask you to manually type in the name of the account exec now i built a form with a drop down list but i cant get rid of the parameter box. Any Ideas?
  12. K

    hiding duplicates

    I have a report which brings up all our candidates that we have sent to a particular customer. I need the first name and last name fields to not show up up when they have been sent twice for two diffrent job orders. but when i hide duplicates if anyone has the same last name it blanks thier...
  13. K

    friggin combobox unbound form

    I would like to have a form with a combo box open and then when a company is clicked on i would like for my report to open showng all those listings. I have the query and the report and the form but how do i get them to all work together they are not playing nice.
  14. K

    MsgBox on change

    I have a lastname field that can easily be erased accidentily. so i need to put a piece of code in there that will bring up a msg box that will ask them weather they relly want to change the last name. The code i have so far just brings up a message box but i need it to restore the last name...
Back
Top Bottom