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 Mike Lewis 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. theresakad

    Excel Automation - check for #n/a error

    MikeLewis, Thank you. I should have thought of that. This will work perfectly. Thanks again.
  2. theresakad

    Excel Automation - check for #n/a error

    MikeLewis, I did try your suggestion but wasn't able to get any results or find what I am looking for. The excel file I am reading already has #N/A in the cell I am reading. The value of this cell doesn't evaluate to .F. or NULL. When I use this code to check the value I get the Error 11...
  3. theresakad

    Excel Automation - check for #n/a error

    GriffMG, #N/A is an error status from a lookup formula. I can't change the existing excel documents formulas. Referencing the field that holds this value now produces an Error 11. Error: 11 Function argument value, type, or count is invalid. , Program: FRMPRICEQUOTES.BTNGENERATE.CLICK ...
  4. theresakad

    Excel Automation - check for #n/a error

    Within Visual Foxpro 9.0 SP2 I am reading from an excel file and need to check a cell for #N/A. Any suggestions? If #N/A exists in a cell then I need to write to another cell to fix the problem, if not, then I can move on. Also, I have been searching for a website that would show me all the...
  5. theresakad

    select max(value) where max(value) < min(date)........?????

    I was trying to simplify my query but I think that might have been a mistake. I am trying to apply what you have suggested above but having trouble. Please forgive me. I have included my query below as I have it now before trying to apply any subqueries. The problem is that I need more columns...
  6. theresakad

    select max(value) where max(value) < min(date)........?????

    I am using Visual Studio 2005 reporting services with SQL Server 2000 and am not able to use rownumber function. I am sorry, I should have mentioned that in my first post. Better yet. I should create a signature with that info in it. I am sorry.
  7. theresakad

    select max(value) where max(value) < min(date)........?????

    Sample Data table a Name, scheduleDate, codeyear jill, 5/12/11, U jill, 5/13/11, U john, 11/16/10, U Jill, 5/9/10, T table b name, signdate, codeyear, status Jill, 2/14/11, VW, renewal John, 11/19/09, V, renewal Jill, 2/1/10, U, Renewal Codeyear for table a is related to the scheduleDate but...
  8. theresakad

    select max(value) where max(value) < min(date)........?????

    I am having trouble structuring my query to just pull the data I want instead of all the records. I could really use your help. I have a table that holds schedules for all of our customers. Each schedule is related to an agreement. There could be multiple schedules per agreement for one...
  9. theresakad

    How to count consecutive letters in a field based on the alphabet

    I am struggling trying to figure out how to go about this. Your help is greatly appreciated. I have about 6000 records. Field1 contains a series of characters in consecutive order of the alphabet. I need to know the number of consecutive letters starting from the end of the string. The alphabet...
  10. theresakad

    filmstrip slideshow

    Does anyone know of a tutorial on how to create a filmstrip where the pictures are scrolling, like a slideshow, but I want to have at least 3-4 pictures showing at a time, but the pictures need to be sliding along the filmstrip, like the film strip is moving. I hope this makes sense. I have...

Part and Inventory Search

Back
Top