Search results for query: *

man you rock thank you for all your help every thing is working great. I got it printing to table now thanks again sooooo much.

...the table I think im way off. Just need to be pointed in the right direction. //Concatenate.java //adds decription fields together import java.sql.*; import java.util.ArrayList; import java.util.HashMap; import java.util.Iterator; import java.util.Map; public class Concatenate { private...

Thank you so much for your help this has been a hard project for me. This was my first program in Java thank you again.

...XLS sheet. Here is my code This is my first java program so pleas give detail. //Concatenate.java //adds decription fields together import java.sql.*; import java.util.ArrayList; import java.util.HashMap; public class Concatenate { private static Connection connection; private static...

...desc in my array list any ideas on how to get all decs in the array list. //Concatenate.java //adds decription fields together import java.sql.*; import java.util.ArrayList; import java.util.HashMap; public class Concatenate { private static Connection connection; private static Statement...

...got so fare This connects me to the database and lets me call a SQL string //Concatenate.java //adds decription fields together import java.sql.*; public class Concatenate { private static Connection connection; private static Statement statement; public static void main(String...

sorry about that I was wrong I do not have a Excell file with information.

this data was exported out and im cleaning it up i have it in a excell spreed sheet two if you think it might be easer to right code to change that, I dont realy care what order Dec gets put into in the single column just needs to be done.

any ideas on how to get started or what type of code i can search for that might get me what i want.

I have a table that has two main fields one called part# and the other des for decription my table has mutipal part# with dec that that are defrent I need to have one part # and the decription field des need to be combinded. The tables are stored in access I also need to create a concetion to...

thank you sooooo much it worked great!!!!!!!!!!!!!

it runs with out errors but it still keeps duplicat part numbers any ideas

SELECT Partno, Concatenate("SELECT Desc FROM Edmanmanruby1 WHERE Partno =" & [Partno]) AS Descriptions FROM Edmanmanruby1;

the error i get says Data type mismatch in criteria expression

im geting error when runing this here is the coad im using for the link above Function Concatenate(pstrSQL As String, _ Optional pstrDelim As String = ", ") As String Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs =...

oh i just need to run the sub ty

I have a Module in MS Access with this code and I need to know how to call it runing a query Option Compare Database Option Explicit Public Sub RSLoop() Dim rs As ADODB.Recordset Dim rs2 As ADODB.Recordset Dim varPart As String Dim cntr As Long Dim varDesc On Error GoTo ErrorHere...

ok thanks that help

im working in MS Access

that looks right but looks like its in sql im not experinced enough to convert it any tips its been long time since i have writen one line of code