VB Forum / Database Access / March 2005

Using VB5 and Access 7 database.
Not sure how to describe this problem - but I have 2 text boxes in a
database program - they store a date and the properties in the DB are set as
date/time.

Hi everyone,  I have another question. I'm having a little problem which I'm
stuck at. I'm designing an application which looks up customer information
based on Phone number or Last name. I also have a list box. What I want is
that when the user enters a last name, the list box ...

Vb6/DAO 3.6/Jet 4.0
Has anyone ever seen a case where the recordset.recordcount property is
incorrect with a table-type DAO recordset?
I have. Even after the .MoveLast method is invoked, the .recordcount does

I am using VB 6 and Access97.
I want to create an interface for the end user so that they can use the
pull down menus to create their own queries.
Where I ran into some trouble was CROSSTABS. Is there a web page out

I'm connecting to an Oracle DB.  When a select query returns zero row, the
program will stop and gets an error.  How should I error handle the '0 row
selected' case?  I want to either ignore the error or return a zero value, or
let the user know that there's no such record...  ...

I'm developing an application on my Win2000 system and when
I run it on a target Win98 system running Access 2000 it stops
in a function on the line:
   newStr= str(curRecord)

Hi everybody, I have a Visual Basic application that looks up customer data
from an access database. The access database has a table called Customer with
fields such as Name, Street, Zip...Home Phone, Cell Phone etc. In access I
have allowed some fields to accept duplicate values ...

I am rather new to Visual Basic and have used Access in the past fo
several years.  I am trying to write a Logging program for Amateu
Radio.  I have set up a VB Form and have some 20 or more text boxes o
the form.  I also makde an Access 97 database to place the informatio

I have a VB6 application that updates a SQL Server database.  The program
works fine, but sometimes I receive SQL errors due to bad input or misisng
information.  I'm exeuting a bunch of SP that return various information.
I have an Error Handler in my function and it is trapping ...

Using VB and ADO I would like to open one Access database and copy a
table from it to another Access database.  Is there a simple method for
doing this as opposed to reading in the table record by record from the
first and then writing it to the second record by record?

I am converting a MS Access database to Visual Basic (Just Started Today), I
have run into one problem so far.  I want to access the .MDB databases that
already exist.  I know that I can access the database through VB, but I can't
find any documentation on how to do it (how to ...

Is there a way to import a text.txt file where the data is in the following
format (not a flat file format)?
John Anderson
23 Red Arrow Dr

I have an old application that I wish to modify for use on windows xp. As I
am led to believe by the voices in my head that MDAC 2.8 in Windows XP does
not have a provider for FoxPro. It works on windows 2000, albeit due to the
constant applications of the MDAC du jour. However, in ...

Can anyone tell me who I can list the tables in a schema? I am using the
ADODB.Connection system to create a late binding.
With regards,
Arjan.

I am looking for a way to retrieve the installed database drivers, so I can
use them in a program as an option to chose between different database
systems. I want to use this in combination with a late database binding (e.g.
strCONN = "driver={MySQL ODBC 3.51