VB Forum / Database Access / February 2004

How can i use « cariler » recordset in my new « cari » recordset?
If I use carisql «select * from " & cariler & "..." » it also fails.
ip = "localhost"
Set oconn = New ADODB.Connection

If Option3.Value = True Then
If IsNumeric(Text1.Text) Then Adodc1.Recordset.Filter = "id like '" &
Text1.Text & "%'"
Text1.Text = ""

I threw the whole lot out after weeks, started all over again only to see this same error crop up again. The current project has ran just fine for days.  I was updating tonight and it poped up the first time. I am using ADO and bound textboxes.  I have extracted the MDAC but can ...

I have a DataGrid on the form.
When the form loads, the Column properties, such as column width, column
visble are defined.
Some columns are visble and some are invisble.

I have some tables containing multi-word columns (such as 'Salesperson Code'
when doing an update as such
rs1.AddNe
rs1.Fields("Salesperson Code") = strTex

I now have my VB6 application reading from and writing to a .mdb (Access 97)
file.  It will update a single field or add a record.  I am NOT using ADODB.
I am using Jet.  Here's my question:
1.  I added two command buttons to the form--One to search for a person by

If an item in the Fields collection is accessed with Square Bracktes(Fields("[Field One]").Value) in DAO 3.6 will cause Access violation Dr.Watson in compile mode. The same code works fine in IDE. This also works fine in DAO 3.5. The sample code that causes the problem is shown ...

I tried to create Query object in Access-2000 MDB file by means of ADO API:
conn - opened ADO.Connection object. I called
conn.Execute("CREATE VIEW v1 AS SELECT f1, f2, f3 FROM t1 ORDER BY f1
DESC;")

Is there a way to copy data directly to a cd drive from vb code
The following works for every drive but a cd
DoCmd.OutputTo acOutputTable, "tblTest", acFormatXLS, "E:\Test.xls", False

I am trying to populate a recordset with information from another table.
Everything works fine except the last item is not getting added.  The
following is the code.  The recordset that I am trying to populate is not a
table but a recordset used to populate line items in a data ...

I am trying to design a button in one form that opens
another form and executed a button method within that form.
I want to button to open a form based on a different table,
then execute the code connected with a cmdNew_Record button

I am looking for a way to use some form of timer that fires an event at a
preset amount of time ie 30 sec or 5 mins.
What i want to do is refresh a data grid with new data added by others on a
network.

I want to physically delete a file in Pocket PC by using MS VB6 which running on PC
Is there any source code given on web site for my reference
Regards
Betty

I want to declare all the data fields and data members of my controls
on a form as the same value. Is there any way in doing this through
code in a few lines? I am really looking for a solution in code?
Thanks

Here's the code example...
Dim myArray() as string
later I will redim the array in a for/next or a Do/While Loop
   x = ubound(myArray) +1    <<< causes error 9 if no elements exist