I'm working on importing text files into a database, right now what I plant to do
is to do the import into access using VBA. With some help from fellow EE mebers
(see http://www.experts-exchange...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20998385.html
Can someone tell how to concatenate fields in a SQL query that is in a VBA function? Below is the current code.
sSql = "SELECT tblEOI_Import.EE_SSN,tblEOI_Import.EE_BadgeID, tblEOI_Import.EE_Las...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22061889.html
Zones:
MS AccessDate Answered: 12/18/2006 Grade: A Views: 0
Hi all,
My team & I have just finished developing a 500+ user application to be distributed to our various sites throught the UK. I need to come up with a name for the app but I'm struggling due...
http://www.experts-exchange.com/Other/Miscellaneous/Q_23058108.html
Hi
I'm not sure if I'm going about this the right way. I'm trying to update a table with values from a form. The problem I am having is that sometimes these values are empty, and sometimes they ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_234...
I have two tables, table1 and table 2. Table 2 has some records that are not in Table 1. I need to delete those records from table 1 so both tables contain only same records. in the example deleti...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23797503.html
I have an Access database which holds linked tables to a Unix system called Logic.
I need to write a procedure in VBA which takes the linked tables and puts them into the SQL Server database, call...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10307704.html
Zones:
MS AccessDate Answered: 03/14/2000 Grade: B Views: 0
i i am trying to make a command button perform a search and then use the results of that search.
e.g i want to send an email to all the people in an organisation with the postcode like "CF14"
I...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21106596.html
Zones:
MS AccessDate Answered: 08/26/2004 Grade: A Views: 0
Hi, Do you know of good applications that will allow you to connect SQL Database with Excel? I know with VBA I can do it directly but I am looking for some good and solid application available tha...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21624784.html
Experts - The SQL below works fine except for which form it checks for a value for criteria..
Set rstEE = DBEngine(0).Databases(0).OpenRecordset("SELECT tblCompany.PolicyHolderName, tblEOI_Impor...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22108760.html
Zones:
MS AccessDate Answered: 01/02/2007 Grade: A Views: 0
I have an access2000 database that creates a table that is then updated using the following sql statement:
Dim sqlquery2 As String
sqlquery2 = "INSERT INTO " & TableName.Value & " (Co...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_227...
