Member Avatar for firoz.raj

miss veena
kindly find the po.zip edit and uplaod

PO.zip (3.45 KB)
  • 2 Contributors
  • 5 Replies
  • 249 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by aktharshaik
Member Avatar for aktharshaik

check out the file i have altered and uploaded it.

I have altered the Form_Load()

and

added a new procedure MSFlexGrid1_Click()

PONEW.zip (3.89 KB)
Member Avatar for firoz.raj

Sir
You have seen po.frm code now problem is that product_id
is not comming in sorted order.
rs.Open " SELECT DISTINCT ITEM_CODE, PRODUCTNAME, UNIT FROM PARTDETAIL ", con, adOpenDynamic, adLockOptimistic

since it starts with a characted then no kindly help me
in order to sort product_id for user convenience.

Member Avatar for aktharshaik 
rs.Open " SELECT DISTINCT ITEM_CODE, PRODUCTNAME, UNIT FROM PARTDETAIL ORDER BY ITEM_CODE ", con, adOpenDynamic, adLockOptimistic
Member Avatar for firoz.raj

Kindly find the imp.doc

imp.doc (66 KB)
Member Avatar for aktharshaik

Assuming That the First letter only in the Item_Code is an Alphabet u can write the following query to sort in the way u have asked.

rs.Open " SELECT DISTINCT ITEM_CODE, PRODUCTNAME, UNIT FROM PARTDETAIL ORDER BY UCASE(LEFT(TRIM(ITEM_CODE),1)), VAL(MID(TRIM(ITEM_CODE),2,10)) ", con, adOpenDynamic, adLockOptimistic
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.