VB Forum / Database Access / January 2005

I have a datadase vb6/sqlserver.  On one of the data entry screens there's
a listbox called status.  The items contained in the listbox consist of
O(Open), C(Closed) and R(Recieved). Here is my problem, I need to have a
condition put on 'O(Open)' stating that if Received Qty >= ...

It's me again, with my another newbie question. :-(
My application needs to display invoice/statement to the user for them to
preview and print out. I need to get the next record number (Autonumber ID)
from database and display it on the invoice/statement. Only after the user

I am trying to store 16 digit numbers, like Credit Card or Gift Card
numbers.  Any recommendation on the best data type to use?

Why "Create Table MyTab (asdf-fdsa text)" gave me syntax error in VB while
it is
okie to add a column "asdf-fdsa" in Microsoft Access?
When I need to use some special code to combine two labels to form my column

I want to close a connetion to the database but still be able to use a
forward only cursor recordset.
Is this possible?
Bob

Im putting something together which marries information from Access 2k,
Excel 2k and Oracle 8.1 sources. Using DAO 3.6 I can do all the Excel &
Access stuff but I don't have a clue how to connect to the Oracle database -
I assume I'll be able to query it in a similar manner to ...

VB6 Program doing a Seek (adSeekAfter) with a value that is greater then the
last value in the database does not return EOF when the recordset is opened
in adLockReadOnly, but does when opened in adLockOptimistic.  See relevant
sample code below.  However, if I set a break point ...

I'm trying to combine few tables and then sort using the date field.
The table relation structure looks like one main (parent) table connects to
many other smaller (child) tables, the shape is similar to the network
definition "Star Topology".

hi, I make clone of an existing recordset, when later I make some changes to
the source recordset, is it the clone will get updates automately. Thanks

I have a need to create a math formula in a textbox, then store it in a
database.
How can I pull the formula from the data base and use it for manipulating
data.

I'm trying to combine few tables and then sort using the date field.
The table relation structure looks like one main (parent) table connects to
many other smaller (child) tables, the shape is similar to the network
definition "Star Topology".

I am about to create a vb6 app. front-end to an Access back-end to manage a
library and have the following queries;
Access 97, 2000 or 2002 db?
Use ADO or DAO?

Does anyone know if it's possible to create a view for two different
connections? In other words I want to select a.A, a.B, bC from tables a and
b but tables a and b are from two different connections. Is this even
possible?

I hope I posted this to the newsgroups correctly.
My question is this. I have an access database with a query in it that needs
to be updated. There is a bug in it so we need to write VB code to go out to
the database, find the query if it exists, delete it and create a new one.

I am not sure this is the best place to post this if not please direct me.
I am trying to figure out how I make a report in VB6 with a subtotal for
each user. I have a time clock program and I have a report table that has
all the time for each day. The hours for each day is in the ...