VB Forum / Database Access / December 2003

Can anybody help me in this case?
I've found an example on MSDN, but it is for C++ and for
an earlyer version of DAO, i guess 'cause it had methods i
did't found in VB for the TableDef object.

------------------------------------
Dim com As ADODB.Command
Dim param As ADODB.Parameter
Dim strIn As ADODB.Stream

I have a project that has three forms,  In one form I used
a ado control to connect the access database to the form
and return values in text boxes from the database.  Works
great.  

to add a date value to an Access table in ADO I put #
around it, #12/16/03#
for SQL Server I put what?
thanks

I have a question.....Just wondering what some people's opinions are on the
subject.
I have a project where each of my combo boxes are data controlled & each
needs an ado recordset for their rowsource property.  I have about 12 of

I have the following SQL string:
SELECT EMPLOYEES.ID, DIVISION.Name AS Division, BUREAU.Name AS Bureau,
EMPLOYEES.Position, EMPLOYEES.FirstName, EMPLOYEES.Name, EMPLOYEES.Title,
EMPLOYEES.PhoneBusiness, EMPLOYEES.TimeRate, EMPLOYEES.ReportsTo,

I am looking for a way to read/write to Sleepycat distribution of
Berkeley DBXML product. I think there exists a c++ interface library,
but I do not know C and does not have compiler.
Anyone tried to use this in a VB6 environment and have help me set it

I sue from access 2000 database in vb aplications.
But vb6 con not open database and sen masage "Unricognized database format".
please help me to this problem.
M.M.J.M

I have a problem with my program, I don't know what it is and I can't seem
to find where it is. If someone would be willing to take a look at it it
would be much appreciated.
The problem is that when I close the form, it is still running in VB I can't

I am still having trouble with this function, I want to take data from a
text boxes and import it in to word, I can call a new document but have
failed to transfer the data, please help
Below is what i got so far. I have tried it different ways and am now

I use a recordset (rs1) to retrieve data from 3 tables in a Oracle db. I
have to use UNION SELECT to retrieve the data. This generates 3 rows in
rs1 - one row from each table. Each row contains ORDERNR and PRICE. I now
want to sum PRICE and GROUP BY ORDERNR.

i have created a software with VB 6.0 and MSDE with reports 8.5, When
distributung the application to Windows 95 systems ( Packaged with Package
and deployment wizard ) it is showing the error Craxddrt failed to Register
followed by Craxdrt failed to register ..Please help me to ...

I am considering converting an application (VB6, SP5) I
have written using Jet 3.51 into using Jet 4.0, to
facilitate deployment.
Can anyone point to a good description of the differences

I wonder if someone could help me with the module below?
I use this moduel to merge data from my client database to MS Word to print
letters and stuff, however when it merges it leaves out all the menues and
icons so you only see the document alone ( the child form), can someone

Hi all..
How do I insert the system date from VB6 to DBF file using SQL?
I tried this and I get Datatype mismatch error.
Can anyone pls advise?