VB Forum / Database Access / December 2003

Hey all,
I found a Web page that shows different ADO connections
(e.g. to Oracle, Lotus Notes, AS/400, etc.) via an ASP
page. I know that a lot of MS technology is duplicated -

I am creating a program to distribute numbers to the user in order to
eliminate numeric conflicts i am using the DB to validate the number
before distributing it.  I pick the next number in the DB not used,
then try to insert it.  if it inserts, i return the #, if not, i want

I have a question about database design, the detail as following,
One sale order record contain below attributes,
1. sale no
2. customer no

Thnx.

I'm using Access 2000, VB6 SP3.
I have code that has been working for years where I can:
Dim qd As QueryDef, db As Database
Set db = OpenDatabase("abc.mdb")

I have the following code where I am trying to retrieve a set of records
based on a couple of criteria:
Set objConnLookup = Application.GetNewConnection
Set objCmdAccLookup = CreateObject("ADODB.Command")

I cannot get the date set in Access if it is a blank value
(null).
Does anyone have a sample of how to do this (please don't
reply with setting the date to 1/1/1900).  I need to clear

We have VB6/ADO/ACCESS apps. We distribute them using an
Installshield setup that includes MDAC 2.5 SP2 - because
it includes the JET components.  Is this still a good way
to go for XP installations?  This scheme worked well for

here is my problem. when adding new record on the form
using adodc component, i can get the values of the fields
where users are entering data with the
adodc1_FieldChangeComplete event but i don't know how to

Does anyone know how to make changes in M'soft Access database's general format column ??
Cos i just wan to use the property to set the Date to 'medium date' and % column as Percentage with  "%" symbol.
Your helps will be appreciated .
daniel.

I'm using an SQL database and i open some tables in
MsAccess through ODBC.
I have a problem with all the tables containing decimal
fields, i cant see the ',' character in it.

I have been trying to find a solution to the following problem for 3
days now. I've searched the net, forms, google.group & looked at
books. But I don't have a solution yet. Any helpful suggestions is
appreciated.

I recently purchased Murach's Visual Basic 6 book so that I can get some
good examples of writing a real database driven ADO application.  Half of
the book is geared towards using ADO bound controls and the other half for
ADO unbound controls.  There are a few chapters on ...

in vb6 this event return the value of field changed by
the user.
=======================================================
Private Sub Adodc1_WillChangeField(ByVal cFields As Long,