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.
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...
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...
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)
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.