Search results

  1. K

    Is there a way to export my query to a pre-existing word document?

    Hey guys! So currently I have a bit of simple VBA that opens a query in Microsoft word as an RTF: DoCmd.OutputTo acOutputQuery, "Disclaimed_Report_Excel", _ acFormatRTF, "Disclaimed Well Licenses.rtf", True My user then has to copy and paste the table into a different word...
  2. K

    Filling out a template in MS Word from an Access database

    Hi everyone, I am trying to fill out a pre-existing template in Microsoft word with information from my access DB. In it's essence this problem is quite straightforward, and I came up with a bit of code to carry it out (see below). My current hurdle: I have a datasheet subform with a list of...
  3. K

    Need help speeding up query on two huge linked tables?

    So I have two huge linked tables, and I want to conduct a fairly complex query on them. I've managed to extract the data I need, but my process uses multiple sub queries and it's just too slow for my DB users. Table 2 shows Facility ID, fluid type, fluid amount, and reporting date (as year and...
  4. K

    Complex query question-Grouped, Chronological Running Total

    I have a table (attached) containing well license numbers, shareholder name, update date, and shareholder % interest (from left to right). I need a query that will display the current shareholders for each well license and what % each one holds. Problem is, these shareholders change quite...
Top Bottom