Search results for query: *

I need to pass a where clause to a stored proc using ADO. The where clause may contain any number of items.  The stored proc returns a single recordset. The clause is of the nature: "WHERE (AUTHOR='JONES' OR AUTHOR='SMITH') AND PUBLISHER="VIKING".  Must this be...

From jsnulf... I found answer using ADO instead of DAO....<br><br>This example uses the OpenSchema method to display the name and type of each table in the Pubs database.<br><br>Public Sub OpenSchemaX()<br><br>&nbsp;&nbsp;&nbsp;&nbsp;Dim cnn1 As ADODB.Connection<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim...

I need to enumerate the tables and fields in a SQL server 7.x database which I connect to thru ODBC.&nbsp;&nbsp;I have little support from my DBA so stored procedures are out of the question.&nbsp;&nbsp;Is there any way to do this with SQL or VB / VBA?

I need to enumerate the tables and fields in a SQL server 7.x database which I connect to thru ODBC.&nbsp;&nbsp;I do not have access to SQL system tables.&nbsp;&nbsp;I have little support from my DBA so stored procs are out of the question.&nbsp;&nbsp;Is there any way to do this with SQL or VB /...

From Author: it appears that my database was funky.&nbsp;&nbsp;I created a new one and re-imported all objects; works ok. Perhaps there is a reason for the problem as stated... If anyone knows, feel free to respond.

In Access 2000, the expression &quot;= Date()&quot; entered for the default value for a control on a form or report does not work.&nbsp;&nbsp;I have entered this in the properties page in design view.&nbsp;&nbsp;Most other internal functions don't seem to work either.&nbsp;&nbsp;Now() does...