VB Forum / Database Access / December 2006

I have made a program in Visual Basic using an MS Access 97 database using
controls available in Visual basic 5 and 6. Now i'm rewriting my program
using ADO Datacontrol integrated in VB6 Professional. I have this problem:
On my form i have several  txtFields filled with data from ...

I am using disconnected recordsets and binding the recordset to a grid.
I need to insert a record into the recordset to a specific position(row).
How can I achieve this?
-Lou

I'm trying to write a function that gets the results from a SQL query and
returns it as a string. The SQL query will return either 0 or 1 row.
Basically, I'm checking a table for certain codes and swapping it with
another one if there is a match in the table. I've come up with ...

weird thing: -
m = Space(100000)
Get #filenum2, 1, m
Close filenum2

I'm writing vb.net code with MS Access as the database using
OleDbConnection.  The problem I'm having is, I write to the database
then I read back what I just wrote.  The read appears to be from an
older cached version because I get the previous results.  If I read

I have VB6 project working with SQL2000 database. I use ADO.
Is it going to work without any change with the same database attached to
SQL2005?
If NO, then what kind of changes are required to make it work?

Greetings all,
I am curious as to what the best way is to print a report that is created in
MSAccess through a VB applicaiton.  I have looked over some things (like the
Docmd.OpenReport) but haven't tried anything yet.  I just thought I would

I want to create a report with crosstab that connect to an ado.net object
like a type dataste or untyped dataset but it doesn't work,
When I connect the crosstab to on ole db object like a table or a view, it's
work properly and display information, but with ado.net object it ...

I have made some kind of questionnaire by using excel. I made also few
macros in order to read the questionnaire and save it as text file to
my C:\  root. Now I would like to publish the questionnaire in web
browser and I don't konw how to write the path so that it would work.