VB Forum / Database Access / May 2005

I have a hierarchical ADO recordset that I persist into a DOMDocument40
object. That's ok. Then I try to access the data node of the document, by
doing:
Set oNData = oDoc.selectSingleNode("xml/rs:data")

Hello, I am new to VB and MySQL connections.
I can use ether VB6 or VB.NET.
I need to make an ODBC connection to MySQL
and then I need to have the VB program poll the table

Can you use stored procedures with a web page? I used Billy Hollis
article on microsoft.com and it showed you how on a form page; not a
web form page. I used his program like a cookbook with my database and
it worked great as a stand alone program.

 I am new to VB, and not to mention, SQL. I am currently trying to
write a small program that I can retrieve some data from a MySQL
database with a given input.
I managed to connect to the MySQL and stuff, and I can retrieve data

I have an interface class like Interface_1 with event and methods like
event1,event2 , M1() , M2
If I implemet this interface in other calss like myClass  ; I can implement
the mothods M1() , M2() only but cannot raise the events  event1,event2

I'm using code like this to update a record in an .MDB file:
rs.seek "=", TheRecordImLookingFor
rs.Edit
rs.Field(7) = SomeValue

Ok image an excel spread sheet, it's not a very complicated sheet..
It has rows, and there are columns... column say B has customers
emails, right now the person who does it, manually pastes each line to
generate an email and sends it and repeats the process for each new row

This is my problem:
I have a stored procedure that:
  1. Executes a sub-procedure to increment a sequence table and
returns a value.

With Access VBA, I open a recordset in a function from a global module. I'd
like to return several things to the calling form, such as record count,
certain FKs, etc.
I can set the value of the function and get one item back. But how do I get

I use code to populate the MSFlexGrid control throughout our program. There
are no bound data controls. I am in a situation where I really need the
MSHFlexGrid control instead and would like to poulate it with code without
binding it to any recordsets. Is this possible? Anyone ...

I need help with a summary on a report footer. I have these fields in an
access database:
Ticket #, Total Lines, Xfer_Order. The field Xfer_Order contains "Transfer",
"Order" and "B-Order".

I am trying to determine when a recordset has more than a single record.
I thought that
 rs.RecordCount
would give me the number of records in the recordset. It wasn't working

I have a tempory database that I upload to our website daily that is a
subset of our master data base that we use inhouse.
Below is where I take the database from the website (Which is previously
downloaded from the website to our local drive) and empty the database.

Hi all..
I have a Stored procedure that opens a cursor. I want to know if there´s way
to access this cursor from VB. I tried using Set rs = cmd.Execute but it
didn´t work, i think because the cursor is not as output return. Below

I'm trying to port all my Access 97 files to Access 2K. However since
the application I'm supporting uses DAO, I was wondering if that's gonna
be an issue? My VB 6 currently uses Microsoft DAO 3.51 Object Library
I've tried it on my own to connect to a Access 2K but ran into some