VB Forum / Database Access / May 2005

I'm new to all this XML stuff. Not new to VB6!
Been searching online for example. I've seen some files using WinHTTP, and
others using DOMDocuments (via the MS XML library)
Since I'm learning, I'd like to just focus on one.

I'm having trouble exporting or converting an ADO recordset to a comma
separated (CSV) file.  Does anyone have any sample code that works?

hi all, i am a newbie in all these Access and VBA. i have a databas
using Access 2003, i can write a SQL statement no problems at all. bu
trying to use a Form to modiy/create a query and that i just havn't
clue where to start from!

Private Sub Command2_Click()
If Text1.Text <> " " Then
If MsgBox("Vuoi cancellare la chiamata?", vbYesNo + vbDefaultButton2) =
vbYes Then

I'm new to Visual Basic .Net and I'm using it to develope a scheduling
application.I have a table say "Stage Two" which has fields WO#, Cus , Date,
AG#(This is the primary key for this table). I have another table "USER
ENTRY" WHICH HAS FIELDS ID, WO#, cUS, dATE, AG#(This is the ...

I get this error message when I try to get data from an Access 2000
database: Syntax error in From clause.
This is the provider I'm using:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and

I use ADO. this code is writen by me:
ADOConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\file.xls;Extended Properties=Excel 8.0"
ADOConnection1.Connected= True

I am a novice at ADO and mainly using someone else's code. I am trying to
display a name via the code posted here. I have my recordset. Now how do I
assign the values in the record to PName? I know how to do the syntax in
general. But I'm not sure how to use the recordset. For ...

Currently getting the error ....
               Couldn't find installable ISAM
Trying to develop some code to open a dBase IV database using a Data
Object.  This worked in Win98, but not on a Win2K machine.

Can someone recommend an excellent text for a beginner in DAO?  The texts that I have seem to skim
over what I believe may be my problem.  I am using VB6 SP6 with XP home edition SP2.
I have a program that works on both my PCs, a copy given to a friend results in problems.  My old ...

I am opening a connection to a database and getting records into a
DataSet using the fill method of a OleDbDataAdapter. For many records,
this takes a long time, and I would like to display a progress bar
showing the number of records retrieved as a percentage of the total.

I ran into the automation error in VB when I tried executing my DLL.
I instantiated the DLL:
Public withevents objLogin as cLogin.Login
Set objLogin = new login

I can not find anything equivalent to the connection wizard for Oledb that is
in .NET 2003.  I could navigate to an ACCESS .mdb file and a connection with
string was generated.
With 2005 Express, when I right click on the connection icon, I get a dialog

I have a Access 2002 database with reports.
I am forming a query dynamically in my VB front end with 'where' condition,
and opening an access report using Docmd.openreport command.
For example:Acc.DoCmd.OpenReport "AllAssociationsOfAPersonAsOnDate",

I am creating a system that runs on SQL 2000 at the office but the agents
will have a copy of the database running through MSDE on their laptops.
I need to be able to transfer the data between the two, the process would be
as follows