VB Forum / Database Access / March 2006

I am using VB6 SP6. I want through VB Code to determine the login to which
role is member?

I am working on stored procedure and VB.net to handle transaction with SQL
2000 database.
I have 2 tables: orders and order details. I am creating a Order form using
VB.Net

I have a query operating on three tables on a DB based on MS Access
2003.
To mine data I use VB .NET 2003 with OleDbDataReader and ListBox
controls.

I have created a sql string ( a maketable query):
SELECT Man.strStoreNumber, Man.strProposalNumber,  Cubic.LightDutyCubic
, Cubic.HeavyDutyCubic Into temp_tblDataProposal FROM
(chastblDataProposal AS Man LEFT JOIN tblCADSqFootFromTextFile AS SqFt

I am working on a db and I have a form and on this form I have a button that
would perform a Run a SQL script in this SQL script i have a “where” clause
When I click on the button it takes me back to the code and the “where” is
highlighted and I am getting a compile error “Sub or ...

Hi... i am currently working on switching our database from Access to
SQL and while most of the required changes have been taken care of, the
problem which still persisting is:
We have a recordset, the query for which is somewhat like this...

I'm importing a text file into my access db however the text file has the
following rows that I do not want imported
The First 4 rows
Source File Name : CDW - Facility

What connection string should I use??

Could anyone suggest a 3rd party component to open and edit DBF files.  It
would be nice if it would support the cdx index.  We are using Visual Studio
2005.
Thanks,

                                                             OMNI GROUP
                                                       tgugger@sbcglobal.net
                                                              419-537-9447
                                           VB .NET/ ...

I wanted to know how can I get the name of a column I select in
MSflexgrid.
All I can get is the column position.
strColDel = flgDatabase.col

What is this syntax denoting for resultset
rs!name     as opposed to rs.RecordCount

INSERT into [ALIAS] (CID, PFX, DATE_FROM, DATE_TO, DELETED) VALUES ("AA", "BB",
#7/25/1942#, #7/25/1942#, true);
When I paste this into Query designer, Access gives me all sorts of grief; CID and PFX are
required, no default. DATE_FROM is required and has a default value. DATE_TO ...

   Thanks to dougles I'am a lot closer to the finish line.
This is my code:
On Error Resume Next
   Set AccessApp = New Access.Application

i'm using VB6 example code from microsoft that produces a standard exe
project which connects to an mdb file to get the data and connects to an xls
file to write the data (at the end of this post i've included the url of the
microsoft article that has the code).