dcsimg

Search:

Type: Posts; User: jdc2000

Page 1 of 13 1 2 3 4

Search: Search took 0.59 seconds.

  1. Replies
    17
    Views
    293

    Re: VBA Run time error 9

    Your Dim statements should have an 'As (something)' to define the type of variable you are creating (Integer, Long, Double, Variant, etc.). If the variable is an array, it should have the maximum...
  2. Replies
    3
    Views
    178

    Re: Why won't this exit the application?

    Is it like the Energizer bunny? Do you keep hearing that drum beat?

    Does the application actually exit, then restart? What happens if you put a Stop of breakpoint before and after the Exit...
  3. Replies
    17
    Views
    293

    Re: VBA Run time error 9

    What is the value of pRasProps.Height - 1? If it is not too large, dimension your Fer_Year() array large enough to handle it:

    Example:
    If pRasProps.Height - 1 = 2000, then:
    Dim Fer_Year(0 To...
  4. Replies
    17
    Views
    293

    Re: VBA Run time error 9

    Fer_Year(i, j) has a maximum j value of 1000, so a j = 1001 will cause this error.
  5. Replies
    17
    Views
    293

    Re: VBA Run time error 9

    I don't see a Dim for vSafeArray anywhere. Triple check what that is set to. Also, what is the value of CLng(Fer_Year(i, j)) when you get the error?
  6. Re: SQL - import also the hyperlinks when bulkcopying from Excel

    Possibly useful links:

    https://howtouseexcel.net/how-to-extract-a-url-from-a-hyperlink-on-excel
    ...
  7. Replies
    3
    Views
    286

    Re: Network Printer Problem

    Assuming that "e02" is the computer that the HP 8710 is connected to, it sounds like you added the XPS Document Writer printer driver. This printer driver is included by default on most Windows...
  8. Replies
    28
    Views
    249

    Re: VBA error

    For the Dim issue:

    Example:


    Dim IRR As Double


    For the double post issue, only click once on the Post Quick Reply, or click Go Advanced and then click Post.
  9. Replies
    28
    Views
    249

    Re: VBA error

    It looks like most of your variables are Integers. Those have a maximum value range of -32,768 to 32,767. If the values you are trying to Input into them are outside that range, you will get the...
  10. Replies
    28
    Views
    249

    Re: VBA error

    The Dim statements we need to see are the ones for the variables in the line that is causing the error:



    Dim X As ????
    Dim Y As ????
    Dim DEM As ????
    Dim Slope As ????
    Dim Landuse As ????...
  11. Replies
    28
    Views
    249

    Re: VBA error

    An overflow error may indicate that you are attempting to store a value that is too large in one of the variables you have defined. Since we cannot see your "Dim" statements, it is hard to say which...
  12. Replies
    28
    Views
    249

    Re: VBA error

    OK, now we have the line of code where the error is occurring. That gives us some ideas as to what possible errors can occur. However, we still do not know exactly what the error message is. Post...
  13. Replies
    28
    Views
    249

    Re: VBA error

    We have no idea what this means. Also, there are no line numbers in the screen capture, so 'line 390' is not helpful. We also still do not know what the error message you are getting is. Post at...
  14. Replies
    28
    Views
    249

    Re: VBA error

    This forum makes screen captures hard to read. Post the code (enclosed in code tags) and the text of the error message. Add a comment to the line causing the error so we can diagnose the issue.
  15. Re: VS 2017 Trying to backup the database i get error why?

    It looks like you have a space in front of "\Testplus.bak" that probably should not be there.
  16. Re: vb.net equivalent of GetRidofHTML

    What are the "complaints" you are getting? Post the error messages.
  17. Replies
    1
    Views
    195

    Re: Virus Code in attached word file

    That looks like malware to me. It appears to create some scripts to download more malware. The actual code is obfuscated, but I wouldn't run that macro to test it on anything other than a test...
  18. Replies
    7
    Views
    217

    Re: Exported Excel won't open on some PCs

    Have you tried UnChecking those 3 Protected View settings in Excel on a machine where you have this issue?
  19. Re: How can I apply ctrl+Shift+enter to a number of cells in rows 3 to 6 of activeshe

    Try this:



    Sub ApplyFormulaArrayToRows()
    '
    ' ApplyCSEToEntireRow Macro
    '
    '
    Dim Column As Long
  20. Re: VB6 - Apps look worse under Win10 than under Win7 with the classic theme

    Many of us in Idaho Falls know how to use available tools. Of course, there are always some whose idea of tools is rocks and sticks.
  21. Re: VB6 - Apps look worse under Win10 than under Win7 with the classic theme

    Windows 10 and the "modern" theme is like playing Myst - you are always trying to decipher cryptic runes and hieroglyphs to try to decide what to click on to get something done.

    It might look...
  22. Re: VB6 - Apps look worse under Win10 than under Win7 with the classic theme

    All Apps/programs look worse under the "modern" theme.
  23. Replies
    5
    Views
    291

    Re: Problems accessing vbforums.com

    It looks like you got to QuinStreet's server (VBForums, etc.) before timing out. I would say that something is blocking you at that point.
  24. Replies
    9
    Views
    329

    Re: Latest Windows 7 update

    It is also why you have a NAT router and a firewall. Windows 10 has plenty of security holes in it. The only difference is we don't yet know where all of those holes are. The hackers just might...
  25. Replies
    5
    Views
    291

    Re: Problems accessing vbforums.com

    Can you do a traceroute to vbforums.com? What results do you get with that?
  26. Replies
    0
    Views
    142

    vBulletin zero-day published

    Anonymous researcher drops vBulletin zero-day impacting tens of thousands of sites

    https://www.zdnet.com/article/anonymous-researcher-drops-vbulletin-zero-day-impacting-tens-of-thousands-of-sites/
  27. Replies
    71
    Views
    7,904

    Re: Windows August 2019 Update break VB arrays

    Microsoft still hasn't gotten it right:

    https://www.zdnet.com/article/windows-10-1903-problems-now-microsoft-reverts-change-that-muffled-audio/
  28. Thread: 13 years

    by jdc2000
    Replies
    59
    Views
    1,632

    Re: 13 years

    October 2001 for me.
  29. Replies
    71
    Views
    7,904

    Re: Windows August 2019 Update break VB arrays

    And here is the latest update on Microsoft's updated "update":

    https://www.techrepublic.com/article/windows-10-start-menu-problems-microsoft-investigates-if-latest-fix-breaks-search/
  30. Re: I need Help with word Maco Looping until the end of the document

    A clear explanation of what exactly task(s) you are wanting the macro to perform for you on the document would be most helpful to us in order to provide assistance.
  31. Replies
    11
    Views
    320

    Re: Function Keys in Windows 10

    If you have not installed SP6, then check out this link:

    https://www.microsoft.com/en-us/download/details.aspx?id=5721
  32. Replies
    1
    Views
    368

    Re: Anyone have experience with TechRepublic?

    I check the free TechRepublic articles daily. They have lots of good information all the time. Their premium content can be well worth the cost versus the cost of researching and compiling the...
  33. Replies
    11
    Views
    320

    Re: Function Keys in Windows 10

    Windows 10 should not be interfering. There may be another issue however.

    Possibly useful links:

    http://www.vbforums.com/showthread.php?506169-F8-Key-in-Debug-Mode-Does-Not-Work
    ...
  34. Replies
    71
    Views
    7,904

    Re: Windows August 2019 Update break VB arrays

    The latest update may possibly have the fix:

    https://www.zdnet.com/article/microsoft-weve-fixed-windows-10-1903s-cortana-cpu-spike-bug/
  35. Re: [RESOLVED] How to Shell from a directory with spaces in path?

    Shell """" & sExePath & """ """ & sFilePath & """"


    Clearer to read? Maybe for some it is. I would have to disagree.
  36. Replies
    24
    Views
    1,113

    VS 2013 Re: Send file wia RS232?

    If the old DOS software is creating the file to send, did you compare the file created on the old DOS PC with the file created on the laptop to make sure that they are exactly the same?

    Did you...
  37. Replies
    4
    Views
    246

    Re: Shell-Pipe Cmd Within vb6

    And we still have no idea what the actual function or functions you are trying to accomplish might be. Why would you ever need to Shell a "cd /" command? A full and clear description of what you...
  38. Replies
    71
    Views
    7,904

    Re: Windows August 2019 Update break VB arrays

    Latest updated info:

    https://www.zdnet.com/article/windows-10-1903-buggy-update-slows-pcs-breaks-desktop-search-says-microsoft/
  39. Re: How to watch file changes *and get process id, including when no timestamp change

    I would also be interested in this project. Even with Windows 7, I have one PC with only Windows installed that still hits the hard drive once per second continuously. A program that could find out...
  40. Replies
    8
    Views
    289

    Re: open file using cmd

    An Access Denied message does not surprise me.

    What error message do you get if you run the .bat file manually as Administrator from a different file path?

    Check each of the folder locations...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width