VB Forum / Database Access / March 2004

I was wondering if you could help me. I am trying to connect to a FoxPro DB
inside Visual Basic with no success, no matter if I try it through a
datagrid connected to a command in dataenvironment (ODBC) or through a
simple Data Control selecting the FoxPro DB manually. In both cases ...

I'm a newbie in VB, so my question might appear to be dumb. If that is the
case, I do appologize those who feel offended.
Here is my question: I want to display data of some chosen fields from
different tables in a same grid. I've try to use DataGrid control, but it

I am trying to create a VB6 app that will use ADO to save, edit and delete a record. This app will use and XML file for the data storage. Has developped such an app before and can illustrate some code that shows how to accomplish this. Can anyone illustrate some code that is used ...

When I select MoveLast  I do not get the last recor
strsql = "SELECT *  FROM TBL_EMP
mors.open strsql ,goconn,ad...

if the holdname contains quotes the find command errors out.
When I set the holdname to:  
       holdname = 6"x10" pumpline
       Set adodata = New Recordset

I have an access 2002 application with a considerable amount of visual
basic for applications behind it.
I would like to recreat the application in visual basic.net.
Is there an easy way to import all the forms and supporting visual

Well my application needs to have a ODBC data source created nefore it can
access the database.
Now this means i have to go to Admin->ODBC and add a dsn manually.
Is there any code with which i can do the same when the application is first

How can i do to create an ODBC data source with VB code?? First, i want the
program to check if the source exists, then, if the sourse does not exsist,
the program will create it...
thanks

I am programming a VB-SQL Server 2K application which connects the clients
to the database through the internet. While I am testing the application
within a LAN in which the database server as well as the client connect to
the internet through a router I can't ensure that the client ...

I need to import the contents of a text file into an access table. The table
has only one field. the entire contents of the line from the text file will
go in the one field. Each row in the text file will be one row in the table.
I can deal with opening the text file and I know what ...

dear friends
I am fiing a query in ms access database
but it is not working fetching the data from database
I want to fetch all rows for those words start with "An" so I am using the

I am displaying data in a datagrid. The data is in a Data Environment,
pointing to an Access database. Everything works fine, for the most part,
but I want to disable certain functions if the table is empty, and re-enable
them when more data is added. However, when I add the first ...

How could I ensure that the access is closed while the Visual Basic is accessing it
Betty

I am new to visual basic, so please bear with my ignorance. I am trying to pull data from a spreadsheet which has a couple of named ranges defined. I altered the excelado code available at microsoft support site to access the data. I am getting a "microsoft jet engine could not ...

I have built a database where a particular item may be priced several
different ways, i.e., by width, by item, by manufacturer, etc. In the long
run, would it be preferable to have separate lookup tables for each pricing
method (, or additional fields for each pricing method in just ...