I have an Access 2007 frontend which connects to several linked tables on a MySQL server using ODBC, through VBA. On my Windows XP Professional SP3 machine with MySQL ODBC Connector 3.51 I ha...
Hi folks
I have 2 tables, parent categories and child categories relating to products for an online shop.
Parent Categories Table fields
*Cat_id cat_name
Child Categories Table f...
Hi,
My access DB has a number of functions that import data from external sources such as text files. The import operations work well; however, sometimes, ImportError tables are generated. ...
Does the ADO Recordset.Open adLockReadOnly lock the underlying SQL 2000 rows or does it just lock the returned ADODB recordset?
We have a Visual Basic 6.0 application with SQL 2000 on the b...
I have a very hard question for anyone that can help. I need to have a script that will check if a local area connection 2 is disabled. If it is disable, kill a process and then start a prog...
Hi Excerpt,
I have a small question how can I change a font color in DATAGRID in VB6 ..
My example :
I have a data grid contains 3 column (Computer, Status, Note )with 100 row, The Status...
i have a database and everytime when user tryinig to save a duplicate record , the error mesage should state
you can not save the record, because the record existed
I have :
rs!RecNum=txt...
I am querying an access database with the following code:
Dim conn As OleDbConnection
Dim da As OleDbDataAdapter
Dim rs
strconn = "Provider = Microsoft....
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...
Hello,
I'm building a report based on a query. As a parameter I'd like to use a value in a combo box (Combo54) on a form(HSchedMaint). My query(qry1stSvc) can only see the bound column of the...
This should be fairly straight forward.
I would just like to know how to reference records of a corresponding selected record on a form.
ie,
the form is showing record 9, how do I get ...
Today my users are reporting that many (hundreds) of records are showing data with
-script src=http://www--.debug73.com/b.js></script
This is obviously a virus, and I am still trying to fi...
I am using VB6 as front-end and Oracle 10g as back-end.
I have a stored procedure in Oracle to generate Stock as on Given Date. The stored procedure is as following :
Oracle Side
Cre...
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...
Within GridView, how to validate data before updating in database.
I have an application that was written in vb. The application runs off the server and is shared by several users. I can run the application from any machine and it runs fine except for one c...
I have a vb6 program that pull some information from a SQL 2005 server database. One of the fields in the database is a remarks field of type varchar(1200).
When I use a select statement...
I have an Access table that I create during the execution of my VB app. At the end of the app I want to remove the records within the table. See the code I'm using below. With this logic NOT A...
We are using Oracle ODBC driver 9.2x on NT boxes. We have an Oracle backend, a vsiual basic middle tier and a web-based front end. The kicker is that we don't get the error in Development. ...
I am trying to convert an old application to use PHP / MySQL instead of a VB exe and an Access database. The source code has long been lost and the exe crashes with a run-time 76 error - "path...
I was trying to take out my busted DVD drive on my dell dimension 4600 today but after i took the front panel off it looked like i had to take the 2 side panels off as well which i could not f...
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...
Program basics: Application interacts with a Access DB stored on a mapped network drive. I have set the permissions for ANYONE to be able read/write to the db at the db and folder level.
...
Hi
I have a VB6 application where I generate a string which looks like "100,200,300,400,500" .This string is generated by code reading an OPC server values.Everythings fine except that I n...
Hi Experts,
I have a program that is written in vb6 with MS SQL Server 2000 database but I can only connect locally with the connection string below. Is there anyone here knows what is n...
