Search results

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

Hi all, I am working on a recruitment and selection program. Here is what it does in a nut shell. You can add a job posting to the posting table ie posting id, position title ect. You then select a outlook folder containing all the applicants and associated resume / cover letters. You can...

Thanks.... but the DB already does that. I need to save the file to the DATABASE not a directory on my harddrive!

So I have code that goes through each email item in a folder it saves all the email information to a new record in a table ie .sendername, .datereceived ect. Currently for each mail item attachment it saves the file in a directory. I want to change this part so it saves the attachment to the...

Sorry this article does not talk about saving attachments to the database Thanks.

Hi all, I have some code in my database that saves each email from a folder and stores the information in a table.... In this code it currently saves attachments to a specific directory. Now I would like to save these attachments directly to the database instead of the directory. Does...