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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Create Excel Application by VBA
Hey guys, I am very new to VBA. I am just trying to create excel application by VBA. It gives me an error: 0 Private Sub Command27_Click() On Error GoTo ErrorHandler Dim xlApp As Excel.Application Dim myFile As Excel.Workbook Dim mySheet As Excel.Worksheet Dim...- tamkas
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
SQL Question
hi r937, the exact query: select sum(case when source = 'IG' then 1 end) as numIG , sum(case when source is null then 1 end) as numNull from Invoice -
SQL Question
I got this error when I used the sql statement. Expected identifier, literal, or parameter, found keyword "WHEN" (to use a keyword as an identifier, enclose it in double quotes) Do you guys have any suggestion? -
Basic Java program: coding error
Hey guys, I am very new in Java Program. I was trying to sort numbers in the program. import java.io.*; /* * Main.java * * Created on May 19, 2007, 10:18 PM * / public class SortNumbers{ public static void sort(double[] nums){ for (int i=0; i<nums.length; i++){... -
SQL Question
Hi, I was wondering about this table and the sql statement: This is the sample Invoice table: Source | Items IG SEL IG ANB Null BEL IG REN Null REN I like to count how many items are in NULL and IG. This is my SQL statement...
