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: *

  • Users: VB400
  • Order by date
  1. VB400

    Error 8525. Distributed transaction completed. Either enlist this se

    I'm getting the message: -2147217900 Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction. I have one component running in COM+ which is defined as "Requires Transaction". First call I make to the component, it works without a...
  2. VB400

    Design Issue

    In an effort to minimize network traffic, we're thinking of offloading some database table access to each individual desktop (this is NOT a web based app and there is no intention of making it so). This would only apply to static tables that hardly ever change such as "State&quot...
  3. VB400

    Removing passwords from documents

    An employee who recently left the company, had all of his work documents password protected. We're trying to access these documents but we don't know the passwords and unfortunately, this person did not leave on good terms. Is there anything we can do to open these documents? Tarek
  4. VB400

    Retrieving last 3 transactions for each customer

    Rudy, what is XXX? Tarek
  5. VB400

    Retrieving last 3 transactions for each customer

    Thanks Rudy, No that was just sample data for the thread. You did make me smile though [thumbsup2] Tarek
  6. VB400

    Retrieving last 3 transactions for each customer

    Thanks MeanGreen. I'll try that. Is there anyway to do this in a SQL statement rather than an Stored Procedure? I will need to do something similar in Access. Tarek
  7. VB400

    Retrieving last 3 transactions for each customer

    I have a Customer Transaction table where each customer has many records. How do I return just the last 3 transactions for each customer? Say I have the following simple table CustID Date 1234 01/15/02 1234 02/16/02 1234 02/17/02 1234 02/18/02 4567 01/15/02 4567 02/16/02...
  8. VB400

    Printing From a Scheduled Task

    I have a VB program that is setup to run via Windows NT's Scheduled Tasks. The program basically generates a report that we want to print at night and have it ready on the user's printer first thing in the morning. When setting up the Scheduled Task, we give it an account name and password...
  9. VB400

    Default Property for .Fields and PropertyBag problem

    I'm having a problem with the following code: objPB.WriteProperty "UserName", .Fields("UserName") This gives me the following error message: Run-time Error 330. Illegal parameter. Can't write object because it does not support persistence. When I add the .Value property...
  10. VB400

    Permission Denied when creating a Word.Application

    Swi, You didn't address the problem with Permission Denied! Regardless of New vs. CreateObject, the Permission Denied is still the problem. Thanks anyway! Tarek
  11. VB400

    Permission Denied when creating a Word.Application

    This works fine on a Win/NT box; however, I have a client who needs this code on a Win/XP box using VB6 and Office 97. Make a reference to "Microsoft Word 8.0 Object Library" Dim objWordApp As Word.Application Set objWordApp = New Word.Application The last line gets...
  12. VB400

    Permission to use object denied (Error 419)

    I login as a Power User on a Windows XP box. My package is installed in COM+. When I start my front-end program, an error window is displayed "Permission to use object denied". I logout of Windows and login as Administrator and the application runs just fine. I researched this for...
  13. VB400

    Why is "Like" faster than "="

    So, eventhough it was trial and error on my part, it seems to have been the right solution in this case! -- I knew that -- X-) Thanks for your help Terry Tarek
  14. VB400

    Why is "Like" faster than "="

    That didn't seem to help! However, I changed the index to be clustered and that made all the difference in the world. Is this the right thing to do? I'm new to SQL Server so I'm not yet familiar with the "Standard Operating Procedures". It is my understanding that you can only have...
  15. VB400

    Why is "Like" faster than "="

    Terry, I just did that and there is a difference: When I use "=", SQL Server uses Table Scan When I use "Like", SQL Server uses Index Seek, Filter and Bookmark Lookup Why is this happening? Tarek
  16. VB400

    Why is "Like" faster than "="

    I have a query that selects records based on LastName and FirstName (the table has an index by LastName, FirstName): SELECT * FROM CUSTOMERS WHERE LastName = 'Smith' AND FirstName = 'Susan' This takes an average of 24 seconds to return 88 records If I change the SQL statement to: SELECT *...
  17. VB400

    DCOM over ISDN

    This question may have been asked before but "Search" is down. We're looking for installing ISDN to our remote sites as a backup to our T1 connections. I've heard in the past that DCOM doesn't work over dialup. Does anyone know if DCOM runs over ISDN? Thanks in advance! Tarek
  18. VB400

    ActiveX Control Installation

    The only thing I can think of is to write a quick VB program to: - Copy the .OCX or .DLL file to the C: drive from the CD - REGSVR32 path (where path is the location of the control on the C: drive) Tarek
  19. VB400

    Formatting a section

    Thanks Ken -- I was hoping that I can do my formatting in VB code as it is much easier than with CR. Tarek
  20. VB400

    Formatting a section

    When I double click on a section, it takes me to VB code as follows: Private Sub Section3_Format(ByVal pFormattingInfo As Object) End Sub It made sense to me that I can format data here before it prints. For example, I thought I'd be able to format a phone number before printing or other...

Part and Inventory Search

Back
Top