Results 1 to 2 of 2

Thread: Autonumber

  1. Sep 2nd, 2000, 01:38 AM #1
    qassim
    qassim is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2000
    Location
    karachi
    Posts
    90
    Hello,
    I have table name
    master and there is field
    itemcod i want whenever I pressed
    add buttton in form
    it generate max number from table
    and display in textbox
    Is it possible with sql query
    I am using Ado vb6 access 2000 table
    Bye

    Reply With Quote Reply With Quote
  2. Sep 2nd, 2000, 02:17 AM #2
    sanon
    sanon is offline
    Lively Member
    Join Date
    Aug 2000
    Location
    Texas
    Posts
    88
    sql = "select max(itemcod) as maxid from master"
    rs.open sql,connection

    text1.text = (rs!maxid) + 1

    Did you get an idea?

    [Edited by sanon on 09-02-2000 at 03:19 AM]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width