Search results for query: *

bean, that is because you are putting a string and an int together.. try Me.Controls.Item("ddl" & x.ToString()) Running in circles is what I do best!

...failure AuthenticateUser = false strUser = UserName strPassword = Password strQuery = "SELECT cn FROM 'LDAP://" & Domain & "' WHERE objectClass='*'" set oConn = server.CreateObject("ADODB.Connection") oConn.Provider = "ADsDSOOBJECT" oConn.Properties("User ID") = strUser...

...failure AuthenticateUser = false strUser = UserName strPassword = Password strQuery = "SELECT cn FROM 'LDAP://" & Domain & "' WHERE objectClass='*'" set oConn = server.CreateObject("ADODB.Connection") oConn.Provider = "ADsDSOOBJECT" oConn.Properties("User ID") = strUser...

...failure AuthenticateUser = false strUser = UserName strPassword = Password strQuery = "SELECT cn FROM 'LDAP://" & Domain & "' WHERE objectClass='*' " set oConn = server.CreateObject("ADODB.Connection") oConn.Provider = "ADsDSOOBJECT" oConn.Properties("User ID") = strUser...

I have tons of code I have tried so let me give my situation and see if perhaps someone can point me in the right direction. I am developing a page for the intranet. I have a user group in AD with all the users I want to have access to my site. This AD group has been placed in the database...

...failure AuthenticateUser = false strUser = UserName strPassword = Password strQuery = "SELECT cn FROM 'LDAP://" & Domain & "' WHERE objectClass='*' " set oConn = server.CreateObject("ADODB.Connection") oConn.Provider = "ADsDSOOBJECT" oConn.Properties("User ID") = strUser...

LB im sure you have heard this plenty of times but.. Y O U ... A R E ... T H E ... M A N! Thank you so much!!!! I will now go and analyze the code so I can utilize it in future projects!! Thank you so much for your help this is awesome! If I could give you a dozen stars I would! Running in...

Hey LB, Thanks for the help, unfortunately it is still returning the doctors name even if they are not missing any documents. Running in circles is what I do best!

I can definitely see where you would be confused because I am confused on how to describe it let me try again. Selection: I have 3 statuses fields that I am actually filtering,RV_Practitioner_Facilities.Current_status and RV_Practitioner_Facilities.Status_category are 2 of them which are...

Ok my assumption, The reason the missing docs actually works is because there is more that 1 file its looking for. So its looking for 5 forms and it assumes everyone is going to have atleast 1 of the 5 forms... now that I think about it I should probably take the form "documentname" selection...

Ok awesome looking at your other example i noticed you used ( ) so i tried it out and it works.. {RV_Practitioner_Facilities.Current_status} = "Active" and {RV_Practitioner_Facilities.Status_category} = {?PracCategory} and {RV_Practitioner_Facilities.FacCode} = "SJ" and (IF {@Answer} = 1 then...

Im sorry LB I am still new and trying to grasp all the different location of this application. Active is represented as a 1 or a 3, Courtesy is represented as a 2. I was using the above formula in the Group selection. My current record select is: {RV_Practitioner_Facilities.Current_status} =...

Ok using, if {@Answer} = 1 then distinctcount({RV_Document.DocumentName},{@PractSort}) < 5 else if {@Answer} = 3 then distinctcount({RV_Document.DocumentName},{@PractSort}) < 5 else {RV_Document.DocumentName} <> "Privilege Form"; I have been able to get it to exclude them if all...

Ok, If only i had made it that easy :/ I had to modify your code to fit the departments needs. The doctors have 2 statuses, "Active" has 5 documents they need, and "Courtesy" has only 1 document they need but can have up to all 5 of them. I have modified your code so it can decide what...

I have a group that pulls the Doctors names and under that group it pulls the Forms that they are missing. This was done buy a formula that lbass helped me create. Well the documents report at the group footer of the documents what was missing if anything was. I am trying to have the Group...

Thanks LB! Ok.. wow.. incredible.. I have been trying to get those formulas to work all day and in doing so i have learned ALOT so thank you so much for helping me!! As I had finally given in and came here to post again for help from you on what was going on it just clicked in my head.. In...

I am trying to create a report that reports back what documentation is missing. Currently I have a report I created that lists all the documents that they DO have but I would like it to report specifically what they dont and I am not sure where to begin I am still pretty new to the formula side...

I am having this issue as well. i am not quite sure what is adding all this white space. >.< Running in circles is what I do best!

They were as text but i went back and changed it a while ago and made it a number type. im off to work i will try doing what ya said jsteel when i get home tonight. thanks for the fast responces i hope the solution awaits when i get home!! :) hehe thanks all! Running in circles is what I do best!

data type mismatch in criteria expression" Is the current one im getting. with that code you see above. i made sure all the data matches as far as number and text and what not in my database. i did use the ' ' because i foudn that it wont work with numbers if you use them so i left them out but...