VB Forum / Database Access / February 2005

I am using the ODBC Visual FoxPro Driver in a VB application.  One part of
the app processes a database of approximately 500 records with 74 fields in
each record (each record is approximately 2500 bytes), collects new
information for the fields in an array, and updates each ...

newbie - how to resize column MSFlexGrid
I do not see in properties, maybe I am blind, how to change column width. I
would like to set it to just resize automatically to widest field of the
column, of corse.

I have a client with a rather large vb app that utilizes vb environments. He
wants to move from access to sql BUT he would like to keep access around for
his smaller clients who don't want to upgrade to sql and he doesn't really
want to have 2 versions of his code base.

I have a report written in Access that is now working pretty well and
I would like to include it in the VB application that uses the Access
database that the report is in.
I have used VB to build the tables the report is based on and I would

I'm trying to execute the following SQL statement to get
back a list of user tables from the selected SQL Server database. When I do,
I get an object closed error. What
am I missing here? Please help! This is valid SQL and works

How do you include a variable in a select statement using VB6/Access.
I want to do something like this :
SELECT * from A where A.field = variable
Thanks

I would like to open a addrecord form. In this form I would like teh Field
DebNr to be filled with the value of the field DebNr in my (open) form
FrmStam.
I used the VisualBasic code ;

I am connected to access 2000 from vb6 using ado.
I need when a user enter search criteria that they can just enter the first
letter and the search is not case sensitive. So if the user type "F" then I
want and record with F as first letter in field to be displayed. I thought I

I've got VB4 (32-bit) and it seems to use DAO 3.0. Is there a service pack
for either of these that I can use? I'm having issues with DAO and > 2GB of
RAM on the machine, and don't want to have to move to a newer version of VB
if I can help it, just to fix this problem.

Can I use the value of a bound textbox on an open form, as a criteria in a
query.
If so what would be the correct code for the SQL.
If not how can I hold the required value (number) that is selected by the

Here is a code snipet that produces a "too complex" error message
Set DsgnData = New ADODB.Recordset
sql = "Select * from dsgndata where coilspec = '" & CoilSpec & "'"
With DsgnData

I've created a VB front end to Access 2003 database application.  Everything
works great, but I want to add database maintenace routines to the
application.  Now to do the maintenace routines directly from Access seems
simple enough, built in Access menu choices.  But my question is ...

I am connected to access 2000 from vb6 using ado.
I need when a user enter search criteria that they can just enter the first
letter and the search is not case sensitive. So if the user type "F" then I
want and record with F as first letter in field to be displayed. I thought I

I have the following code:
Set oServer = New SQLDMO.SQLServer
oServer.Connect (Servername), ServerID, ServerPwd
Set oDatabase = oServer("Master")

Hi, I just found the filter on date is based on the computer date settings.
sometime rsRecordSet.Filter = " Date  >=  #11/01/2004# "  return 0 if I
change mycomputer setting to
"English(Canada)" and short date format as "dd/mm/yyyy".