rst

Hello all, I've been reading (lurking) these boards for a while now - all help so far has been much appreciated however, I now need something that I couldn't already find! I have been given an SQL query and asked if I can pull this data into Excel rather than having to use SQL Dev and emailing...

Ok, this shouldbe the last thing I need help on. Thanks to those who helped thus far, my project is pretty much done. Here is my issue: I have a form where users can enter multiple resorts and dates for which theywant to perform an action. The form locks the values in a table called Log. My...

I'm trying to create VBA code (or functions if possible) that will identify all matching entries in column A and then total the values in a range from columns B through E from the rows with the matching entries, and then continue on to the next set of matching entries in column A. For...

First, My apologies if this is posted somewhere else with a solution but all my searches have come up with no specific solution(s). 2nd, I am not an expert programmer but I know enough to do some automation with the basics. I have been able to create a pivot table in Excel 2016 using vba with...

How do I change the following code, which works, so that it is early binding? Dim strConnect As String Dim strAccessFile As String Dim strSQL As String Dim rst As Object Dim strLandParcelID As String On Error GoTo ErrorHandler strAccessFile =...

I tried to run a query from an Excel worksheet. Below is my code but I think I am missing something here it does not work. I think my problem is the SQL code. Any help? I still got "Automation error" – ThanksBaha <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas...

I have the following code which errors as given below. Calling line is Call ObtainPremiumSummaryData("3000724", #1/7/2017#, #1/7/2016#) Public Sub ObtainPremiumSummaryData(strCustNo As String, dteClaimYearStart As Date, dtePreviousYearStart As Date) Dim cnn As New ADODB.Connection...

I had created an access database to store path names of files on my local drive using the below vba code: Dim rst As dao.Recordset Set rst = MyDB.OpenRecordset("MyTable", dbOpenDynaset, dbAppendOnly) With rst . AddNew ! [File_path] ="Link" & "#c:\myfiles#" .Update rst.Close I have only...

This code is taken from here: https://www.ozgrid.com/forum/forum/tip-tricks-code-no-questions/advanced-excel-integration/7960-create-a-unique-list-with-ado-sql-from-closed-workbooks-xl It removes duplicates using the SQL command DISTINCT. The problem is it works for a small column of...

Hello, I am having an issue with my audit trail. It works perfectly, however I was told that only edited and deleted records will need to be kept in the audit trail. New records do not need to be in the audit trail. As I attempted to manipulate my code to exclude new records, I've noticed...

Hello everyone, Excuse me if this is too hard or too simple. I absolutely love spreadsheets and I believe that a lot can be accomplished by automation. I am trying to automate numbers of personnel that are either in today, sick, or just didn't show up. I have the list of people and next to...