Recent content by ecugrad

I have the below code to send emails from my application. Problem is I'm not 100% sure they are making it to the all the clients. How do I add some code to confirm the delivary or non-delivary of the emails. Thanks for any help provided.. Public Function getAD(ByVal bnumber As String) As...

I have a comment field (ntext) that I only want to display the record if something is populated in it. At the present time I have a bunch of empty boxes when I loop and it does'nt look to appealing. Question: How do I pull only the records that have something populated in them from a text...

If have ths piece of code below that I need some help putting some error control around. If (ID=11744) or (ID = 1215) or (ID=1217) or (ID=1218) or (ID=1219) Then arrTime = Split(ItemsWorked, ":") Itemsworked = arrTime(0) * 60 + arrTime(1) End If The users should enter in numbers in the...

Trying to validate a asp.net text box control that is within an asp repeater tag. Text box should only contain numeric values. It will not allow the user to submit the request, but the error message will not display. Code behind is VB. <asp:Repeater ID="rep_proc" runat="server">...

Okay, for Capacity and Time we have collect numbers one number for each employee every month. So all I do is order them within the detail section? Employee Capacity (Capacity_Rank) Time (Time_Rank) 1 77 2 6 2 2 88 1...

I have two fields I need to rank CAPACITY and TIME my grouping for the report is EMPLOYEE ID's. I would like the rankings to be in desinding order. I have tried multiple pieces of code, but with limited or no luck. The two fields are not summary fields. The numbers pull straight from a...

I'm using Cystal 8.5.. I have productivity scores for each of our 109 employess, the scores are from 77.03 - 99.59. My goal is to create a formula that would give a numerical ranking from 1 - 109 for each employee based on their score. I'm by far not close to an expert in Crystal, but...

Found it in search

I'm trying to find the time difference in seconds from two datetime values, EX: 2/20/2009 9:48:51 AM - 2/20/2009 9:50:51 AM. Any help in doing this in a query? Thanks..

I have an external Word file on a group drive that we want to link to from our web page. We need the file to open in Word because we have code in the Word document. How would I like this file from our page to open it. We are using Explorer 6.0 and Word 2003 Thanks for any and all help

Not sure if I have a clue what I'm doing. But, I know it's not working. I'm trying to pull quarterly data from one table. Summing up month 1,2, and 3 as Qtr 1 and 3,4 and 5 as Qtr2 and group by lastName: Table: LastName Firstname Queuescore Month ex; 1,2,3, etc SELECT SUM(QueueScore)...

I have a two tables a Review table and Account table with the relationship being the account number and note number. I want to return all records that exsist in the Account table, but are not in the Review table. Sounds easy, but I'm having difficulties. Thanks ACCESS 2003

I have two tables (Accounts and Accounts Paid) with the relationship being the Account Number and Note Number. I want to query all Accounts in the Accounts table that are not in the Accounts Paid table. Access 2003 Thanks, M

Having trouble running the below append query utilizing a union statement. Can this be done, if not any suggestions. Thanks INSERT INTO [R&R_MonthlyMatrixScores] ( BNumber, [Year], [Month], DepartmentID, Department, LastName, FirstName, Salary, IndPhoneMonitoringScore...

I have a Processdate field in a query:ex 4/12/2007. To build a relationship with another table I need to extract just the month value from the above Processdate string, that is I want to just return the "4". Thanks for any help. Mike