VB Forum / Database Access / December 2003

I don't understand something in Vb6.
I devolope a program that has t do this steps:
1 - Read data from serial port
2 - Display data in a form

Hi, is it possible to do Oracle-like Sequences in Access
and if so, how do I do it?  Thanks.

Hi,
I've created an application that connects to a couple
Oracle databases to run reports.  However, each PC that
runs the software needs to have the Oracle client and the

I'm looking for some VB6 code which will let me upload files (Excel, DB4,
CSV, Access tables, etc.) to SQL Server 2000.  I don't want to use SQL
Server's DTS wizard.  I want to build my own VB app to do this.  Can anyone
help?  It would be greatly appreceated.

Hi , I am trying to insert the OrderID variable into sql2000 however it
refuses to work with the following error.
"Error converting data type varchar to numeric"
 Dim cn As ADODB.Connection, rs As ADODB.Recordset, intColIndex As Long

i'm newbie in VB 6
Dim firstNo As Double
Dim secondNo As Double
firstNo = InputBox("Enter The First Number")

Who know the newsgroup about visualbasic.net

i have a problem when i edit the record(using ado) it do't modified
untill i end the form and again load the form
i use update method.

Hi guys, I was wondering if someone could help me.
I've made a program with VB where it collects data from a MS access file and
displys it on the screen
My question is, is there a way where I can put this program so it works on

i have visual studio 6 installed and office xp installed, trying to connect
an office 2000 database file in visual basic 6, but when i run the
application it says couldnt find installable isam drivers.  can anybody
help?

How to delete the system sound after ENTER Keydown

I have vb application that the database is sql server.
On the vb i have Rich text control. The rich text conrol provide lettes that
i enter on the application or RTF file i load to it by using LoadFile.
What i need is after the loading of the file is storing the data on sql

I'm using Alter Table from VB6 to add fields (columns) to
an Access2000 database.  Alter Table lets you specify the
field name, data type and size, but how do I specify
other field parameters like AllowZeroLength and

and one of them isn't nits thankfully!
this is my first attempt at database programming - I don't have any books
and the tutorials
I've read on the internet don't give you any help when things don't go as

Hi Group,
If ADO control has RecordSource propery equal to an empty string at design
time, an annoying message box appears at run time.  I keep getting "Error in
FROM clause" message.  Why is this?