Recent content by CortexWayne

Hello, I have built an ftp transfert with the wininet.dll wich works on 99% of my clients except this guy wich at the end of the download receive the error: 12002 from Err.LastDllError wich seems to be "The request has timed out." Others receive Internet Call Back Status :40...

Thx a lot PH It worked perfectly! Martin L.

Hello, I'm trying to put data into PIpgF from PEbv Where there is no PipgF row containing the value 2 in ipgSource INSERT INTO [C:\KPA\PGenet].PIpgF (CodeFemel, DateEven, CodeIpg, IpgRes, IpgRep, IpgSource) SELECT CodeSiga, DateEven, CodeIpg, IpgRes, IpgRep, 2 FROM [C:\PKPARES].PEbv AS SOURCE...

oK! WOooHOOO!! I found the anwser here it is! SELECT t1.CodeFemel , t1.Tatou , 'F' as Sexe , t3.CCSIErr , t3.RepEnvoi FROM PMater.PFemel AS t1 LEFT outer JOIN [ SELECT CodeFemel , Tatou , TypeReq , RepEnvoi ...

Ok I might not be in the right forum I'm developing a VB application wich use Access Database, VisData is a freeware wich call query to access database and return response so I dont need to run my program for each test i do. I'm unable to save anything as a query and the use it again. Can you...

No I tried your code in my VisData, same error... A "name dot name" is different database database.tablename so they look in 2 different access database A genetic database and a maternity database wich are used in the same project

NO :( Because it returns only the rows than have typeReq equal to 4 and I want ALL t1 rows WITH t3.CCSIErr, t3.RepEnvoi in the case TypeReq equal to 4 in t3 thanks again! Here is a simple example of what i need t1.CodeFemel t1.Tatou 1 A 2 B 3 C...

Arggg! To bad :( What I need is to join these two table but only in the case the t3 table have typeReq = 4 because the CodeFemel and TypeReq are a spit unique key. Any suggestion other than doing 2 query and filtering them after? thx Jeff to have took the time to anwser my post. Martin

SELECT t1.CodeFemel, t1.Tatou as Tatou,'F' as Sexe, t3.CCSIErr, t3.RepEnvoi FROM (PMater.PFemelc AS t1 LEFT JOIN (SELECT CodeFemel, Tatou, TypeReq, RepEnvoi, CCSIErr FROM PGenet.PGCcsiF WHERE TypeReq = 4) AS t3 ON t3.CodeFemel = t1.CodeFemel) Err 3131 Error in FROM clause Sorry, I'm french...

Hi! Here is my little problem. I have built a program that read Excel sheet to update his price list. So my program is done in VB6 programmed on a win2k with office 2000. When I run my program on a win 98 win office 2000. He is abble to open my Excell workbook with this: Set myExcel = New...

Hi! Here is my little problem. I have built a program that read Excel sheet to update his price list. So my program is done in VB6 programmed on a win2k with office 2000. When I run my program on a win 98 win office 2000. He is abble to open my Excell workbook with this: Set myExcel = New...

I have install MDAC 2.7 on the running machine, nothing changed... MDAC seems not to be the answer :(

thx a lot Awelch I'll look foward and I'll return with that.

No! It is an inventory and submission system with a simple access database, no com or anything else. My database is linked with ADO connections... as easy as this...

it reboot on a recordset.update most of the time but sometimes it works fine and crash somewhere else... Usually two or three lines later