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!

  • Congratulations Mike Lewis 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: *

  1. defektorx

    Closing all windows using control box exit

    Not sure of the question, but the lastpost will do it, if its where you place it, you need to trap the main forms query unload event to make sure you are getting the top right hand close button.
  2. defektorx

    Identifying control types on a form

    this is a good one, its code from a form, you can loop through all the textboxes in the me.controls collection. No need to determine the control type. Option Explicit Private txtBox As TextBox Private Sub Form_Load() For Each txtBox In Me.Controls ' me refers to the form txtBox.BackColor...
  3. defektorx

    How to really kill all actives ADODB.CONNECTIONS

    See if a variation of this works. i have no experience of what you are doing but I use a variation of this code to make sure I kill the open connection. I use a variation to see if it is closed as well, and if it is i open it. Let me know what you think. Also is you work from the one connection...
  4. defektorx

    How do I bind a SQL Server temp table to a report ?

    Very good. Nice one mate. Can I bind it to the stored procedure in VB code ? I have 3 different stored procedures that return the same data for the report. I want to bind them at runtime to a report (the same one)
  5. defektorx

    How do I bind a SQL Server temp table to a report ?

    I have designed a report by creating a table in SQL server. I have then placed the report into VB. I am running a stored procedure which creates a temp table with the exact structure needed by the report. I am then using AddADOCommand to change the data data source of the report and I want to...

Part and Inventory Search

Back
Top