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 Chriss Miller 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. luisbo69

    Microsoft access 2000 variable on declare function DllRegisterServer

    Hi, I am using the following statement: Private Declare Function DllRegisterServer Lib "C:\Documents and Settings\All Users\Redemption.dll" () As Long but users cannot save anything on c:\winnt or C:\Documents and Settings\All Users\ only on C:\Documents and Settings\[USERID] then I need to...
  2. luisbo69

    UNON QUERY WITH SUB QUERIES

    yes, it is an option too. thanks... but I am still intrigued about the reason of this behavior
  3. luisbo69

    UNON QUERY WITH SUB QUERIES

    I have tried without the ORDER BY, and a union query calling the three subqueries. still taking 5 minutes...
  4. luisbo69

    UNON QUERY WITH SUB QUERIES

    I have this union query, it takes about 5 minutes to run, but if I separate each select, each one takes seconds, what am I doing wrong? SELECT "sin asignar" AS type, [chrbanco], [chrmoneda], [dtmfechamovimiento], [fltimporte], val([chrnumerooperacion]) AS operacion, [chrtransaccion], 1 FROM...

Part and Inventory Search

Back
Top