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 dencom 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: *
- Users: Xscatolare
- Content: Threads
- Order by date
-
Excel SQL Variable date not working even with Format
I have hit a wall here and trying to figure this out. At one point I did have it working and lost the changes due to system malfunction. Anywho, I thought i could recreate it and I can't seem to be able to do this. I have tested the base SQL string in PowerQuery and it works until I add the date...- Xscatolare
- Thread
- Replies: 25
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel 2016 - ADODB recordset append to table1
OK, i have Googled high and hard for a couple days to figure this out and just have to post because I find something close but not complete. Here setting up the sql string. constring is a public varibable. Sub ReplenQueue() Dim strSql As String Dim target As Range Set target =...- Xscatolare
- Thread
- Replies: 8
- Forum: Microsoft: Office
-
Group by ID and determine consecutive dates
So I have researched this forum and the innerwebs trying to find some similar solution that I could outfit to work for my needs. Since I am posting here I have not succeeded in finding the solution so I appreciate your time to help me out. Here is what I am looking to do via VBA and future one...- Xscatolare
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
