VB Forum / Database Access / November 2005

I have a small problem that I wish to overcome, but I can't find a way.
VB6 SP 5, Jet 4.0
I populate a recordset from a function thus:
Set rsgeneric = SomeClass.SomeFunction(A_variable, Another_Variable)

In our VB6 application, we are in need to connect a server by establishing
FTP connection. For this, we have FTPClinet control OCX and able to connect
successfully.
Our the current requirement is to trap connection errors and to display them

I'm pretty sure I did this in projects many years ago,
but I can't figure it out now, nor have I been able to
find anything about it in help files or Google:
Say that I have a Sales database in which I have

Dear colleagues,
    Is there any way to filter ADO Recordest using criteria "[SomeColumn]
NOT LIKE 'SomeExpresion'". I don't mean "NOT LIKE" criteria within SQL
statement used in Recordset.Open(that's work correctly), but in context

Using the code below I am getting info from the rstProgressData
recordset i.e field type, size etc and populating this info into a new
recordset rstDest
I would also like to know if the field allows nulls or not but dont

Normally, I don't cross post between different news groups. I thought I
would get some answers from languages.vb and dotnet.xml newsgroup. But so
far haven't got any reply so I am posting it to this group. In case any one
happens to know the answer I am looking for, I would ...

Hi, I try to protect a piece of Sofware for each user different. Is someone
here who is familier with MD5
cryt and encryt ? Is it possible to use similier or same functionality in
Visual Basic 6.0 and how ? Thanks for help.

I want to use sqlconnection component, which library do I need ?

Please help!
I'm trying to export data from MS SQL in Visual Basic project.
Is there any similar command as in MS Access - DoCmd.TransferSpreadsheet -
that can do the action to export to Excel spreadsheet? Or any method can be

  Is it possible to set "Allow Zero Length" and Indexed property in a
"CREATE TABLE" command when creating a table in the MS Access database?
           tabCmd = New OleDbCommand(GetCreateString(datatable), dbConn)
           tabCmd.ExecuteNonQuery()

I have a program in VB, which was made 6 years ago. It uses SQLConnectAPI to
connect oracle database. If any error occurs in executing SQLConnectAPI, then
SQLError traps the error message and is displayed using message box.
If I give invalid login data initially it produces ...

Hi, I am simply trying to align or "justify center" my webforms text fields
and
labels.
I see no property that addresses this.  Am I just not seeing it?

I have written a VB application that creates a database (.mdb), then creates
several tables each with several fields of varying types (text, integer etc.)
and a primary index.  Then loads the tables from our internet access log
file.  This works just fine.

I am trying to use data adapters in 2005 the same way I did in 2003.  Several
things no longer seem to work.  I can no longer drag a table from server
explorer to a component.   It just blinks and no dataadapter or connection is
created.  I try to create the adpater just using ...

We have thousands of records in an access database table and are
wondering what's the preferred method to find if a record exits. One
column has unqiue values. We want to see if a specific value exits.
Can some please email us some suggested code.