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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- luisbo69
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
UNON QUERY WITH SUB QUERIES
yes, it is an option too. thanks... but I am still intrigued about the reason of this behavior- luisbo69
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
UNON QUERY WITH SUB QUERIES
I have tried without the ORDER BY, and a union query calling the three subqueries. still taking 5 minutes...- luisbo69
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
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...- luisbo69
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
