VB Forum / Database Access / November 2004

Please forgive my ignorance with the controls in VB, but I am more used to
ASP.
Basically I want to recreate what I can do in ASP (with HTML as well might I
add) in a standard VB combo list.

I know the subject might seem weird, but I really want to use the
base/standard controls of VB as much as possible without having to use
external OCX (?) controls, as I feel it just gets messy the more you add
these in.

Hello, I'm developing a program that will include a window showing current &
previous records using a scrollable recordset. I need to add records to the
recordset & have new records immediately available in the current recordset.
What is the most common way of adding new records. ...

I need to connect to a paradox 5.x table. The data adapter doesn't work
because I only have VB Standard.  How does one connect thru ODBC without the
data adapter control? I tried the following but I just errors out:
       Dim conn As New System.Data.Odbc.OdbcConnection

I am currently using an nvarchar column to store text in an SQL Server
database, but I need to move to ntext.
I am using stored procedures for both reading and writing.
My existing code stopped working when I changed the column datatype, and

I am generating an email from within my VB app. We all use the Outlook 2002
client with the most recent security updates, which means that when an email
is generated outside of Outlook (i.e.  from my program), the user is
presented with a window that tells them that a program ...

As per usual I'm starting a major hobby project (for me anyway) before I can
VB walk!
Although what I have done works, I'm sure it is not the correct way so I
thought I would ask the gurus.

I have a sql statement that I can get to
work as a query in access, but I have forgotten
the syntax i need to change to run it in vb6.
Here is the query. any help is really appreciated..

I am trying to establish a connection in my VB6.0 project using the following
code:
   strCnn = "Provider='Microsoft.Jet.OLEDB.4.0';" & _
       "Data Source='C:\Program Files\Autosort Files\Tracking2002.mdb'"

I can't use the recordcount,absoluteposition & bookmark command. Do anyone
know there are any similar commands for VB6?
The following is my coding:
Dim db As Connection

There is a form in an Access Project (.adp, Access front end with SQL
Server) for entering data into a table for temporary storing. Then, by
clicking a botton, several action stored procedures (update, append) should
be activated in order to transfer data to other tables.

I want to write a vb program for user to export sql server data to excel.
Which command I need to use???
I have already tried the following codes, but error message is shown :
db.Execute ("select * into [excel 5.0;database=c:\a.xls].a from ABC")

I have an Access 2000 DB that includes linked tables from another Access
2000 DB. I need to 'read' data from one of these linked tables.
When I attempt to access the data I am getting an SQl error with Description
as follows...

I have created my database in SQL server, and I am experiencing a problem
with one of my tables. I can't seem to add any more records into that table
(the total stays on 197, it worked fine until recently). whenever l try to
add a new record, it replaces one of the old ones. I ...

I'm looking for a simple proof of concept application that shows a VB6 app
reading a Chinese string from an Access database and displaying it on a form
(in the caption, menu, button, etc.).
Can anyone help out.  I've tried this, but all I get are question marks