hEY JAMES . Thanks a lot,.. tried and suceeded...
DELETE
FROM (SELECT TOP 1000 *
FROM Transact2
where Check_out IS NOT NULL
order by Check_in )
with a bit of alteration... u make my day..thanks again.....
GROG
Last Activity: Feb 4 '08, 12:32 AM
Joined: Sep 18 '07
Location: mALAYSIA
-
Thanks james.. Will try.....Leave a comment:
-
Hi rey..
Thanks for the advice.. but i just need to know the sql code for the operation... i'll use it in my vb code.. to do the operation in my access databse.. i just want to make sure wether such operation can be done using sql code.. i think it can be done if i have the right code...
SELECT TOP 100 *
FROM Transact2
ORDER BY File_no DESC
if we were to retrieve top 100 data.. can we...Leave a comment:
-
DElete Top XXX Query
Hi all.. i have 200 record in my database.. and i want to delete the top 100 of them when i arrange it in ascending order.... btw i'm using ms access ..
The problem: what is the SQL instruction for this... can it be done?
Thanks in advance..:) -
MsFlexgrid.. Color in a cell
Hi all..
I would like to ask.. how can i pick a cell in a flexgrid and put a color on it.. not the whole row.. a cell in a row...
If putting text..we use textmatrix... what about color...?
Need some light.. thanks.. -
thanks.. hope it'll helps.....Leave a comment:
-
Pack and Deploy
Hi ..alll..
I've done my programming and i want it to be deployed on other comp as an exe file...
i've used the pack and deploy wizard... but i need to include/create some folders e.g pictures.. that required during runtime of my application...
Question:
How to make pack and deployment of a program to other machine more flexible and dynamic.. which mean i can choose what i want to do when... -
Thanks.. it worked.... God bless u..Leave a comment:
-
Thanks.. will try...Leave a comment:
-
Form_QueryUnload
Hi all, need some light on this....
I have a form with sizable border.. and it has this three boxes on the top right hand side, the minimize, maximize, and close button..
Problem:
what i wish to do is.. when i click the close button the form should unload but before that, a message box appear to confirm whether are u sure to exit the program or not.. the problem is when i click "NO" the program... -
Thanks again, it is really a big help.... :)Leave a comment:
-
[Thanks a million veen... but i still have a problem..
i just "can't delete the last row of a non-fixed row" ( that was the error message looks like) ... is it possible to delete it? or how can i manipulate this error to be an input/trigger for my next action..? if its really cant be romoved i would like to empty the whole row.. but the row still there...
e.g
given;
errorr 30015 ="can't...Leave a comment:
-
Delete a row in MSFLEXGRID
Hi guys, how to delete a row in msFlexgrid? I have no problem in adding one... let say i have 5 rows, and i want to delete a row... the 3rd one.. Thanks -
How do u solve it.. mind sharing?Leave a comment:
-
Hi all , this is the connection and recset used...
Conn.CursorLoca tion = adUseClient
Conn.Connection String = DEnviroPeribadi .Connection1
Conn.Open
// Query// ( "Select * from XXX where name= xxx ..") <-- this is fine.. but the problem is.. to get the count of how many rows affected.. can i paste the code here? or there's other method..
RS.Open query, Conn, adOpenForwardOn ly...Leave a comment:
-
veen, thanks, tried.. no joy.. still trying...Leave a comment:
-
hi.. i have a Dataenvironment consisting a connection, 3 command, (parent, 1st child,2nd child) my aim of my report is to get a set of record based on the two table(i.e parent (group header) and 1st child(details)) .. and it went well.. (based on ur "dynamic Report " write up..thanks again)
so. now i have a set of record and, i want to put in my report , how many record affected when the query executed.. so.. i come up wif...Leave a comment:
-
DataReport - How to display expression
Hi all... i have a set of record to display in my data report.. and i would like to use the "Select count (*) fromm XXXX " statement to count number of record that i've chosen..
The problem is.. How can i make it appear in my Data report..? Using command1 in property i've coded and tested using SQL Builder.. i paste the data field on to my report.. but it doesnt appear and some error message... e.g "Express 1000 is empty/.."... -
Sorry all.. found it.. the date and the page num.. ThanksLeave a comment:
-
And also todays date.. as in Date printed < dd/mm/yyyy>Leave a comment:
No activity results to display
Leave a comment: