Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jsnulf
  • Content: Threads
  • Order by date
  1. jsnulf

    Parsing a string In Stored Procedure

    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...
  2. jsnulf

    SQL Tables

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

    List SQL Server Tables in Database

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

    Expressions for default value of a control (Access 2000)

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

Part and Inventory Search

Back
Top