Search results

  1. J

    Finding the right numbers in a comment field with a function

    What function to use when looking for part of a string? Hmm, I've been wondering how to explain this. I have a column that is either filled through a query, but also with manual comments. So as you've guessed they don't always match in layout. The layout should be XXXX (building number) XX...
  2. J

    Transforming XML to HTML in Access with VBA

    Oke, to start off I'm pretty much a beginner when in comes to VBA. For a project I got an XML file that just won't import correctly into Access, it leaves out columns and or data. My predecessor solved this with a workaround by importing the XML into Excel, doing some data/text changes and then...
  3. J

    When importing XML files, not the entire structure is imported

    I'm trying to import an xml file with invoices for our company. I've tried importing it without a table present and i tried with a prefix table with all the columns i want to import. In both situations Access doesn't import all the columns. When looking at the structure I can see that Access...
Back
Top Bottom