VB Forum / Database Access / October 2004

hello myself avinash
i am developing on application having vb 6 as front end and sql server 7
as back end.
when i use insert query to insert data in table then the date value of

Can anyone help?
I am using VB6 and ADO. I want to open a database through the Open command
and create a REcordset based on specific records linked to names. Some names
have an apostrophe eg. O'DEA. When I enter this name in the WHERE  clause of

I currently use Visual  Basic 6 and the only way I can link to an access
database is if its created using either Visdata or Access 97. Is there a
patch/add in that will allow Visual Basic 6 to recognise the 2002/03 versions
of Access?

I have had to modify a VB5 system written years ago.
I haven't touched the stuff this century
I need to read a csv file into a database.
Is there an easy way to do this

We have several customers running a VB6 program that uses Access 97. We have
rewritten the program to utilize an Access 2000 database. We are searching
for a convenient meathod to convert existing databases (97) to 2000 without
requiring the user to use Access itsself. Thanks for ...

Hi, I'm a little confused about how to go about this.  What I have is an
 Access database with some local Access tables and also some linked
tables (to an SQL Server database).  When I open the Access database
from VB6 I normally just use OpenDatabase and pass it the full ...

In my VB6 App, I create a Data Environmente (DE) in Designers on Project
Window.
On that DE, I create a Connection. In Connection Properties Window, it asks
me for a server to connect with. DE activates automatically when App starts.

I defined an adoRS.Source using a simple SQL-statement. However it doesn't
work. Where do I go wrong?
Tablename = "MUZIEK"
FIELD1 = "TITEL"

I have a disconnected recordset and I need to check if there are dupliacated
values in one field.  Does anyone have a way to do this quickly.  I have a
routine that will work, but it takes a long time.  I was trying to do a
group by query on the recordset with a count field and ...

I am trying to set the rowsource property of a datacombo to an ADO Recordset
but I always get a 438 binding error. When I loop through the code the
recordset does contain values. Can someone suggest what I am doing wrong?
adoLkpGender.Open "SELECT GenderID, GenderName FROM ...

i need to figure out how to take an image file (i will have the local
path to the image) and load this in an adodb.stream so that i can then
make a soap call using xmlhttp (i think) to pass this *binary* image to
a .net web service. does anyone have a sample of the code necessary to

On a value returned from an ADODB.Recordset (within Visio 2003's VBA editor),
how do I check to see if the value is a null?  I thought it was
IsDBNull(rs.Fields(0)), but IsDBNull doesn't seem to be defined.

I need to multiple two colums and in a third one appear the result.
example:
one column is quantity and the other is price... i nedd to multiply those
two colums and in another colum named total appear the result....

I need to know how to Copy a record from one database to another. I'm
usings two forms, in the first I have a database acting like a inovice and
the other one is the inventory. I need to copy an item from the inventory
to the invoice and the item added to the invoice get deleted ...

Hi,
I need to copy a table from one access mdb to another. Is there a quick and
easy way to do this in code? I need to drop the existing tables from the
target db and replace them with the new ones. The really important part is to