VB Forum / Database Access / November 2005

I'm trying to create a new DBF file using dbase driver but error is coming
while i run the command that is
   "[Microsoft][ODBC dbase driver] Syntax error in field defination"
I'm using syntax as follows:

I don't seem to grasp the central approach of the data source window.
From this central data-window you drag and drop tables or fields on forms
and/or controls. Dataset, tableadapter and other components are created. The
auto-generated code in the load statement fills the newly ...

   Does any one able to give me an idea on how to programmatically merge
two access database?
Regards
Sanjib

Is there Visual Basic code to rename a column in an existing Microsoft
Access table?
ADO or DAO would work.
We have a field that has a reserved word and would like to use code to

Hi people!
Can anyone help me with this one? Using SQL Server 2000 and VB5,
calling a stored procedure from VB code. When a message occurs like:
Server: Msg 515, Level 16, State 2, Procedure Ve_KarticeIsplate, Line

I am using a recordset to populate a grid. When I sort on a field
(ascending), all empty fields are displayed first. I need to move these
empty fields to the bottom so that the sorted data displays at the top of my
grid. Any ideas?

Hello i use european date format in my system (DD/MM/YYYY), i works
with VB6 sp5 and Access 2002 DB.
I've a strange problem with adodb.parameters
I do, through adodb.command, two insert in a table (be aware, if you

I have a form containing about 80 text boxes. I save the contents of
the textboxes into 3 different tables as follows
Table "Games" - the .Text values
Table "Colors" - the .ForeColor values

Hi, I have an Access backend with a table that holds patient info.  My VB
ASP front-end can "data-bind" just fine to a field that holds a number.
What I want to do is have this field reflect not just the number, but that
number's "sum".  How do I do this?  I tried to add the ...

We trying to convert some SQL scripts in to VB and optimize it to put less
"load" on the server.
The SQL script does something like:
   CREATE TABLE my_table(mID uniqueidentifier,last_run int ....)

Hi people!
Can anyone help me with this one? Using SQL Server 2000 and VB5,
calling a stored procedure from VB code. When a message occurs like:
Server: Msg 515, Level 16, State 2, Procedure Ve_KarticeIsplate, Line

In the code below I’m trying to figure out how to dynamically perform math
functions in a form. To start, I would like to subtract
TxtITotal.Text from TxtPTotal.Text and display the results in
TxtProLoss.Text before sending the data to the database. I have no

I have a VB6 executable that uses SQL Server 2000 as it's database.  I have
a function similar to this (note that goConn is a
global ADO connection object that is already open):
Private Function WriteTrans() As Long

I have several sqltransactions that I start and either Commit or Rollback
under certain conditions after some heavy processing.  Working fine, no
problems.  However, in the case of an unhandled exception, I always need to
make sure my catch statement performs a rollback of any ...

We need help figuring out how to retrieve data from our web site with our
VB6 app.  For example...
We want to (1) send our customer's ID to our web site, (2) have the web
site's database (which points to the SQL Server on our corporate network)