VB Forum / Database Access / July 2005

I'm doing an application for catalogue management and I have a form
where I show the users the result of the research. For example, if I
search for a catalogue number 3, it will show me in more detail what
the catalogue 3 have and a small picture of the catalogue. My problem

I remember sometimes before I had opportunity in RDO and SQL server create
in VB environment query and use them later. Now I work in ADO with ms
access. Is it possible to create query for future use?

How can i create connection to excel worksheet and read data from it?

I have an application written in VB6, using Access 2000 and the Data control
and DBGrids that I have been tasked with maintaining. The application is
supposed to allow the user to change the database it is using at runtime.
All the data controls are using the Recordset property ...

I posted this in the misc group but got no hits, thought I'd try here.
In a simple budgeting application we need a replica of an income
statement as a main form.  Default data for the income statement is
written to a temp table based on some criteria in another form.  The

I am opening up a connection to an MS-Access database this way
With cn
   .Provider = "Microsoft.Jet.oledb.4.0"
   .ConnectionString = strfile

I have a problem: A class returning an ADODB.Recordset in an
ActiveX-DLL works fine. If I convert the DLL to an ActiveX-EXE server
then the recordset behaves extrange. Any help will be welcome. Here is
the situation (it seems long but in fact is very short, so, I encourage

I'm still learning about VB 6 and AO
In MS Access 2000 in order to add a new row or update an existing row you
performed the folowing
Add a Row

Does anyone know how to refer to fields for a recordset by their position
rather than their name?  I have a recordset I set up using the following:
   Dim MyRS As ADODB.Recordset
   Set MyRS = New ADODB.Recordset

I'm connecting to a 3rd party Paradox database on the local computer.
The database is being accessed by another program all the time, and my own
programs can also connect to the database at the same time without any
problem.

I am new to VB6 and seem to keep running into problems  ... can someone
please help
I keep geting a "SYNTAX ERROR IN FROM CLAUSE" message when I try to access a
MS Access Database from VB6

Can anyone tell me ho to connectto DB2 with
VB for application (for word), allso how to execute sql statements (retreve
data).
If anyone knows a link to a page that explanes, be very gratefull.

Is there a simple way that I can print an entire table from my access
database ?
A print preview would be cool.
Any help is greatly appreciated.  Thanks

I have the following SQL Server udf:
create function dbo.udfIsExistingUser (@UserNodeId int = NULL)
returns char(1)
as

Hello, I am by no means a SQL expert and I have a class that has about 60
properties and I need to insert (or update) the data in my SQL database.
I am using the SQL Client instead of ADO.NET (if that helps any)
I have a class called PROVIDERS (the 's' is important)  which contains ...