Recent content by ChrisAnthony

Hi All, I have a Access DB that is split. I have the back end stored on the network in a folder. What I am wanting to do is hide the actual database file in that directory so user cannot see it, only accessc it through the front end file. When I uncheck list folder content from the...

Hi All, I have been working on a recruitment database for some time now. What I have is a table of applicants, table of questions and a table of evaluations (answers to the questions for each applicant. They way I have it setup currently is that the user selects an applicant, goes through each...

Access 2007

I have form with a continuous sub form. Basically what happens is that continuous form gets populated with names from outlook. This works fine. The problem is that somtimes I need to change the name and when I click in the field the whole thing gets highlighted causing me to delete all content...

Also I went into the query for the pivot and tried changing to show top 5. The problem is that it shows the top five applicants in alphabetical order not based on the sum of the scores

Hi Folks, I have a DB that allows users to login and evaluate applicants for job position. This works fine. I now have a pivot table sums the scores of each user. This works fine. What I want to do is limit the results to the top 5 candidates with the highest scores I am not sure how to do...

Thanks Trev thats awesome ... i feel to foolish that I didn't figuer this out my self.

Hi all, I have DB that I want to use review candidates for a job position. I have one form “Form 8” that I want that hold the names of all the applicants and the job posting they applied for. I have sub form added to this form that displays the questions associated with the position. Inside of...

Anyone that can provide me with a solution ill give them $100 as a bit of incentive

here is a 2003 version.... So again just to restate i need to get all the linked variables from 3 forms to be saved into the evaluations table. So basically I want the user id,question and answer to be saved into evaluations. PLEASE SOMEONE HELP! I am very desperate to get this working.

If someone can can make this work for me I would be glad to compensate!

Hi there, Sorry I sent you a old copy of the DB its a bit sloppy. My have guessed is that basically I want to display all the questions related to the posting and then in table evaluations I want it to display the related answer from the user related to the posting selecting and applicant...

Thanks again...

Thank you so much

Here a little diagram of what I tried to do by linking subforms. The problem is that I cant get the last subform to link all the required fields. When I get through the wizard it only allows me to select fields from subform2? I know this is possible and most likely fairly simple. Main Form...