Lab Sql

I need to implement a check to see if TableA exists, if it does, drop the entire table. If it doesn… Read more Vba Script To Check If Table Exist On Ms Access, Delete If It Does

I have the following query in MS Access 2013 than does not return a Median value. The field IU is … Read more Dmedian In Access 2013, No Values Returned

i'm trying to use the code below to copy data from a sql (2008 r2) table to multiple sheets in … Read more Excel Vba Copyfromrecordset Slows When Copying Over 100 Columns

I am trying to create a very dynamic macro that will update different tables in a Database, dependi… Read more Operation Must Use An Updateable Query / Sql - Vba

I'm trying to use the Previous() function in a report indicator to display an up or down arrow … Read more Use Of Previous() Function In Reverse Date Sorted Data In Ssrs?

I have a series of three tables which I would like to join together using ADODB in an Excel VBA app… Read more Nested Join In Excel Vba (adodb) Results In "join Expression Not Supported"

I am using Access 2007 (VBA - adp) front end with a SQL Server 2005 Backend. I have a report that I… Read more Save Access Report As Pdf/binary

I have created dropdown list which gives suggestions from existing data (like google search). I hav… Read more Performance Issue In Dynamic Dropdown Search List In Excel