VB Forum / Database Access / February 2004

how to get the caption of a field  (access mdb) in  vb6,no field name!
any suggest?

I'm using a DataGrid control linked to an ADO database. It connects and
displays the information, but the DataGrid seems to automatically put focus
and clear the data in the first field of the first record, which is causing
problems with refreshing / updating and creating error ...

i'm having problems inserting a new row in a sql-database
one of the columns has a name with 2 words, causing
the ADODB.Recordset.update to fail because
space appaerently cannot be used...

This is a very simple question, but my help file doesn't work and I get TOO
MANY hits by searching on Google.
It's been a while since my VB course at school and I forgot how to simply
open a form.  For example, if I have a command on the main form that I want

Any help greatly appreciated!
I've seen other messages regarding this and have tried the suggestions
but to no avail (setting both the recordset and command object's
ActiveConnection's to nothing for example).  As usual, all other

Hi, I have a vb application that used to use access97 database via
dao. I upgraded the database to 2000 and on systems with vb6fr.dll
installed it no longer works. I am aware of a msdn article that
recommends renaming the old version of vb6fr.dll(in this case

I have a SQL statement:
deSVLG.rscmdIGArpt.Open "SELECT Address, City, FirstName,  IGADate, IGAFee,
LastName, MemberNo, StateZip,  Remarks  FROM SvlgMain WHERE MemberNo >=  (
MemNo)

As title, Does Dao 3.61 supports binary data operation?
Green Xiar

How can I use Date/Time in SQL query in Access database for filtering
records from .mdb with column datetime definition.
like this.
.Fields.Append .CreateField("ParDate", dbDate)

I'm trying to make a DataReport show or hide a column.
(The DataReport is drChartOfAccounts)
Here's the code:
Sub ReportChartOfAccounts(bBegBals As Boolean)

My VB6 application has evolved, and I now find that I need an additional field in one of the tables in the Access databases that store data.  I do not want the users to have to open the databases in Access, and add the field manually.  I need a method whereby I can, after I check ...

So here is the problem.  I've been asked to write a very
simple service for windows NT.  All I have to do is
execute a list of queries from a database, which in turn
updates other databases.

How can I use Date/Time in SQL query in Access database for filtering
records from .mdb with column datetime definition.
like this.
.Fields.Append .CreateField("ParDate", dbDate)

What's the best program to use to print a database schema with 70 tables
(showing relationships)?

I want to fetch a recordset with 10 most selled items, but I find no info
about this subject...
How do I start ?
TIA