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 Chriss Miller 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. jgarite

    Can someone please verify this code real quickly?

    thats another good one...thanks, that may be useful too. thanks george and lee
  2. jgarite

    Can someone please verify this code real quickly?

    wow LoL...thanks...guess i need to go back to kindergarten & learn how to count. thanks george
  3. jgarite

    Can someone please verify this code real quickly?

    can someone verify this code for me? it doesnt seem to be working... <% if Mid(sKitName,4,3) = "EEE" then%><%else%> <% if left(sKitName,4) = "Asus" then%>Free Shipping <%End if%> <%End if%> The item titles are Asus A7K (just for example) and Asus EEE...if the model is a Asus EEE, it should...
  4. jgarite

    Display content until date reached

    Excellent! Thanks, I'll try that out right now. Do you knwo if thats server time or the users computer time? I'm assuming server time...
  5. jgarite

    Display content until date reached

    I am trying to figure out how to display content until a certain date is reached...is this even possible? If so, how? Not familiar at all with the date functions in php. What I have is some rebates I would like displayed on my website that expire March 31, 2008. I would like them to disappear...
    • jgarite
    • Thread
    • Replies: 3
    • Forum: PHP
  6. jgarite

    Can I create a DB from a spreadsheet?

    1. ebay 2. i dont have the sheet in front of me (im at home), but I think it is M2 3. it will vary. so far hasnt been more than 10.
  7. jgarite

    Can I create a DB from a spreadsheet?

    higgins, how would i use this in a macro? the country-codes.xls would be looking in Final Macro Completed.xls (this is where the macro resides) for the data that needs replacing. And how would i loop it to continue through row 2,3,4,etc...there usally arent more than 10 rows so it is a small...
  8. jgarite

    Can I create a DB from a spreadsheet?

    Ok, well to start, I can move the columns around, I don't think it matters which column is the abbreviation and which column is the full name. Here is what I am trying to do: I have a file that contains country names that need to be converted to the abbreviations. I will be running this on a...
  9. jgarite

    Can I create a DB from a spreadsheet?

    Hello again, I have an Excel spreadsheet containing country codes that I would assume needs to be turned into a database in order to be queried. The query would be something like this: Search for United States (finds it in column B) and replace it with its Country Abbreviation: US (Finds this in...
  10. jgarite

    Excel VBA Loop Rows

    Now I'm confused...this is what I did to create the query, maybe I did it wrong: Data > Import External Data > New Database Query (On the Databases Tab) Excel Files > OK I opened the Final Macro Completed.xls file --It than told me there were no visible tables, I hit OK and it asked me if I want...
  11. jgarite

    Excel VBA Loop Rows

    That is the name in the textbox :-{
  12. jgarite

    Excel VBA Loop Rows

    getting the error Subscript out of range ...
  13. jgarite

    Excel VBA Loop Rows

    Sheets("ebay").ebay_to_yahoo_items(1).refresh false
  14. jgarite

    Brief Absence

    Wishing you a quick recovery. [thumbsup]
  15. jgarite

    Excel VBA Loop Rows

    Hey, that last code worked perfect with minor changes to the titles. Thanks so much. I tried using the code you provided to have the macro run the query, bt it didnt work (I replaced the sheet name and the query...my query name is ebay_to_yahoo_tems and the worksheet i renamed to was the ebay...
  16. jgarite

    Excel VBA Loop Rows

    I tried that, it gave me an error. Any idea why this wont work? When I added the bold it gave me an error: SELECT [Sales Record Number],1 as 'Line ID',[Item Title] as 'Product ID',[Item Title] as 'Product Code', Quantity,[Sale Price] FROM `C:\Documents and Settings\RBC\Desktop\Final...
  17. jgarite

    Excel VBA Loop Rows

    Ok, Ill have to try that. I just gotta make a few changes to the code (IE add the product code column) and than remove the '' around the Line...I guess that has to be done after the query because it is needed in the query it seems. Thank you so much for your help. I'll repost if i need more help.
  18. jgarite

    Excel VBA Loop Rows

    EXCELLENT! One final question...can this be executed through the macro?
  19. jgarite

    Excel VBA Loop Rows

    Let me just clarify, this is the SQL statement: SELECT [Sales Record Number],1 as 'Line',[Item Title], Quantity,[Sale Price] FROM `C:\Documents and Settings\RBC\Desktop\Final Macro Completed`.`ebay$` UNION ALL SELECT [Sales Record Number],2, 'Shipping And Handling',null...
  20. jgarite

    Excel VBA Loop Rows

    Ok, I cleared data in all empty cells below the 1012 sales record and it still shows the same amount of empty cells as stated above. i did the auto filter, but there are no blanks in the sales record column

Part and Inventory Search

Back
Top