VB Forum / Database Access / November 2004

Is it possible to use DAO to print a Report in Access.  I expected something
like this:
set d = dao.OpenDataBase (<...>)
set r = d.Reports("MyReport")

 I want to print tickets by retrieving data from the database. It will have
two loops (big loops). First i want to show the print data on the screen coz
each row on the paper contains two tickets.
Once the user sees the o/p on the screen and issues print command once he is

Greetings and thanks for the help!
I am a newbie to ADO and mystified by this:
In MS Access 2003, I am updating some SQL 2k tables via a stored procedure
that updates 4 different tables sequentially.

I am developing a vb.net application that requires a connection to an Access
database. I am developing it on my own PC but will be sending it to a client
who will put it on a server. On my PC, the Access db is located on my C: drive
and it runs fine. But the client wants it on his R ...

How to check whether the field in a record set exists or not/

Is it possible to use ADO (or DAO for that matter) to print a Report in
Access?  I expected something
like this:
set d = OpenDataBase (<...>)

I am using VB.NET 2003 and an OleDBDataAdapter to update an Access DateTime
field.  The problem is the field ends up with only a date, not a date & time.
In my project...
I added an OleDBDataAdapter using the wizzard to my form.  I generated the

I am tyring to figure out the correct SQL statement to use with an
ADODB.Recordset object.
I have a csv file with columns a,b,c,d,e.  I want to find distinct records
based on columns a,b,c.  But I also want to include columns d and e for the

I need to create a small utility whereby I can pass a user name such as
SurName = "John" and LastName = "Doe" and get back his ID :For example
"doej"
Can someone show me a program that will connect and perform this query?

I am trying to perform an updatebatch statement on a recordset that was
originally populated by a stored procedure which included a GROUP BY but I
am unable to do this ?  It works fine with other SP's that dont have a GROUP
BY clause.

I have two programs that are almost identical, including using the
same name for the MDB file.  They are in separate folders and are both
coded to find the MDB file in the application path.  I have been
getting the dreaded "file in use" error only on this program.  Just

I am fairly new to VB programming and not that good at the mo.  Anyway, I
have imported an Access DB as a data source in VB 2005 Express Edition.
That works fine, but when I add new stuff to the DB in Access, the data is
not automatically updated in VB.  What is the best way to ...

I am working on fixing a bug in production code. The code which is changed
is an ActiveX dll written in VB6. The code uses a SQL string which selects *
from a view where a field = thus and such. I have to change the where clause
to AND another field. I also have to add that field to ...

Hello --
I am working on a VB6 project that accesses a SQL Server 2000 database using
Stored Procedures.  I have seen multiple ways ADO can be used when calling a
Stored Procedure, and would like to solicit your knowledge/experience on the

I have designed a routine inVB 6 which opens the data from a FoxPro DBF
file, does some manipulation and saves it in an SQL Database
This work fine on the machine it was designed on but when it was installed
on two oth machines it started to give the following error: -