VB Forum / Database Access / August 2005

How can I set the height of a data combo to less than 315? This is the
smallest value I can set height to right now, and it's way to big and
wasteful of space for displaying 8 point text.
I'm using Visual Studio 6.

I got a weird problem (at least it looks weird to me). I'm using VB6 with
ADO 2.7.
When I execute the following 2 queries on a Jet 4.0 database, they are both
updatable:

I have the following query that isn't working right.  I would like it to
return the 5 most recent entries but it actually returns 9 records.
I tried the same query using a different filed and it worked correctly.  
What's gonig on with the date?

I have a big problem getting a recordset via a ODBC connection retrieving
records from a 4th Dimension database with Visual Basic. What ever I tried
nothing seems to work or I get an error. It's possible that the database is
not well setup as I think but there must be a way to ...

We have been using a system with VB6 and Access 2000 on a local machine for
a year.  The vb6 access to the tables was very fast.  This week we moved the
DB to a fastWindows 2003 Server over a 100MBPS Network.
I expected a slowdown due to connecting over a network, but nothing like

A datagrid, dgrCaseSiteInput, could contain as few rows as 1.  Several of
the columns are for entry.
A cmd button successfully executes a stored procedure to update the database
based on those entries.

Is there a way in Visual Basic (VB6) to programatically convert an Access 95
database to Access 2000?
Thanks
John

I have an Access 97 database that I want to use in Visual Basic
(and later be able to distribute an EXE with the file) and have
Visual Studio .Net 2003 Professional, which I have never used
My general understanding is that the Visual Basic part of the

I cannot find a text to explain DAO to me and show good examples.  If I open my database in one form
then go to another form, is the database closed or does it remain open?
I have a situation in which the DB is opened in the first form.  Displaying the second form to input

hi Does anyone know how can i know what kind of data im storing in a specific
recordset field? i´m trying to build a sql statement at run time whith the
data that has been previusly taken for an access database so i need to know
what kind of data i´m trying to insert into the sql ...

  I am working as a Software Engineer on Visual Basic 6.0; I am facing a
problem which is described as underneath:
Suppose I've executed my application by using SQL Server and while my
application is running, SQL Server is shutdown (implicitly or explicitly),

I have an idea where i want my application can choose which database they are
going to insert their data in. So, my question is, how can i do that in my
programming.
As example, let say i've 3 batch of files. 1 batch of files will store in 1

I would like some assistance on a application I am developing in vb.net 2003
that uses a large dataset to query a database.  Most queires are small, and
execute with no problem.  When a large query is executed and stored in the
dataset, I use the garbage collector and the ...

Hi,
I have a connection to a SQL Database but this line of code keeps giving me
errors and I don't know why.  StartDate and endDate are dateTime objects
objCommand.CommandText = "SELECT * FROM TICKETS WHERE daterecordadded

Hi *,
what I try to is linking a oracle table into Access . I use the following
VBA-Code and all I get is the message "Cannot find installable ISAM". I guess
the Provider String could be the reason, maybe someone already had the  same