I'm been working on an application where I use several tables from several databases. I have to link and query these disconnected tables to report certain data from it. I've read about DATAS...
HI there
I'm doing a VB6 project that needs to show data in some kind of grid where each item can have subitems like a tree view, and the subitems are different "record" types. Can anyone ...
How can I import my database-relations in dataset-relations.
Now I typ them in as follows :
dim ds as new dataset
...
ds.relations.add("Order_detail", ds.tables("Order".colums("sernr"), ds...
Hi there,
I have SQL Server 2000 installed with collation Modern Spanish.
I have a table with the customer "López". When I perform a search, for example:
str="select * from Customers wh...
I'm getting a ADO Time out error, when i run this query from VB using ADO but the same time takes about 13seconds to run in Query analyzer. Remember that i did set the cmd timeout to Zero. Che...
I need to add a column to an existing table, this is a dbf table. I'm using vb6. To create the new column I'm using the code below. And this works. I just need a way to see if the column e...
I am using VB6.
I am trying to give the user the ability to choose the records that Crystal will print.
E.G SELECT * FROM Mydatabase where TransDate > 12/12/98
I will like to have the u...
This is an explanation of how to programmatically navigate a dataset when there are multiple related tables, and how to apply filtering and sorting that will be applied when you retrieve the c...
Using VB 6, trying to update Access Database field with current date. Current code is as floows with current date hard coded:
rst!UDF8 = "07/17/2008"
rst.Update
I have a Table in MS Access (Didpost) that has about 100,000 Records. In this Table, there are 'some' occasions where certain records may contain some fields that match these same fields but ...
I want to extract data from an Access 2002 database to an Excel 2002/2003 Spreadsheet from my Visual Basic 6 Program.
Here's what I have been trying to do:
Dim xlsApp As...
I have developed a program in VB6 connecting to an SQL server using ADO and the OLEDB provider. Now I want connect to a mySQL server. The only option next to using ODBC is by my knowledge mySQ...
I am trying to copy a table between databases. The origin database is an Access .mdb fe/be setup with multiple backend .mdbs to accomodate rapid table growth. the target db is an .mdb that h...
Hi
I have anumber of txtboxs which I am retrieving data from my access 2007 database and cannot format the txt boxs to show the £ currency sign, any ideas.
Thanks
Andy
What is the difference between opening a recordset with adOpenDynamic vs. adOpenKeyset? Thanks!
how to add, edit and delete records in Flex Grid and how to update the database through flex grid with using datacontrol and without using datacontrol.
i have this sub that tries to put some data in a tmp table "TmpStd_grades"
but few times in the loop i get this error:
[Microsoft][ODBC Microsoft Access Driver] Could not update; currentl...
Hi Everyone-
I have found some code that has helped me add records to an Access (2003)
table. I am having difficulty though finding a way to tell the VBA to either
Update/Append or add...
If I open an Access Database and run a query i get ODBC call failed. if i delete the linked tables and add link, ODBC choose the tables and tick save password. it asks me which fields to choos...
hi i used the coding to open the mysql connection
Dim DBmysql As ADODB.Connection
Dim usr As ADODB.Recordset
Set DBmysql = New ADODB.Connection
DBmysql.Co...
Hi experts,
I need to open, edit, save and close an existing MS Excel 2003 file using MS Excel worksheet object from within Visual Basic 6.0 (not explicitly invoking MS Excel itself).
Cou...
All of a sudden when developing on my XP Pro machine using InterDev I get a "Provider cannot be found. It may not be properly installed. " error when utilizing SQL.
All of a sudden.
The ...
High ,
I have a DataGrid (DataGrid1) connected to a Adodc (Adodc1) as the data source.
And I have some button for manipulating the field (Add, Delete, Update).
' --- Set the DataGrid1 a...
Hi,
any ideas ?
I have tried to get an information about
affected rows by an SQL Statement.
Dim lngRowsAffected As Long
If cnS44B6573.State = 1 Then
cnS44B6573.Execute str...
My development machine has VB6 SP6, XP Pro SP2, MDAC 2.81, Jet 4.0 SP8
I've developed a fairly simple frontend desktop application in Visual Basic 6. It interacts with a MS Access datab...
