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

    Kick off MS SQL Server DTS from Excel VBA

    it's ok, worked it out ...
  2. TroyMcClure72

    Kick off MS SQL Server DTS from Excel VBA

    Anyone know where it is ... i can't find anything!
  3. TroyMcClure72

    Kick off MS SQL Server DTS from Excel VBA

    Does anyone know how I can kick off a DTS package from xl vba?
  4. TroyMcClure72

    ADO - vbScript limiting records in the recordset

    Sorry should have said, db i'm using doesn't accept TOP !!!!
  5. TroyMcClure72

    ADO - vbScript limiting records in the recordset

    I've created an ADO connection within DTS using vbScript ... can I limit the number of records returned? I've tried using MaxRecords but it doesn't like it! If Not isNull(recSQL(5).Value) then connDW.MaxRecords = recSQL(5).Value End IF connDW.Open = "DSN=" & recSQL(2).value &...
  6. TroyMcClure72

    ADO, SQL and the like statement

    Cheers guys, i was using the wrong wildcard. J
  7. TroyMcClure72

    ADO, SQL and the like statement

    Thanks for the reply, but I tried that, it doesn't work either. Using Chr(34) was just a different way of enclosing in quotes.
  8. TroyMcClure72

    ADO, SQL and the like statement

    Using ado from excel to execute sql statements against an access db. I have a problem when using the "like" statement though, as it never returns any data. Even though if i paste the same sql into the query builder it returns data. i've tried diff wild card characters ... anyone help???? sql...
  9. TroyMcClure72

    VB Programmer needs you help!

    Simple! I do love VB ... Thanks for the reply ... it's starting to make sense. Cheers James
  10. TroyMcClure72

    VB Programmer needs you help!

    Hi all, Can someone give me a clue what this function is doing? I'm not, as you may guess, familiar with Javascript, but doesn't stop the boss asking me to look into it! The function I believe, should be counting the number of jpg's in a folder 'charts' that start with a specific string ...
  11. TroyMcClure72

    Using animated gifs on an Access / Excel form

    Is it possible ... if so how?
  12. TroyMcClure72

    Autofilter - couple of questions

    1. Can you remove options from the autofilter drop down list ie the (Blanks) / Top 10 etc. 2. Can you detect when an autofilter has been applied / removed?
  13. TroyMcClure72

    Excel cdate prob

    I have a column of TEXT formatted cells in the with dates in the format DD/MM/YYYY. when using cdate in vba to convert to a date, the dates seem to randomly convert to both UK & USA date formats, even if i use the format command to try and force it to DD/MM/YYYY ... any ideas?????
  14. TroyMcClure72

    Excel, check if references are missing ...

    Is it possible in workbooks open, to determine if a reference is missing to avoid the compile error message. Is it also possible to select another ref instead, ie if word 10 missing and work 9 available use that???? Cheers J
  15. TroyMcClure72

    VBA speed issue, can anyone help?

    I do have that in already! Sorry just edited out that bit of the code. calculation is turned off too.
  16. TroyMcClure72

    VBA speed issue, can anyone help?

    I'm using the code below as part of a subroutine to reformat some Excel data files. When I run the code from an Excel module it takes around 1 to 2 minutes to process the data. When I run it from Access, after creating an excel object etc, it takes 30 minutes +. Can anyone suggest why / how I...
  17. TroyMcClure72

    I've a question.Please

    do you really want to delete it? You dan just hide TexboxName.Visible = False Or disbale it TextboxName.Enabled = False
  18. TroyMcClure72

    Workbooks.open disable macros

    Can you disable macros when using workbooks.open? If so what;s the syntax? cheers
  19. TroyMcClure72

    Excel Application.Calculation prob

    Actually pressing f9 (calc) causes the same error so it's not nec. vba related ... but still any ideas why this is happening?
  20. TroyMcClure72

    Excel Application.Calculation prob

    Hi all, I've got numerous workbooks made up from the same template workbook. On the Workbooks_Activate event there's a line: Application.Calculation = xlCalculationAutomatic Which works fine on some workbooks, but on some i get a critical error, asking me to send report to MS & recover etc...

Part and Inventory Search

Back
Top