Visual Basic 4 / 5 / 6 RSS Visual Basic 4 / 5 / 6 RSS

kindly find the attachment

Reply

•
•
Join Date: Dec 2008
Posts: 292
Reputation: firoz.raj is an unknown quantity at this point 
Solved Threads: 1
firoz.raj firoz.raj is offline Offline
Posting Whiz in Training

kindly find the attachment

 
0
  #1
Dec 13th, 2008
kindly find updated test.doc
Attached Files
File Type: doc Updated test.doc (26.5 KB, 7 views)
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 304
Reputation: aktharshaik is an unknown quantity at this point 
Solved Threads: 37
aktharshaik's Avatar
aktharshaik aktharshaik is offline Offline
Posting Whiz

Re: kindly find the attachment

 
0
  #2
Dec 13th, 2008
Try this but i am not sure. b'cos i have not tried it myself. get back if any problem.

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
  1. rscombo.Open "select MAX(MID(item_code,2,10)), ITEM_CODE from production WHERE item_code is not NULL  and  LEFT(ucase(trim(Production.ITEM_CODE)),1) = 'P' GROUP BY ITEM_CODE "
Regards
Shaik Akthar
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2008
Posts: 292
Reputation: firoz.raj is an unknown quantity at this point 
Solved Threads: 1
firoz.raj firoz.raj is offline Offline
Posting Whiz in Training

Re: kindly find the attachment

 
0
  #3
Dec 13th, 2008
kindly find the ahmed attachment.
Attached Files
File Type: doc ahmed.doc (25.5 KB, 2 views)
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 304
Reputation: aktharshaik is an unknown quantity at this point 
Solved Threads: 37
aktharshaik's Avatar
aktharshaik aktharshaik is offline Offline
Posting Whiz

Re: kindly find the attachment

 
0
  #4
Dec 13th, 2008
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
  1.      rscombo.Open "select max(VAL(MID(item_code,2,10))), item_code  from production  WHERE item_code is not NULL  and  LEFT(ucase(trim(Production.ITEM_CODE)),1) = 'P' GROUP BY ITEM_CODE ORDER BY VAL(MID(item_code,2,10)) DESC"
Regards
Shaik Akthar
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 304
Reputation: aktharshaik is an unknown quantity at this point 
Solved Threads: 37
aktharshaik's Avatar
aktharshaik aktharshaik is offline Offline
Posting Whiz

Re: kindly find the attachment

 
0
  #5
Dec 13th, 2008
If the problem is solved please mark the thread as solved.
Regards
Shaik Akthar
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2008
Posts: 292
Reputation: firoz.raj is an unknown quantity at this point 
Solved Threads: 1
firoz.raj firoz.raj is offline Offline
Posting Whiz in Training

Re: kindly find the attachment

 
0
  #6
Dec 13th, 2008
Thank you SIR,

I WILL REMAIN GRATEFUL TO YOU
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC