Search results for query: *

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...

Ok this one has been meking me crazy. I have three dates dtmDate1 dtmDate2 dtmDate3 What I want to do is find the min date and the max date of the three dates that are available. All three dates are stored into seperate variables and my understanding is that the Min and Max functions only...

document.form1.date

I am new to javascript. What I want to do is not allow the user to enter a date that is greater than 90 days in the past. I have written the following. doesn't seem to work. Can you tell me what I am doing wrong <script type=&quot;javascript&quot;> function verifyDate(field) { var today =...

I understand Thanks

Conn.Execute strSQL