Search results for query: *

Hi I have a number like this: 08312345678 When I enter that number in excel cell, the zero is removed. I can format the excel cell not to discard the zero using the Excel application. I want to do the same thing programatically with visual basic. How do I do that? If I want to format a cell to...

Hi I want to preview crystal report with the recordset result. I need to pass parameters to the query that crystal report uses. I tried ODBC, inserted parameter fields on the report so that I get prompted to enter them when I preview the report. Nothing works. It does not even prompt for...

Hi This is what I have: Const strLcQUERY_NAME As String = "AwbEnquirynull" Const strLcQUERY_PARAMETER1_NAME As String = "StrName" ' This can be anything Const strLcQUERY_PARAMETER2_NAME As String = "NodeType" ' This can be anything Dim cmd As ADODB.Command: Set cmd = New...

Thanks very much for your inputs guys.

Hi I have VB application and use Access 97 as my DB. The application works fine on my machine. I created a setup of it and ran the setup on another machine and it still works. Now I want the application to work on the CD as well. i.e Users must have a choice of running the application on CD or...

Hi I have sql stored procedure like this begin tran sql statements.... if @error <> 0 begin Rollback Tran end else commit tran What should happen is that if there is an error then the rollback will happen i.e no tables will be updated. Now what happens if a rollback gets aborted?

Hi I have sql stored procedure like this begin tran sql statements.... if @error <> 0 begin Rollback Tran end else commit tran What should happen is that if there is an error then the rollback will happen i.e no tables will be updated. Now what happens if a rollback gets aborted?

Its a good idea Bob Scriver. I will use it. Thank you very much.

Hi Ken Reay I tried what you suggested and it does not work. Any ideas or suggestions guys?

Hi I am developing a vb5 application and microsoft access 97 is my database. I have to print a report based on the parameters that i enter on the vb form (textbox). i have a query in access db which i have to pass two parameters to in order to display results. How do i call that access query in...

Hi Guys I have tried everything you advised me with but it wouldnt work. insert into Temp (val) ( select val1 AS val from table1 where val2 = '123456' UNION select clng(c.ref) AS val from acthist a,acthist c... ) Temp is an Existing table.

Thanks guys it works both ways. Now, How do I insert a record into one table using two select queries joined by a UNION. This should be in access. e.g. insert into Temp select val1 from table1 where val2 = '123456' UNION select clng(c.ref) from acthist a,acthist c WHERE...

Hi Please help me convert the following sql query into ms access 97 query. Your help is appreciated. select convert(int,c.ref2) from acthist a,acthist c WHERE a.ref1 = '123456' and c.ref1 = 'asd123' and c.ref2 <> '-1' AND c.actdate > = 'somedate value' and...

Hi All How do i convert the following sql 6.5 query into Ms Access 97 query. SELECT a.Rem,b.nam,c.Pro,d.Exp,e.Fligh FROM Table1 a LEFT OUTER JOIN Table2 b ON b.Code = a.Cone LEFT OUTER JOIN Table3 e ON e.AwbN = a.AwbN LEFT OUTER JOIN Table4 c ON c.AwbN = a.AwbN LEFT OUTER JOIN Table5 ON...

How do I convert this sql 6.5 query into Ms Access 97 query? SELECT a.Rem,b.nam,c.Pro,d.Exp,e.Fligh FROM Table1 a LEFT OUTER JOIN Table2 b ON b.Code = a.Cone LEFT OUTER JOIN Table3 e ON e.AwbN = a.AwbN LEFT OUTER JOIN Table4 c ON c.AwbN = a.AwbN LEFT OUTER JOIN Table5 ON d.AwbN = a.AwbN...