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!

  • 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. strongm

    Query expression negative to a 0

    Format([Basic Salary]-[Amount from Column A]-[Exemption Credit],"#.0#;\0")
  2. strongm

    Query expression negative to a 0

    A use of Format in the query might work here. But, as dhookom says, probably best to look at a UDF
  3. strongm

    possible to use xml2 or Set WHTTP = CreateObject("WinHTTP.WinHTTPrequest.5.1"), instead code in message

    >my test code, dont work If you mean the code in the first post here, then it works fine here. But I'm on Windows 10 and, whilst IE has been 'removed' from Windows, the com library, Internet Controls, which is "internet.explorer", still works fine. I am led to believe that some installations it...
  4. strongm

    possible to use xml2 or Set WHTTP = CreateObject("WinHTTP.WinHTTPrequest.5.1"), instead code in message

    mxxml2.XMLHTTP and WinHTTP.WinHTTPrequest.5.1 are for most of your purposes pretty much the same thing, and you can use either interchangeably, i.e wherever you might use CreateObject("MSXML2.XMLHTTP") you can instead use CreateObject("WinHTTP.WinHTTPrequest.5.1") with no other changes...
  5. strongm

    Convert PDF file to text

    >A fairly current version of Word Word 2013 or later
  6. strongm

    Converting from 32bit to 64 bit. After converting, database takes significantly longer to open

    Try Decompiling your DB (a commandline thing, e.g "C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE" "YourDB.accdb" /decompile) Recompile the VBA project (from VBA editor: Debug > Compile). Then compact and Repair
  7. strongm

    Based the link above how to simulate click event

    >imulate the click event Without the IE engine you'll need something like the WebView2 control or Selenium. XMLHTTP only sends HTTP requests and does not parse or run JavaScript or HTML like a browser does (under certain circumstances it is possible to emulate what the click event does, but I...
  8. strongm

    No longer watching

    Yes, and sal21/luca90 frequents that as well, cross-posting as they go ...
  9. strongm

    No longer watching

    Given that VB as a whole currently (April 2025) has a market share of around 0.38% (at least according to PYPL PopularitY of Programming Language), and that VB6 is only going to represent a small proportion of that 0.38%, I am often surprised we get any posts in here at all! Even if we go with...
  10. strongm

    scraping table dont work

    Completely unnecessary
  11. strongm

    get value from html page

    Why do you think you need a Do loop with this call? It's synchronous
  12. strongm

    get value from html page

    Well, no. becasue that value is actually derived from a hidden HTML property of the input form. Which is a good thing, because that's easy to capture Option Explicit Public Sub spoon() Dim html Dim fonttags Dim inputtags Dim inputtag Set html = New HTMLDocument With...
  13. strongm

    get value from html page

    So is your real question is how do you scrape the value at that particular position, NOT how do you scrape 7075
  14. strongm

    get value from html page

    There's clearly more to it than simply retrieving 7075. Today, for example, the value appears to be 7076 If you provide a brief explanation of how/why you need this value we can suggest an appropriate solution.
  15. strongm

    scraping table dont work

    Given my code should be returning the value of every single cell in the table, what is it that you are actually trying to do? You want to treat the table like an array? In which case: result=myHTMLTable.Rows(rowIndex).Cells(colIndex).innertext
  16. strongm

    scraping table dont work

    Have you tried it?
  17. strongm

    scraping table dont work

    Becasue this code is in not written to scrape the page properly. here's something to put you on the right tracks, but leaves you with some work to do. Private Sub FILL_TABELLA_ANNI() Dim X As Long Dim result As String Dim cell As Object Dim ODOM As HTMLDocument Dim...
  18. strongm

    CREATE msflexgrid as in xlsx file

    My code takes no account of how many columns the flexgrid actually has, It will fail if there are not enough columns available. So just add a few more (either at design time or run time)
  19. strongm

    WHY the sort dont work in msflexgrid

    Flexgrids sort on an entire column - you can't only sort part of that column. And whilst you have populated only 15 rows, there are MORE than 15 rows in your columns. And so empty values are being included in your sort.
  20. strongm

    SORT DATE in msflexgrid not correct

    >SORT DATE in msflexgrid not correct In what way is it wrong >the date in array have thuis format: dd/mm/yyyyy Just to make certain, the regional shortdate format on your PC is?

Part and Inventory Search

Back
Top