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. bojisheng

    Excel 2003 slow on Memory Deallocation

    Thanks for the tip. I will be checking that first thing next week. Regardless if it is a leak, it is the time it takes to release the memory. I don't know if it is going thru executing distructor methods for items that were not already set to nothing. or maybe it doesn't execute the destroy...
  2. bojisheng

    Excel 2003 slow on Memory Deallocation

    We have an excel spreadsheet app (in VBA) that uses DAO. The app works fine. After exiting the spreadsheet, any other app (operating system level interface seems fine) seems unresponsive. (I am pretty sure [ponder] that this is not the SMB signing issue in MSKB Article 814112). We did notice...
  3. bojisheng

    this or self for an class instance in VB/VBA

    I have created a class that I want to manage its instances via a collection (I am using VBA so no Dictionary). I would like an instance to check a collection and add itself to the collection (if it does not exist). I have not found a way to reference the instance while within a method. This...
  4. bojisheng

    Pass a function to a function

    Thanks for the Tip. I used the following as a test and it worked! (execute test2) Function test(i As Integer) check = MsgBox(i, vbCritical, "i am here") test = i * 2 End Function Sub test1() test 5 End Sub Sub test2() j = CallByName(ThisWorkbook, "test&quot...
  5. bojisheng

    Pass a function to a function

    I am creating a library of standard functions. I would like to provide the ablity to allow a "callback" function. To set this up, I would like to allow the user to pass the function to be called as a parameter. Like passing the address to a function in C. Does anyone know how/if...
  6. bojisheng

    Wish List

    NT Validation via Web to optionally happen on the I-Server. When the MSI Web Servers are in a DMZ, they do not have access to the internal Domain.
  7. bojisheng

    Simple : window.close()

    I actually have the same problem and have not been able to resolve it. Could someone be a hero[medal] to two people? I've made the site a trusted local intranet site (which it is) with the lowest security and it still prompts. Unlike NEVERSLEEP, when I type javascript:window.close() in the URL...
  8. bojisheng

    Invoke ASP on another Server (VBS)

    fengshui_1998, Thanks. Do you have an example on how to log in to another server and invoke a ASP/VBScript? bojisheng
  9. bojisheng

    Invoke ASP on another Server (VBS)

    Please bear with me, for I am a novice VBScript/ASP coder. I have two Web Servers behind a load balancer. They are running the identical applications. I have made a modification that utilizes Application variables. A users actions can cause an Application variable value to change. I would...
  10. bojisheng

    Check for for upcoming password expiration

    nlim, [lightsaber] Sorry, I misunderstood you point [peace]. I did not realize that 7.2 and 7.1.4 SDK would be similar enough that I could pilfer 7.2 sample code for 7.1.4 [surprise]. Is 7.2 available to all customers? Does it require a new CD Key? Or do I just need to contact MSI for...
  11. bojisheng

    Querying multiple fact tables

    What DB are you using (looks like Oracle?) SQL97 statement that should do this would be... select * from customer c, left outer join orders o on (c.customer_key = o.customer_key ) left outer join returns r on (c.customer_key = r.customer_key ) where...
  12. bojisheng

    Check for for upcoming password expiration

    Thank you nlim. However, If I was using 7i, I would not need this work around. I need to resolve this in 7.1.4. It look as if IDSSUser object ( so I can get the IDSSUserAccount object and look at the PasswordExpirationDate) can be pulled from the IDSSSession object. It would be something...
  13. bojisheng

    java and ware housing

    IBM UDB also support JDBC (I used in version 5.2 ... now they are up to 7.x .. I assume it is still supported) What do you mean by "helps in warehousing project?" In ETL, rolling up the data into summary tables, relationship repository (Meta data), creating/running/maintaining...
  14. bojisheng

    Check for for upcoming password expiration

    In 7.1.x, account password expiration actually expires the account not just the password. (this is working a designed! ) ; thus, a user can not get on to change their password. I understand the design has been change to behave like NT in 7i (where i=2 :-) ) Until we have the time/resources/etc...
  15. bojisheng

    Element request, role priority

    We had the same problem. The MSI Consultants had a piece of code that cause object browsing (prompts, elements etc) to be assigned to whatever you want. In our case, we assigned these types to High and allocated 15 high threads to be specifically for these. The code is the code in tech note...

Part and Inventory Search

Back
Top