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 wOOdy-Soft 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: miked123
  • Content: Threads
  • Order by date
  1. miked123

    Revision letters in a column-Select,Grouby issue

    A fellow on the CR forum has the following problem: snip.. Part numbers have a revision letter as follows: 123A-234A 123A-234B 123A-234C I want to show this one only I posted this SQL statement which works but returns two columns. How can I rejoin the columns?? This puzles me Thanks MikeD...
  2. miked123

    Bound or Not Bound - A question

    What is the general consensus using controls. Do you bind them or write the read and write procs. I'm talking 50k records and up. Last century we would never use a bound control. Have things improved, can you cancel an edit in the new ado controls? Are you creating one connection and using...
  3. miked123

    DSN-Less connection using ADODB

    I have tried to connect to my local server buts but can't wihout setting the prompt to ALWAYS. Anybody have a clue? The code is right out of MS BOL. Here is my code m_ConnectionString= "driver={SQL Server};server=MDHOME;database=BasePkg;Data Source=Select * from...
  4. miked123

    Help on help SQL80.col

    When I Click on the BOL in SQL 2000 programg group, I get the error message that it cant open SQL80.col. I'm using the developer edition on my home pc/server. I copied everything in the books folder on the cd to my installed Books folder but still the same error. SQL80.col is not on the...
  5. miked123

    Counts in the parent and child

    Hi, I have a parent/child pair of tables that I need a count of both instances. The parent Contact Log has these fields LogDate,LogTime,LogType The child table has followup Calls to the parent. LogDate,LogTime. I need to count the instances of calls by Date and Time Of inital calls and...
  6. miked123

    ?Parameters from Formulas

    1. I need to pass a formula to CR. 2. Parse the formula so that 4 parameters are initalized from within the formula. I can only pass multiple parameters in this manner or a table since I'm using a Tool that restricts passing multi parameters. I need to know the syntax of assigning a value to a...
  7. miked123

    ADODB and OpenSchema

    I'm trying to get a listing of Databases available from a SQL server. I've built a ODBC Login form in Excel 2000 using ADODB connections. I can get all the table and field info about a database but I need the list of the Databases. Here is my connection: Set pADOcn = New ADODB.Connection...
  8. miked123

    SQL Views- Creating Multi Table View

    I have a Call-Log Table and 5 Child Call-Type Tables. The Call-Type Tables DO NOT have a Call_Type Column. Need to add a Call_Type Column to the View AND assign a call_type identifier 1..5. I can then Group By Call_Date,Call_Type,Call_Person or what ever. I can then use a Case ... When statement...

Part and Inventory Search

Back
Top