VB6 to manipulate Access2003.
I need to add new record to the table.
I don't think I need to lock anything because it's just adding new record.
If I use ADODB.Recordset object (AddNew and U...
please help ...could you give me the code for displaying data in a flexgrid using vb 6
i'm using adodb connection
Okay I figured out how to run an Access query from within VB.
But when I use the Access object to import the CSV file the query errors out :
"The MS Jet engine cannot find the imput table ...
Hi everyone,
I have produced a report manager application with vb6.0 and crystal reports 7.0. I can print from the application through the preview window which appears when i run a report. I ...
Hi,
I am supporting a visual basic 6 application that connects to an Oracle database and calls a stored procedure to retrieve a set of records to process. The application retrieves the rec...
How do I copy a variable to the clipboard in vbscripting?
I can't tried
Clipboard.SetText vdata
SendKeyData "^v", True
But I get an error message 'object clipboard required'
Hello experts,
please i am having a problem in fetching records in Data Grid from recordst Rs of type Adodb.recordset.
at run time i am executing a Query, using
Rs.Open "Select Ename, Sal...
I currently have a form that has fields, plus a mshflexgrid using VB 6. The fields are controlled by one ado recordsource and the mshflexgrid has another ado recordsource that is based on curr...
I'm pulling in a list of filenames into a database using ado.
My insert statement appears like this:
INSERT INTO Table1 VALUES ('xxx','xxxxx','This is the stupid string with a & in it')
...
I have the following SQL query in VB6 connected to an access 97 DB
Adodc1.RecordSource = "SELECT * FROM CompanySearch WHERE CAExpiry < # " & Format(Now + 60, "dd/mm/yyyy") & " # and ReportD...
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 am using the code below to export a recordset to a csv file. It works but there are a few problems. Firstly, I would like to do the export without using of excel if possible. Secondly, the...
Error message:
System.Data.SqlClient.SqlException : Incorrect syntax near 's'.
Unclosed quotation mark after the character string ''.
at System.Data.SqlClient.SqlConnection.OnError(SqlE...
After agreeing to license during service pack install, the install immediately fails with no error other than "Visual Studio 6.0 Service Pack 6 Setup was not completed successfully""
I need to get a recorset from Oracle into one and only one cell in Excel. This will show a count of the top 5 incidents
Field 1 Field 2
Blackberry 5
Outlook ...
Hi Gurus
I need to know how to copy the structure of a given table in db_SOURCE to db_DEST. Structure needs to include essential aspects such as field names, field type, field properties a...
Hi All:
I am making use of ADODB connection in VB to fetch data from a table in the Oracle database. I need to export this recordset to a csv or excel file.
Code:
Dim rs As New ADODB.Recor...
I am using Visual Basic 6.
I would like to know if anyone can tell me which is faster and/or more efficient when adding a new record to a table from another data source.
The Database is...
How to Calculate and Print Page Total in Crystal Reports.
I am using MS Access Database for the Crytal Report.
And also Please send the information, how to make dynamic crystal report using S...
Hello guys,
I needed help to change the crystal report datasource at runtime in vb. I have tried the crystalreport1.datasource=
App.Path & "\db\ois_ecom_payroll.mdb"...
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...
I had a system OS crash of my Vista and needed to reinstall all my software packages including Visual Studio. After successfully reinstalling my Visual Studio 2005 and SP1 I retrieved my backu...
Dear all,
Any one have sample VB code for a simple "sale, inventory, reorder..". such a program can be use in small sale stall for daily and monthly sale and stock check.
Please advise!
...
Hi All,
im not sure of the best way to do the following. I have a VBA routine that cycles through a recordset and generates an invoice. At present on each loop of the recordset a new invoi...
I a trying to put shortcuts on allusers desktop via a VBScript. I am launching this script from a GPO User Configuration\Administrative Templates\System\Logon\Run these programs at user logon...
