VB Forum / Database Access / June 2007

Having a bit of trouble with the Parameter.AppendChunk method.  The
test output from the below code is as follows:
Trace: param first byte: 0
Trace: param second byte: 255

I'm trying to build a query to pull some information from my LDAP
based on a user ID.
   Dim conLDAP As ADODB.Connection
   Dim strSQL As String

I use dbase file *.dbf . I want to delete all field name in the dbase file
and only reserve two field name "Plot" and "shape". Any suggestion? or source
code? My dbase file is "Yield.dbf".

Tearing my hair out with this.
I'm getting about 30 odd rows, each having 2 field values, from a db.
1st value is the unique id of the row and 2nd value is the display name, eg:
ID    Name

I'm trying to replace an integer number in a test WHERE string of my SQL
with a variable. See below code snippet.
Works:  "WHERE (((tblEvent.BitID)= 8));"
Does not work: "WHERE (((tblEvent.BitID)= " & BitNum & "));"

Hey guys!
I'm having some issues with one of my installer packages i compiled
with Microsoft Visual Studio 2005. (VB installer is buggy as hell and
wouldn't work on half of our machines no matter what we did with it)

I am starting with what seems like an extremely easy vb program.  I just want
to enter a customer number - connect to as/400 file and return the address to
my form.  I have read and seen alot of connection strings to access 400 files
but I am getting truly confused because ...

how to connect ms access and vb6 using ado jet connection.
i dont know what are the codes to be used...

i'm trying to use database in my application, and i would like not "copy
always" original database in debug folder. So i changed the property setting
"Not copy" but i obtain the error
An attempt to attach an auto-named database for file

Just finished a new version of dhSQLite, wich contains greater
enhancements and is therefore not binary compatible with the
older version 1.1.
The binary size is somewhat larger too: ;-)

' I am getting an error when I try to update the value of Posted to 1.
         Set rsTenders = New ADODB.Recordset
         Set rsTenders.ActiveConnection = Cnxn
         rsTenders.CursorLocation = adUseClient

Hi, All,
   I created a small tool using VB6, in which I needed to insert some data
from Sybase database into an EXCEL file. I use an EXCEL template file with
only one row which will be recognized as each column name when connected

Is it possible to program my VB 6 app so that when a user right-clicks on a
label at run time it brings up a floating menu (is this a contextual one?)
with a list of pre-defined options and when the user selects one of these
options I can then pass the value and label id/hidden ...

I have been looking long and hard for the Visual Basic .NET 2003
Resource Kit CD. I heard somewhere that it might not be available
anymore. Is that true, or does anyone know where I might be able to
find it? I've just started using VB 2003, version 2005 is not an

I'm really out of my depth on this one so your help would be really
appreciated.
I've got to show 7 small graphs on a form and allow the user to print this
data off.