Recent content by deharris2003

Thanks for your help that works great!!!

I have this query that is in a Stored Preocedure. I want to be able to call this stored procesure with different variables. Problem is that is will not compile with a variable in the From statement. I keep getting a message that the variable must be decared but that is strage because I have...

OK i am still new at SQL and my probelm is that when I divide Minutes by 60 (I.E. 458 minutes divided by 60 should return 7.63 hours) However When I do SUM(MINS)/60 I get 7. I tried CAST((SUM(MINS) / 60) as float) As hours and I still get 7. Can anyone tell me how to get SQL to return 7.63...

Ok so I have a simple fuction. All I want to do is convert all . to / doesnt seem to work very well here goes function DoThese(date_field) { if (date_field.indexof(".") != -1) date_field = date_field.replace(".","/"); validate_date(date_field)...

hey rapidapp, here is something that might work better for you in VB6. Function Sendmail() 'Declare Variables Dim strESubject, strOutPut, strTo, strFrom As String Dim mail As CDONTS.NewMail Set mail = New CDONTS.NewMail strTo = "someone@somewhere.com" strFrom =...

Dwarfthrower, Thanks this works great!!!!

LogicManUS, No problem man. That is what Tek-Tips is all about people helping people. Besides I am always open to improving my skills in programming.

Well Not really cause it doesnt work. I am not really good at javascript just leaning it really.

rapidapp, I am not certain, what references would be needed in VB6. But I know in VBA all you should need is a reference to the Visual Basic for Applications and it is possible that you may also need to reference the Microsoft Active X data objects 2.1 Hope this helps

Sure I can do that. But I would need help in sending the data to the function

LogicalMan, I see your point. with your modifications it should also speed up processing time.

Thanks Tony This function works great!

sfvb will this also work in Access? Can I do something like Min(dtmDateq,dtmDate2,dtmDate3)

sorry, I am using MS Access ADOBD connection. Here is my SQL strSQL = "SELECT Member_ID, Member_Name, Street_Address1, " & _ "Street_Address2, Zip, Home_Phone, Sex, Dob_Date, " & _ "Signup_Date, Resign_Date, Signup_Date1, Resign_Date1, " & _...

Marco, here is a basic function that will scroll thru a table and send emails to all the individuals listed in that table. it can be easily modified to send emails to only certain people. Function SendMail() Dim dbs As DAO.Database Dim rst As DAO.Recordset...