jamesnkk
Last Activity: Mar 18 '09, 08:33 PM
Joined: Nov 25 '06
Location:
-
Thank you I will try -
Wow!, it work !!!, thank you so much...Leave a comment:
-
Sql Statement
Hi,
Can anyone tell me what wrong with the statement, when I run the program,
no record was selected.
Please Advise -
rs.Open "SELECT Process.Failure Code, Process.SN, Process.TestDat e From Process WHERE not isnull(failureC ode) AND TESTDATE>=" & CDate(StartDate ) & " And TESTDATE<=" & CDate(EndDate) & " ORDER BY Process.Failure Code, Process.SN,Proc ess.TestDate",... -
How to count using distinct
Hi, I have a ms-access table and i want to count the failure occurance.
BOARD-ID....FAILURE
A-123.......... FAIL-A
A-123.......... FAIL-A
A-125..........FA IL-A
A-126.......... FAIL-A
A-123.......... FAIL-B
A-123.......... FAIL-B
as you can see, the board id may repeat more than 1 row, since it the same
board id with the same faulure, I would count as 1.... -
Hi Edward,
Thank you so much for the valuable information, I will try and get back to you....Leave a comment:
-
Thnak you Edward for your reply and suggestion, In our environment, the Linux machine act as a Tester which test the board and everytime generate a new log file in the /tmp folder. No users will sit infront of the Linux to operate the command.
Developer at windows XP will then retreive the new log file from the /tmp folder and crunch the data, After data been crunched, it will move those log files into another folder. Since windows...Leave a comment:
-
How to Set Permission for "nobody" account
Hello, I am a newbie in Linux. My company have a tester machine installed with Suse 10 samba.
I have set the IP address of the Linux machine to connect into the Windows 2003 server. So from my windows xp I could browse thru the machine and have set a share folder /tmp on the linux machine. Everything work perfect, the problem is that everytime the linux generate a new log file and save into the /tmp folder. From Windows XP, I cannot... -
Disk Network Error using VB6 and MS Access
Hi,
I have an application written in VB6 with MS Access 2000 format. both application and MS Access Mdb are stored in the Network Map drive.
I am using ADO to access the data.
Sometime running the application it will display Disk Network Error, does anyone know what cause the problem ? -
No relationship, It only show rs.editmode no rs.edit, could you explain a bit more ? I cannot rs.edit it display method or data not found....Leave a comment:
-
No, I am the only one using , it just pure ms access database...Leave a comment:
-
VB6 Runrime error Could not Update currently locked
Hi, I am using ADO, sometime I got an error message Could not update currently lock, and sometime I don;t . Error stop in last sentence "Rsumm.Upda te" , Before exit the program I have use rsumm.close and
set rsumm = Nothing
I am lost could someone advise me.
Set rs = New Recordset
rs.LockType = adLockPessimist ic
rs.CursorType = adOpenDynamic
rs.CursorLocati on... -
VB6 How to capture a record number
How can I goto a record number ?
After I have Find the record (MS Access Table), can I capture the record number
so I can move to the specific record later. -
Form Load does not trigger
Hi, I am new to vb6.
I have some code written in the form load. the first time when I call the form, the code inside form load will activate.
After I have complete the form and return to main menu, the 2nd time when I call the form, it does not trigger the code in the form load, I put a debugging point on the code in the form load, but it not trigger, any idea what wrong ? -
Thank you so much it work...Leave a comment:
-
I think you miss out & and the " before ORDER, I manage to get it right,
thank for the inspiration.
...Code:rsProcess.Open "select * from Process where SN = '" & Bd_details.Controls(Bsn).Text & "'" & "ORDER BY SN,Debugno desc", conn
Leave a comment:
-
Error message display "Expected End of Statement"...Leave a comment:
-
SQL statement Order By
HI,
I want to set the order by desc in the sql statement, but my statement cause
BOF or EOF, what wrong with the statement ?
Code:rsProcess.Open "select * from Process where SN = '" & Bd_details.Controls(Bsn).Text & " ORDER BY sn, debugno desc" & "'", conn
-
SQL Statement
Hi,
I am not sure how to use the proper sql statement, those quote and double quote
very confusing.
Could somebody help me re-sentence the correct statement
rsDebug.Open "Select * from DebugProcess where SN=" & sn1.Text & " 'and failurecode ='VTT' ", conn -
Cannot Retain Permission
I am new to windows server 2003, lately we encounter a problem here -
We have a program written in visual basic with ms access to store the data.
The program and data was stored on the network folder G:\PrData.
All users were able to run the VB program, later our Manager request only 4 users are authorize to run the program, our MIS done some permission setting on the server.
Now the problem arise,... -
thanks you so much for the code...Leave a comment:
No activity results to display
Leave a comment: