VB Forum / Database Access / July 2004

sample
Date     Payee  Description   BTR  SAW  ABC              
##/##/## XXXXX  XXXXXXXXXXX   XXX  XXX  XXX
BTR , SAW and ABC is data from Table also

Has anyone every had a bookmark fail to position the record to the
bookmarked record?
Here's the code in question, it is a simple procedure but it is
causing me problems - exploitation after code.

What do i set objType as to give me intellascence such as vbVarChar etc.
Function AddParameter(objValue, objType as ??????, objSize, objDirection As ParameterDirectionEnum, objCommand As Parameter)
   Set objPara = New ADODB.Parameter
   objPara.Value = objValue

Do u know how to export a dataset or datagrid to excel spreadsheet. I
know one method but it uses COM component(through Interop), i want 100%
.net code.

Hi all, I have a weird ADO database speed issue, and I am wondering if
anyone can make a suggestion as to how to go about attacking it.
I have an object which does a bunch of database related work (it does a
select, processes the data, and then does a series of selects based upon ...

How can I copy data from a "X" DB to a "Y" DB using DataSets?

Using VB/ADO I can get binary (Bitmap) data into a field of type "OLE
Object".  But when I open the table, it field says "Long binary data" and
the form's Bound Object Frame doesn't display it as an image.
On the other hand, when I manually copy a BMP file and paste it into the

I wrote a program with vb6 that connects to a access database. It works well
so I compiled it creating the .exe file and I tried it on another computer
(with Win98) where there's not installed Visual Studio. I copy on that
computer some dll and it works until it connects to database ...

Is there an FAQ for databases that I can check out? I'm quite new to
programming databases using vb and I'm having some trouble even getting a
recordset to take on the values in a table from a database in Access,
Ste

Can someone direct me to SIMPLE code to make a DAO connection to a
remote mysql server (by remote I meaning using an a webserver on the
internet)
TIA

I have a form which collects 4 columns of data and writes it to MSAccess
database(MSAccess 2000) using VB6.
I then close this form and re-interrogate this same data in the database to
populate another form.

I am trying to generate a word report which prints a 3-page invoice
for each record in the ado, i.e., a 9-page Word document for a
3-record dataset.  The template comes in as a 3-page .doc file.  The
example in the MS knowledgebase generates one row per record in the

I cannot connect to an instance of SQL server 2000 with my current version on Visual Studio.  Error message sounds like I didn't spend enough money.  Anyone know what I need to do to be able to establish a connection?

I am new to databasing and am confused about dao and ado.
I don't have a clue about what dao or ado are.
I know how relational databases work and the principles that they
operate in but do not know how to use the right tools/code as I need.

Hi there everyone, I am running a website that requires a database that can
be accessed by by clients.
I  normally just write my software in visual basic and then distribute it on
disk but have now discovered how easy it is to write ActiveX conbtrols that