Hi All.
I need to produce a phone billing report using vbscript that would summarize all call values by phone number. The bill is in access and I can connect and query it with no problem u...
Hi,
In VB5, how can i access any database(.dat), read every record, then convert it to Recordset, & save as (.mdb) database ?
NB: The (.dat) database & its fields are specified by the user i...
In http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/VB_Databases/Q_21072126.html I got a solution to open a media player from VB (and it works fine). Now, I need...
I try to execute a Stored Procedure which exists in SQlServer database within a VB6.0 program. I have a connection of my database in a program. I checked for the call instruction of my Stored ...
Hello,
I am trying to use transactions in my VB.net program. I have opened a connection, and have opened a transaction on it and
Dim m_objConn As OleDb.OleDbConnection
Dim m_objTrans As...
Hi,
I have a Visual Basic 6.0 Pro project that connects with ADO to a SQL Server or Oracle database. If the user pastes too much data into a field, they get an error:
Data provider or o...
Hi.
Well. I cant make .filter filter records in the recordset.
I am using dynaset type recordset, because I need the filter.
Probably it is because my code is wrong. I mean I looked at the ...
I am creating a VB6 appliation that logs live data and inserts it into a Access table. This database also has a main table that contains pertinanent information to the test being run. This m...
I have an Excel spreadsheet that needs to access 6 different files on an AS400. Do I need a seperate ADODB connection for each file or just a different recordset with a different SQL Select s...
I am recieving a 1004 Error - Can't locate Blank cells in the following VBA macro. How can I tell the program to skip to end sub if an error occurs. Other than this bug the tool works fine whe...
I have a Visual Basic 6 Application that has a form with a Crystal Reports Viewer Control. I am receiving an Error No.13 Type Mismatch Error on the line marked below:
........
Dim Applicat...
I HAVE A CRYSTAL REPORT IN 8.5 CONNECTED TO MS ACCESS MDB TABLES AND PERVASIVE DSN TABLES.
IT IS TAKING 2 PARAMETERS FROM VB CODE.
I WANT TO EXPORT THIS CRYSTAL REPORT INTO EXCEL FILE.
CO...
I have a worksheet that is provided to me by a 3rd party that has the first 2 columns hidden.
They are headers.
The 3rd line has one value in the first column, but nothing in the rest.
When...
Easy points:
How about an example of how to run a SQL query from within an SQL 2005 SSIS Script Task using an existing connection?
Thanks
I have a scalar function in a SQL 2000 database that works fine:
=============
ALTER FUNCTION dbo.CountDupes (@UserID int)
RETURNS int
AS
--counts the number of consumers in the mainUsers...
Hopefully one of you experts will be able to help me with the following (I have done this before but cannot remember how):
I have two database's DB_FROM and DB_TO, and at the click of a but...
Question:
I have a website and the inventory is updated from csv files. We currently do this manually every night.
I need to know how to automate the import of these csv file into ms access....
I have VB program that reads in data from various file formats (CSV, text, etc). The problem is that with the attached file, seems to have both CSV and tab delimiters. I can import it (w/wiz...
I am experiencing an error mentioned. I tryed everything to fix it, but nothing helps, even MSDN article.
I have been created a distribution package and I install in client user but when I start a form with crystal report control, this message appears :
'The libary PDSSQL.DLL connot be found. Co...
I am using Oracle OraOLEDB provider from my VB application to connect to Oracle database. If my password has expired for the user which i am using in my connection string, then at the time of ...
excuse for my English:
The same program written in vb6 works in a terminal server but not in an other although they are identical, it is for and versions client oracle that for the regiona...
Here is the SQL Query generated by the crystal report designer. How can I use this at runtime with crystal report control.
CRST.SQLQUERY={Below Query}
I want to use this query for input valu...
This is a VB6 application with embedded Access. Text strings are executed via db.execute "SQLcommand" to query and alter the db. What is the command to DROP PRIMARY KEY. There is an existing...
Hi,
In my app now I using DAO to access an Access DB. The reason for this is
because DAO is faster working Jet engine than ADO and DAO to distibute is
smaller ADO. Now i come to some pro...
