VB Forum / Database Access / July 2004

I am very new to Visual Basic and am wondering if someone can help
advise me of the best way to go about things and help me get some code
working.
I have an Access 2000 database on a server that I want to let the user

  Is it possible to create an Excel file using VB without opening MS Excel
program? Let's say I want to use a standalone VB program to create an excel
file with Cell A1 = "Testing", how can I do that? Thanks in advance.
Dat

POSTED IN
microsoft.public.vb.database.ado  
microsoft.public.vb.database.dao  
microsoft.public.vb.general.discussion

I'm sure this is a simple question, but I am going to ask anyway. In my VB
app I have ADO 2.5 Referenced in the project, but the client has 2.6
installed, will the app use the 2.6 installation or 2.5? Basically I am
wondering if it matters what is referenced in the project or not.

Hello Friends,
I m using vb6 and access 2000 as back end.
One of Access table have around 90,000 records.
I have to use        LIKE  Operator in my query for searching records.

I'm trying to write a very simple VB application that opens a database and
does some queries.  I have my project set up and I've added the following
lines of code:
   Dim dbMyDB As Database

Looking for some help.  Is it possible to create an Excel workbook
using Crystal Reports Plugin Lib that comes with the .NET framework?
I'm working on application that will be running on a server and will
not have MS Office installed on it, so I'm looking for an alternative

I have ready used SQL to sort out the records in a field and display
in datagrid, but I don't know how to sum up all the records in that
field.
Thank you

Hi, I have big problem that can't be resolved by me until this moment.
Would you please do help me?
Okay, to the point...
I created a form. On that form I created a DataGrid, that showing

I'm using VB 6 SP5 and True DBGrid Pro 7.0 and True DBDropDown Pro
7.0.  I'm using two ado controls, one grid, and one dropdown.  The
grid populates with data ok using one ado control.  The second ado
control has the same dsn, datasource, etc as ado control one.  The

Hello, I'm new to VB and Access.  I'm trying to open a report created in
ACCESS from a VB6 front end.  The front end gets the name of the company
for the report as well as the dates "from" and "to" that the records where
entered in the Database. I wan't to be able to see the report ...

I'm writing small dynamic application with an Access database that must
display records.  The database has now 100 colums and 950 rows which are
growing dynamically.
How can I display each column name of a dataset or tabel?  The best way is

Here is the relavent code up to now:
--------------------------------------------------------------------------------
Dim lcSelect As String = "INSERT INTO tempFile SELECT *  FROM stktrn"
       Dim ConnectionString As String = "workstation ID = LITTLERED;"

I am having issues with the visualbasic gramatic for the following scenario:
I am retrieving information from an Access 2000 Database. The current fields
are:
ebay, which is a yes / no, showing as -1 or 0

Im usung VB 6/Access 2000 for my application. Using adox to create table
and fields. I wud like to copy tables from system db to data db. using
columns.append
Problem is:  cat.tables("ABC").column(1).name should return column name;