VB Forum / Database Access / November 2003

can anyone tell me what is the correct End Type early-bound code.
thanks

h
i wanna know how can i creat a table in my program using ADO
please tell me what the script is
thanks a lot.

I am having problems creating a suitable query for the following situation:
I have 3 tables
Photos table:    PhotoId + others
Tags table:        TagId + others

Hi Ppl,
Could someone Help a newbie?
I keep getting:
'Convert' is not a memeber of 'string'

can anyone tell me what is the correct End Type early-bound code.
thanks

First time to use crystal ocx,  The idea was i would do my query in vb6,
build a sequential(.txt) file from the manipulated data and then pass
that to crystal report.
I set up the .ttx file to define the fields, the other parts of the

I use the option adAsyncExecute on the execute method on
the connection. I execute 2 procs, 1 INSERT in a temporary
table and the 2nd is a select on the temp table. My code
works on windows 2000 and not on windows XP !! Any idea ?!

I have table1 in SQl which has project number,
phasenumber, deptnumber, Hours, rate. The hours are
different for each phase and each deptnumber and for each
project. The rate is different for each phase and same for

i am retrieving data from either an Oracle or MSSQL Server (may
change). Someone decided to store Date-values in a char(8) field with
the syntax "yyyymmdd"
now i want  to use the data in a grid and make use of some handy input

I am running a db.Execute 'Update' command that is updating some details in my application. The field being updated is the note field which just records notes for transactions created.... type string
my problem is when updating the notes if i add an abbreviated date year e.g '02 ...

Hi, friends,
I have a store procedure in SQL Server. It may return a
records for differnt fields based on input values each
time. So, I need to check if certain field,

Hello, i'm new around here, i've been programming VB6 for less than a
year now.
I'm having a problem "populating" this VB report i'm working on.  The
report is dynamic, and uses unbound text fields for the detail section.

From VB connecting to SQL Server by ADO passing a select
query:
SELECT ltxText from tblLanguageText where ltxLangcode
= 'ENG'  and ltxAttribute = '1000' and ltxControlType

How do you programmatcally change a MDB file's password
with ADO?
Someone suggested with Jet.CompactDatabase, but is there
another way, out MDB files are way to big and take to long

   The Connection object connection string I used in VB 6 gives an ODBC error in VB.Net.  Does anyone know the ADO (not ADO.Net) connection string for an Access 2000 database that works with VB.Net?  I have ADO 2.7 installed (MDAC 2.7).
Doesn't work:
"Driver={Microsoft Access ...