Application Tracking Database

[Scott_Withey]

Hi,

please please help, I've got into a bit of a pickle with a database I have to produce for work. It's a database for recruitment purposes basically it needs to track applicants application process.

So far I have created the following table:-

tblApplicant - Details on each applicant
tblVacancy - Details on the vacancy
tblApplication - this is a link table
tblSource - this details the media through which the applicant saw the ad

I have created frmApplicationMain - this is a form with a sub for which allows the user to enter a new candidate and then enter details as to the position he/she is applying for.

I have created a couple of queries, the first of which produces a list of applicants who we have sent application forms to but have not returned them. I've also created an Append query this appends details of candidates who have been 'NFA'd0 (No Further Action) i.e. application declined.

A switchboard has also been created.#

***I require the following:-

a query to delete records from both the applicant and applicatin table when the Application status is NFA, could someone create a macro to do all this.

Also could macros be created to run the qry qryareyoupackback?

Thanks for youe help

Scotty

 

[ByteMyzer]

Try these macros, see if this is what you're looking for.

 

[Scott_Withey]

Thanks but...

Thanks, your macros seem to work great its just that my macro qdelNFA is wrong. i just used some test data and what is happening is that the row in tblAplication is being deleted but not the tblApplicant record.

Is there any chance someone could sort out this query so that it completely reomves any record where the application status is NFA from both tbl Applicant and tblApplication

Thanks

Scotty

 

[ByteMyzer]

Whoops, didn't take the relationships into account. Try these macros instead.

By the way, qdelNFA isn't a macro, it's a Delete Query.

 

[Scott_Withey]

Excellent thanks

That's great seems to work a treat. Is there any chance though that you could edit it so that the append query runs first and then the delte query, all in the same macro

Scotty

 

[Pat Hartman]

Are you really asking people here to do a job that you are being PAID to do? Can't you even resequence a macro by yourself? How did you get this job anyway?

 

[dan-cat]

Are you really asking people here to do a job that you are being PAID to do? Can't you even resequence a macro by yourself? How did you get this job anyway?

Promoted to the point of incompetence

 

[ByteMyzer]

You know, Scott_Withey, it's one thing to ask for help, but it's another thing altogether to expect others to do all the work for you.

Perhaps your employer would prefer a sufficiently qualified candidate in Access Database Design? You'll understand the sarcastic remark when I tell you that I don't hold well with people who are willing to take the credit for other people's work, and I don't know offhand of any other forum members here that hold with it any better than I do. I supplied you with a quick and easy solution to point you in the right direction, but from there on, you are on your own.

 

[Scott_Withey]

Sorry Peeps

Sorry didn't mean to cause any distress. Think I have been misunderstood. I working at a company in recruitment on a temp contract and personally thought that the system currently in use was inadequate (lengthy excel and paper system) so in my own time thought I 'd try and throw something together on Access knowing that it is a very flexible and powerful piece of Software

I am not being paid to do it and have designed and constructed the table format and forms on my own. I just thought that as this site is seen by many people as being full of really helpfull people that you could help me in my understanding of macros and the like.

Apologies

Scotty

 

[aleb]

There is macro in your dbase which is called "DeleteNFA" . First line says: Setwarnings ... blah
Ok second line would be "Openquery" set details for this command for append query which you have alredy in you dbase.
Third line will be also "Openquery" but now set details for delete query.
Fourth line will stay the same.
Now you can do with this macro whatever you want . You can assign macro to a Switchboard button, button on a form ....

 

[Scott_Withey]

Cheers

Thanks Aleb, that's a great help. I hadn't relaised that macro's were relatively straightforward

Scott