Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. deharris2003

    Can I use a variable in the From Clause of a Select statement

    Thanks for your help that works great!!!
  2. deharris2003

    Can I use a variable in the From Clause of a Select statement

    ...a message that the variable must be decared but that is strage because I have already declared the variable. here is the stored procedure /* This procedure will be used to update the Pasadena, Klein, Humble and DeerPark Files on Online_Media Variables are defined as @TableName =...
  3. deharris2003

    returning a decimal value from an epression

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

    replace method Help!!!!!!!!

    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)...
  5. deharris2003

    Sending email to several contacts

    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 =...
  6. deharris2003

    restrict date entry to date() - 90

    Dwarfthrower, Thanks this works great!!!!
  7. deharris2003

    Sending email to several contacts

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

    restrict date entry to date() - 90

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

    Sending email to several contacts

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

    restrict date entry to date() - 90

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

    Sending email to several contacts

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

    Min of three dates

    Thanks Tony This function works great!
  13. deharris2003

    Min of three dates

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

    Min of three dates

    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, " & _...
  15. deharris2003

    Sending email to several contacts

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

    Min of three dates

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

    restrict date entry to date() - 90

    document.form1.date
  18. deharris2003

    restrict date entry to date() - 90

    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 =...
  19. deharris2003

    Redirect page when Session(&quot;ID&quot;) expires

    I understand Thanks
  20. deharris2003

    Updating SQL through Access

    Conn.Execute strSQL

Part and Inventory Search

Back
Top