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 derfloh 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. alfredp77

    SendKeys does not work??

    Hi all... I write a simple program to simulate keystrokes to another application. Basically I use AppActivate and SendKeys, so it is something like this: 'make the app active AppActivate(strWindowTitle) SendKeys(strKeys) It works fine for standard windows applications (Notepad, Excel, Word...
  2. alfredp77

    Two table join on datetime with unlike intervals - please advise

    Try this: create table #report( systemname sdatetime gbl_cpu_total_util gbl_num_cpu ) insert #report select b.systemname, a.datetime, max(b.datetime), null,null from globl a inner join configuration b on a.systemname = b.systemname and b.datetime <= a.datetime group by b.systemname, a.datetime...
  3. alfredp77

    Need help with Trigger

    the other way to avoid the recursion call (other than dky1e already mentioned) is like this: if update(SHDEL2) return and to make sure you only update one row of data each time (only the updated data, not the entire table), you should do a join with the &quot;inserted&quot; table. update...
  4. alfredp77

    Stored Procedure which queries an AS400 Linked Server

    Hi, I have a stored procedure that does a query to JDE running in AS400 (I configure this as a linked server). I use OPENQUERY to execute the queries. I execute the stored procedure from Query Analyzer there is no problem, and the execution time is really fast. But when I execute the stored...
  5. alfredp77

    Memory hogging

    ...Form2.Show End Sub Private Sub Form_Unload(Cancel As Integer) Set rstData = Nothing End Sub Code in Form2 Public rstPass as ADODB.Recordset ************** zemp: strongm, can you elaborate. How is the reference count increased and how can you determine what it is reference count is...
  6. alfredp77

    How can I use operator (+, -, / , * ) in a variable

    Use the Microsoft Script Control component. Put it in your form, then use the Eval method: Dim intTest As Integer intTest = ScriptControl1.Eval(&quot;10+10&quot;) intTest will have the value of 20. Hope it solve the puzzle :-)
  7. alfredp77

    Better Flexgrid

    I've been using VideoSoft VSFlexGrid Control (7.0) and FarPoint Spread 3.0
  8. alfredp77

    oletree

    sorry, not quite clear with what you mean by &quot;How can I automaticlly open the table it is requesting and skip that step of having to open it. I am selecting the table on the init() of the form and it is fills my treecontrol with what I need. . .but it asks to open it again. . .??? &quot...
  9. alfredp77

    obtaining the local machine ip address

    The easiest way is to use the Microsoft WinSock control and read it's LocalIP property.
  10. alfredp77

    count(*) and group by causes errror

    the vwcount is not a view, it is an alias for the query: select company.company_code, count(member_id) total from Company, Members group by company.company_code
  11. alfredp77

    Sort Order Headache

    I think we can make it simpler: Select * From Models Order by replicate('0',12-len(KeyCode)) + KeyCode, description
  12. alfredp77

    Insert Trigger Doesn't seem to work with Insert/Select

    if you are using SQL Server 2000, then you can use &quot;INSTEAD OF&quot; triggers. Check out this link to find out how to use it: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01a17.asp
  13. alfredp77

    Persistable DLL?

    I've mail you the code. Hope it helps :)
  14. alfredp77

    Add members from VBA code

    1. remove the GOs from your stored proc. sql will start another batch after GO. so after your first GO, everything else will not be part of CREATE PROCEDURE statement. 2. your storproc parameter is wrong, you must concatenate 'DSTOMESSAGING\' and @UserID, store it to a variable then pass it to...
  15. alfredp77

    Persistable DLL?

    That's possible. Ok, first of all, you cannot achieve such thing using an activeX DLL, because DLL will run in-process, that is, in the same process space as the EXE that invokes it. So it is impossible to access variables/objects in the same DLL that is invoked by another EXE. You can do it...
  16. alfredp77

    How to get name of table from mdb file

    Use the &quot;OpenSchema&quot; method of your connection object: Dim mConn As New ADODB.Connection Dim rstTables As ADODB.Recordset 'Assuming that u've already open the connection to 'the Access database using mConn: Set rstTables = mConn.OpenSchema(adSchemaTables) With rstTables Do While...
  17. alfredp77

    SET ANSI_NULLS error???

    Try to set the default connection options for the server through enterprise manager (right click on the server, properties, connections, and you can see a lot of checkboxes, two of them are ANSI WARNING and ANSI NULLS). This works for me. Specifying SET ANSI NULLS and SET ANSI WARNINGS ON for...
  18. alfredp77

    Passing a value to a textbox

    tekomni, Usually what I do to achieve your goal is something like this: Code in Form1 Event UnloadForm(strText As String) Private Sub Form1_Unload() 'during the unload, raise the event and pass 'the text you want to return, 'in this example, i'm returning text 'from...
  19. alfredp77

    I'm stumped

    try this on your populateLocationDetails sub: Private Sub populateLocationsDetails(objSelNode As Node) Dim objList As IXMLDOMNodeList Dim objLocationsElement As IXMLDOMElement Dim objChildElement As IXMLDOMElement Dim i As Integer If objSelNode Is Nothing Then Exit Sub 'On...
  20. alfredp77

    Should I use an EXE or DLL?

    just a little addition: actually creating an activeX EXE is almost the same as creating an activeX DLL, it's only that activeX EXE will run on it's own thread. beside using registry/log files, you can define an event in the class inside the activeX EXE and raise the event to notify the main...

Part and Inventory Search

Back
Top