VB Forum / Database Access / September 2006

I am using vb6 at the moment. I need to assign the rowsource and
listfield of a datalist to a particular column of a filtered recordset
after pressing a command button.  I am having troubles for the datalist
to display the desired data.

(sorry, newbie question)
this is a rephrase of a post "Beginning sql" which may not have been a good
title <g>
If i had a table and wanted a list of all distinct items in Field1 i think

Hi, I'm trying to pull a range of SQL data into an array.  The connection is
made OK, but I would like to put the list into an array or listbox.  Then run
thru the data in a printing program.  What's the best way to do this.  Here
is what I have so far...

Howdy:
I am an experienced VB 6.0 database programmer trying to write first VS 2005
application in VB 2005.  I want to create an end user defined query and pass
it to the program.  Specifically, I want to pass a date range, ie:

A datagrid, a dataset, a bindingSource, a text box. I can see the data rows
in the grid. Question: How to highlight the record found from a search using
the contents of the text box. Should be so simple.

I have encountered an "undebuggable" error on a client's machine. After
many attempts to determine the problem, it seemed as if the program was
hanging on openning an adodb recordset. To be sure that there were no
program bugs, I wrote a testing routine to test all the components I

Trying to learn how to work with recordset via ado vb6
suppose I have a recordset oRs,
oRs has a field "Field1"
10 records where Field1.Value = "a"

I am having a hard time updating a SQLExpress database from a dataset using
"adpFeature.Update(dstFeature, "FeatureTable")"
it fails and tells me:
System.Data.SqlClient.SqlException was unhandled

I am encountering the problem with the mixed types (text and numbers)
in one colmun
(Serial numbers column)
and i need to create a text file from the excel,

Hi, my name is Byron. I am trying to connect  to access using this
code:
Private Sub cmdVerFoto_Click()
On Error GoTo Err_Handler

I'm writting in vb6
Dim oCat 'As ADOX.Catalog
Dim oTable 'As ADOX.Table
Set oCat = CreateObject("ADOX.Catalog")

I'm trying to use VB6 to print out the reports that I have written in
Access, but somehow it doesn't work.. it was working before.. it said
user defined type not defined for the line
Dim appAccess As New Access.Application

I'm trying to modify a VB 6 project that I have not touched in 5 years
and am having a problem I can't seem to fix.  This program works with
MS access files that we access using code like:
Dim nConn As New ADODB.Connection

I'm using VB 4.0 and DAO 3.51 and am trying to use a database created
with Access 2000. When I try to open the database I get the error
'Run-time error 3343' unrecognized database format
The filename I'm using is correct and is a valid Access database. Any

Hi to all,
I using the English language for Access.
In a Message Box with vbYestNo, I changed the message text to French, the
Yes , No buttons are in English.