VB Forum / Database Access / January 2005

Has anyone had any experience with VistaDB? Their website makes the product
look VERY good!
www.vistadb.net
--

How do you create an order form in VB6 that is connected to a database
whereby multiple lines of the order can be displayed and manipulated
individually?

I'm a newbie, with a problem.
I've created a VB6 front-end for a Access database.
When I perform an SQL query for a Report in VB6, I want to be able to
block or stop a field (I.e. a date)

I have to produce a stock management system using MySQL and VB 6 by
Thursday and at the moment I have got no where. Can anyone help as I
cannot get it to display multiple lines of an order and allow each one
to be manipulated separately; also I am trying to get it to look like

Hi, I want to change the Change Caption & Data Type after opening a database
in VB6.  Is this possible or must I use something else like DAO?
TIA!

hello myself avi developing application in vb and access
i want to fomrat the fields in select statement i.e i want to control
digits after decimal pt. in select statement.
plwase read following e.g. carefully and help me.

Is there a way to sort the stored procedures added to the dataenvironment?  
I'm working with a project where there are over 100 stored procedures being
used in the dataenvironment.  When changes are required I have to look
through the list of stored procedures to find the one I'm ...

Hi, how to ensure the following activities is locked:
Dim stock as integer
Dim rs as adodb.recordset
set rs = new adodb.recordset

I'm using an ADO database and a datagrid control which shows a series of
data (several fields
and records)
But I have a strange problem which I cant seem to fix.. Everytime the query

I have a Datalist bound to an ADO control and it fills just fine. But
I also have 3 textboxes on the same form that I want to fill from
other column's in the db record when someone clicks on the record name
in the Datalist control. Could someone point me in the right direction

I am at my almost wits end trying to work out what is going on with a
SQL server Stored Procedure, that works perfectly well in SQL
Server(returns expected value executed in query analyzer) but gives me
an empty recordset and all sorts of headaches when executed from VB.

I have a question about the use of the seek statement.
I have a table with an index that spans two fields. I open this
recordset as
a table and then I have this seek statement:

I have decided to experiment a bit with MySQL and am attempting to connect
an ado data control to a MySQL database.  I setup the MySQL DB as a system
DSN.  When I attempt to set the record source of the ADO control, I am told
that access is denied and the message suggests that the ...

I'm using an ADO database and a datagrid control which shows a series of
data (several fields
and records)
But I have a strange problem which I cant seem to fix.. Everytime the query

I have 2 Visual Basic Projects with the same line of code, (Dim wrkJet As
Workspace) however, one project works fine and the other produces a
"user-defined type not defined" error.
I know that the good project includes the following line: