Recent content by kmsmith

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

Thanks a ton!!! I think I can just use the approach from the first video and query records that are checked! I'll play around with it.

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

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

I cannot thank you enough plog! That worked beautifully. I clearly need to brush up on my SQL skills!!! :D

I have created a simple set of sample data that illustrates the workflow I have in mind, see attached :) --I hope this makes more sense.

Plog--posted my ultimate goal. For the first step of my query however, this would be fine--I would then make another query to eliminate anything over 100: License_Number Work_Int_Partpt_Legal_Name Update_Date_Time Work_Int_Partpt_Interest Running Total 0000001------------------Company...

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