need help

Results 1 to 2 of 2

Thread: need help

  1. #1
    Join Date
    Dec 1969

    Default need help

    i am using vb with access .in my application have a customer table how to generate autonumber.<BR><BR> right now i am using whil for count the record.but one thing suppose i delete one record proble is created.<BR><BR>i create table using visual data manager here auto no field is not available.<BR><BR>what can i do<BR><BR>rs.movenext<BR>while rs.eof<BR> i=i+1<BR> rs.movenext<BR>wend<BR><BR>txtcustno=i+1<BR><BR>th is is my code<BR><BR>urs<BR>mani<BR>

  2. #2
    Join Date
    Dec 1969

    Default Huh?

    You are trying to create an autonumber field by just adding 1 to a variable?<BR><BR>I hope this is not a multi user app as if so you are in big trouble.<BR><BR>Why can&#039;t you create an autonumber field? If you can&#039;t just open Access to create it, do it with a create table query<BR><BR>"Create Table MyTable (field1 counter)"<BR><BR>There you go, now you have a table called MyTable with an autonumber field called field1<BR>

Posting Permissions

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