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

I have a table named tblFriends: tblFriends is generated from query qryFriends. The data and numbe… Read more How To Add Sequential Numbers Next To Data From Query

I am trying to create a database in Microsoft Access 2010 involving records of employees. One of my… Read more Textbox As Input In An Sql Query In Access

I'm new to VBA and Access in general and ran into this problem whilst trying to use the propose… Read more Vba/access Recordset Per Form Record Problem

I have the following VBA to get datas from the database using the SQL statement in this VBA: Sub Co… Read more Use Column Alias From Sql Query As Column Header In Excel

This must be a very simple mistake. I just can't see it. My Where String: strWhere = 'tbl_f… Read more Access Openreport Not Working With Where Condtion

When I call a SQL Server stored procedure from MS Access front-end using the code shown below, it s… Read more Calling Stored Procedure From Ms Access Results In Error 3146

This is the code: sqlStr = 'INSERT INTO Students (ID, Last Name, First Name, E-mail Address, St… Read more Trying To Execute A Sql Statement From Vba To An Access Database, Getting A Syntax Error With The Insert Into Statement

This is wrecking my brains for 4 hours now, I have a Table named BreakSked, and I this button to up… Read more Update Sql Ms Access 2010

I have those two tables is MS Access : lkpSchemaPIT : | UID | lkpSchemaTitleEng | |-----|-… Read more Error 3346, Trying To Insert Into, Two Consecutive Tables

I have written a simple ASP.NET MVC 2 application that stores data and can dynamically create excel… Read more How To Push Data From Excel To Sql Server?

Daily, I currently have to: download 50 files, 40 are in .csv (comma separated values) format, an… Read more Loading Files Into Teradata

Below query is showing error Please help : DoCmd.RunSQL ('insert into tbltesting (IsDiff)value… Read more Vba Sql Problem