Search results

I guess no one is able to help!

Alright, thanks. I have attached the db. The form that I wrote the code for is called frmServiceQualityAssessment. The tables that are related to the evaluation part of this form are tblEvaluation, tblEvaluationWeight and tblComments. What I want the form to do is that whenever checkboxes are...

Any help would be appreciate it. Thanks.

Hi, I've written a VBA code for my evaluation form to add the total. However, it does not work. It does not show me the total as I'm going through the evaluation. Could someone please help me out? This is my code: Option Compare Database Option Explicit Public Const strCYes = "_YES" Public...

Ok can i make the changes and send it back to u to see if I did it right?

Oh ok, but can i put the checkbox yes, no and n/a and do the same thing u did?

Thanks for your help, I really appreciate it. However, I need to have the checkbox yes, no and n/a, I can't just have yes. The form's design requires both yes, no and n/a. I don't quite understand how u did the tables and how it saves this information into the tables.

I'm not sure if u were talking to me but here's my db. The form is called frmServiceQualityAssessment and my tables are called tblEvaluation and tblEvaluationWeight.

I already have my form done and I know how much each question weights but i can't get it to do what it's suppose to. I have two table Evaluation and EvaluationWeight. I've designed a module that will do the evaluation but now i need a query that will take the yes/no/n/a information and put it in...

I tried what u told me but it doesn't work, it gives me an error saying: the expression after update you entered as the event property setting produced the following error: the object you referenced in the VB procedure as an OLE object isn't an OLE Object. This is what i have in the expression...

It works fine now, I changed my query to this: SELECT tblEmployeeInformation.strFullName AS FullName, tblManagerInformation.strManagerFullName AS TLFullName, tblEmployeeInformation.strPhoneNumber FROM tblEmployeeInformation INNER JOIN tblManagerInformation ON tblEmployeeInformation.strManagerID...

I did that and it didn't make any difference. It still doesn't work.

The problem is my query. I tested it w/ another query and it works fine. But I don't know what's wrong w/ it. This is my query: SELECT tblEmployeeInformation.strLastName+', '+tblEmployeeInformation.strFirstName AS FullName, tblManagerInformation.strLastName+'...

Yea i checked all those and everything is fine. I don't know y it's doing that.

Hi, I have a form where it does an assement of the service in the call center. The evaluation form has 3 check boxes (yea, no, n/a). There are 163 employees that need to be evaluated on their performance. How would I go about setting this up? What I've done so far is made a table called...

No i don't think it has to do w/ that because my other form works fine and it doesn't have an on click event.

Does anyone know how i can fix this? It won't let me choose anything it just keeps the drop down and doesn't let me choose it.

I fixed the problem, thanks for ur help.

There's nothing there. Does this mean I have to recreate the form?

It works perfectly now, thanks man. Question though, now when I go to choose from my list in my combo box i can't select it, it shows me all my list but it doesn't let me choose it.