VB Forum / Database Access / June 2004

How do I indirectly reference a cell in another worksheet in the same
workbook using the Row() & Column() functions.. Every variation of any
formula I have tried results in a formula error.
Thanks

I am trying to get a list of table that are in my database using code
at runtime. I am able to get the list but i am getting more than just
the tables.
Here is the code i am using:

I have a query in an Access 97 DB that calls a user defined function,
MakeManifNum, to update a field.  The query works fine if I run it from
within Access, but if I try to run the query from VB, I get the following
error message:

Does anyone know how I can create a copy of an ADO recordset that is independant of the original data? This is so that I can move the record pointers independently on each ADO recordset.
Hope this is clear.
TIA
Dwight

Hello, hope someone can help with this.
I have a vb6 application that accesses a access 97 database.  I have a form that has a combo box and datagrid and I use the adodc control (recordset).  Everything works fine when I run the applicatiion but when I compile it and install on a ...

I need to know if an object (recordset) is set?  I have the procedure below
that call to close recordsets. Occasionally, it ends up getting called when
the recordset has not been set and this generates an error.
Sub CloseandClearRS(MyRS As Recordset)

For the last couple dozen years the company I work for has made products that were available in (on average) about 10 individual colors.  Now we are creating products that are available in up to about 5 or so combined colors.
The database we have been using has a "Color" field ...

I can enter in a form in VB5 and export to an Excel Workbook, i'm creating a
'Quote' form to post to clients ordering parts. I wish to keep adding using
Offset but have not worked out code to determine if Excel is still running
or the worksheet is open. Everytime I ADD to the ...

I'm trying to load two tables in one dataset and connecting them with a
relation. Unfortunately, the result isn't as expected. Instead to load both
tables correctly, the field "KdNr" in the child table stays empty. In the
end, the function "GetChildRows" cannot find anything.

Hasd anyone got a good example of running Jetcomp via a VB6 app to repair a
password protected Access database
Thanks in advance
---

Can someone please shed some light on this. I have been banging my
head for days
I have an access database that i am connecting to from VB using jet
4.0

I have a simple SQL that retrieve value from oracle package function. The problem is if I run this simple statement with SQL/Plus it give me a value but not with ADODB.RecordSet object
This the SQL:
SELECT Customer_Order_Line_API.Get_Sale_Price_Total('1135', '6', '1', 0) FROM DUAL

How can I create a Tab Delimited Text File from ADO Recordset and VB-6 ?
Best Regards,
Luqman

I have created an application in Access 2000 with VB front end. Recently, I had to realised one of the stored procedures in the access database itself was incorrect.
How can I update that stored procedure without having the database sent to me?
I've only ever had to do this with ...

I tried to search here for the "Getting Started Help" topic, but I could not find it -
Where is it please?
What I am actually seeking are the instructions that I need to use this particular newsgroup from Outlook Express.
Thank you,