Access 2003 - Questionnaire Type Data 3

[a98dsu98sad8sua]

Hi all,

I am trying to create a data entry form based on a call accreditation session, this involves listening to a telephone conversation and marking off certain criteria when it is fulfilled.

This is for a large enterprise (approx 600 users) so the call accreditation questions are slightly different for each staff member depending on what campaign (department) they are on!

What I need to know is, how do I present the data operator with a list of all of the questions for that particular member of staff so that they can fill out a call accreditation session? I have a table with questions, links to a table of campaigns, and a staff table with a campaign id in, and also a section id (certain criteria is under a certain section, for example, "Listens to Customer" might come under the accreditation section "Compliance").

I can't figure out how to actually construct the data entry form, and I was just wondering if someone would be kind enough to give me some help with this please in laymans terms (As I'm still pretty new, however have been told my database is in NF3 so I am quite proud!)

So the tables are:

Sessions (Where call accred. data goes)
     PK - ANSWERID
     FK - CALLID - (Linked to the PK CALLID in Calls)
     FK - QUESTIONID - (Linked to the PK QUESTIONID in Questions)
     YES/NO - RESPONSE

Questions (Where questions are stored)

     PK - QUESTIONID
     QUESTIONCRITERIA (Memo)
     FK - SECTIONID (The section the question belongs to)
     FK - CAMPAIGNID (The department the question belongs to)

Calls 

    PK - CALLID 
    CALLTIME (Time of call)
    CALLDATE (Date of call)
    FK - CUSTOMERID  (Customer the agent is calling)
    
Staff

    PK - STAFFID
    STAFFNAME
    FK - CAMPAIGNID - (Campaign Worked on)
    FK - MANAGERID - (Employee's Manager)
    FK - CONTRACT - (Employment Service - Not useful here!)

Campaigns

    PK - CAMPAIGNID
    CAMPAIGNNAME

Sorry is this is a lot to take in! Thanks very much for any help you may be able to give me so I can get this data entry form up and running!

Regards,

David

 

[a98dsu98sad8sua]

Hi all, another update in the Database saga

I have a form, which you can see here:

http://img159.echo.cx/my.php?image=myform7gw.jpg

"Employee Name" is a lookup like this:

Private Sub cbxEmployeeName_Change()

Dim strCampaign As String
Dim varDLookupCampaignID As Variant
Dim varDLookupCampaign As Variant

varDLookupCampaignID = DLookup("[CampaignID]", "Staff", "[StaffID] = " & cbxEmployeeName.Value & "")
varDLookupCampaign = DLookup("[CampaignName]", "Campaigns", "[CampaignID] = " & varDLookupCampaignID & "")

cbxCampaign.Value = varDLookupCampaign

End Sub

Which obviously changes the campaign based on staff member selected, I have also included a button to unlock the campaign if the employee is working on another campaign temporarily (it isn't bound, so changes aren't saved)

Now what I need to do is when the Assign button is pressed, I need to add the Call/Staff Data to the Calls table, the customer details to the Customers table, and add the Customer ID to the Calls table as well, and then run a query to get the full question list for the campaign selected, and present them to the user

 

[hkaing79]

http://www.w3schools.com/sql/sql_insert.asp

Once you figure out your SQL statement, use the OnClick event of your button to insert your data...

CurrentDB.Execute "SQL statement"

then, you'll need to open up your form...

DoCmd.OpenForm("Questionnaire Form")

There are some threads that discuss how to pass arguments to forms I believe.

Hope that helps to get you started.

 

[a98dsu98sad8sua]

Thankyou

That's a great help!