I trying to get VB6 to access a MySQL database on a remote server.
Have done this before but using a Data Source Name set up in Admin but don't want to do it that way this time for installati...
VB6 and Access using ADO to manipulate records. In a select statement I am tyring to retrieve 1 record. BOF and EOF = true and therefore I get error 3021. However if I insert a message box the...
i am having two recordsets, first one RS1 is associated with a table using "Select * from TableName" and is Opened.
2nd one RS2, is not yet opened.
i want to copy few records from RS1 whi...
I am using VB6 with MS Access2003 as DB.
When I insert a new record or edit current record with ADODB.Recordset object, sometimes I get "record is locked" error message.
I am thinking about...
Can another set of eyes take a lookat the following code and provide insight as to why its bombing out. Basically it loops through the records found until end of file and I would like it to a...
Dear EE experts,
I presently use the following standard method of connecting to an Excel sheet as database:
Set oConn = New ADODB.Connection 'Open the ADO connection to the Excel wor...
I am trying to export a query called "2002" via Excel.
This works fine if I am actually in Access and select File->Save As/Export and choose Excel as my format.
However, when I am in Acc...
Hi,
I have datagrid vith ado and i have several column in this datagrid. So, there is a colon as time. I wanna highlight first row as current time. Structure like this:
time event...
How do I create a table parameter in VB, so I can call the GetFileName proc and return the recordset? I can add parameters that are char, varchar2, number, ..., but I've never done it with a t...
Hi, in 2 days I need this question already programed to show so im in a bit of a urgent state :\
I want to upload a document (.doc, .xls or .pps) to a MS SQL DB, and while searching on the ...
I want to get NT UserID of the user who logged on to the machine and want to use that ID for some authentication. I appreciate your help on this
Thanks
VM
Would somebody give me sourcecode or tutorial on using VB to connect to MSSQL Server ?
I'm getting "overflow" error on the following line of code. The functionality automatically sends an email out of Access with 4 reports attached to it.
Dim myOutlook As Object
Dim s...
Hi there.
Because the data i receive from mscomm is in ascii form, so i can't read it as text.
Anyone hv any idea on how do i convert ascii to byte form?
mscomm1.portopen = true
text...
Stored procedure vs SQL Statement
I am currently working on a VB6 application (ADO Connection) that uses SQL2000 as its backend.
The program is nearly complete and runs great but it has m...
Through a SQL select I have 7 fields I am getting data from, two of the fields are boolean, these two field values need to be change from True/False to 1 or 0. The data is coming from an Acces...
Hello!
I know this error has been talkt about here earlier but I can't still figure out what's wrong with my code. Suddenly I started to get this error message though I didn't touch anythin...
I am making an application in Vb 6 Where one of the situation where i need to execute some SQL Script files which is in a perticular Windows directory. I tried an option where i Opened the fil...
I have 2 ADO Recordsets that i want to combine into one RS to later sort and output. I was trying to add the one recordset to the other, but the original database was being updated when i did...
Dear Gurus
I have the following working SQL code (per EE response yesterday), working in a VB6/ Jet environment:
SQLStr1 _
= " INSERT INTO " & tbl & " IN '" & txt_Output...
In COBOL you can do a "multi" case statement on more than one variable, the syntax is thus:
Evaluate A,B
When 1,2
do this
When 3,4
do that
End Evaluate
Seems to m...
I have a pre-built/compiled program (MS Access MDE file, front end, and MS SQL 2000 backend - which I have full access to). Our company sells services and we pay our sales people commission. ...
In VB6, can I use the Microsoft DataGrid directly (i.e. without the ADODC control)? If so, can someone show what the code looks like to display an Access 2003 recordset (ex. SELECT * FROM MyD...
After I add a new customer to an Access table my ComboBox is updated with the new customer which is last in the list, what I need to do is have the new customer appear automatically as if it w...
I have two recordsets objects which are currently open.
One of these has xx no. of dummy fields . I want to add
column values of the other recordset object in these dummy columns for each row....
