MS Access 2000


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

View Poll Results: MS Access 2000

Voters
2. You may not vote on this poll
  • Reset Autonumber

    0 0%
  • MBD Access File Format

    2 100.00%
Results 1 to 8 of 8

Thread: MS Access 2000

  1. #1
    Join Date
    Oct 2008
    Posts
    2

    MS Access 2000

    Hi Everyone:

    Please any one can help me and show me how to reset an Autonumber utilizing the visual basic code??? because it is very important for my database.

    what is MBD access file format and how to creat it??????????

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Welcome to DevX

    I don't understand the purpose of the poll? What are you polling?

    Autonumbers won't be reset....they will continue on from the last number used regardless of what previously used numbers are no longer in use. That is how Autonumber works.

    Do you mean MDB format?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  3. #3
    Join Date
    Oct 2008
    Posts
    2
    thank you man but please can you tell me how to create a field that increment it's value with every entered record so i can reset it's value when ever i want.
    just to ******** my idea, this field which i am taking about is contatenated with another one named "year" so with every new year i want the other field to rest it's value and i can write it's code but the only problem that i am facing right now is how to create a field that mimics the autonumber in function.
    thabk you again for the replay and keep in touch.

  4. #4
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Quote Originally Posted by Embryologist
    thank you man but please can you tell me how to create a field that increment it's value with every entered record so i can reset it's value when ever i want.
    There is no field type for that. The only way this can be accomplished is through programming code.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  5. #5
    Join Date
    Feb 2008
    Posts
    162
    Yes, you will have to do it manually. You can create a table with a single integer column to contain the current value. Then create a function that increments the value in the table each time you call it and returns the current one. You can reset it anytime you want because it is just an integer column.
    It's not what you don't know that gets you in trouble. It's what you know that just ain't so. -Mark Twain

  6. #6
    Join Date
    Feb 2008
    Posts
    162
    BTW, I voted for MDB File Access Format.

    Slope, who thinks a metric calendar would be much simpler.
    It's not what you don't know that gets you in trouble. It's what you know that just ain't so. -Mark Twain

  7. #7
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    I don't like autonumbering, but that is because, typically, I detest things doing things for me automatically. If I want something done, I like to do it for myself.

    Programmatically issuing record numbers is better, but that leaves open exactly what the OP is trying to do, and I don't like renumbering either. There is always an inherent problem with renumbering, and that is the potential for confusion.

    I have seen it happen.

    On Monday, a user runs a report and has records for 5 assignments.

    The records are:

    0001 = belongs to Bob
    0002 = belongs to Bill
    0003 = belongs to Frank
    0004 = belongs to John
    0005 = belongs to Bruce

    The assignment for Frank is cancelled and the record deleted, with everything being renumbered.

    The following Monday, the same report is run, but now the cities are all renumbered, and the user wants to know what the heck happened because now the assignments are:

    0001 = belongs to Bob
    0002 = belongs to Bill
    0003 = belongs to John
    0004 = belongs to Bruce
    0005 = Unassigned

    Once a number is taken, I believe it should remain taken, and never, ever used again.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  8. #8
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Quote Originally Posted by Slope
    BTW, I voted for MDB File Access Format.
    Me too.
    Quote Originally Posted by Slope
    Slope, who thinks a metric calendar would be much simpler.
    Actually, I'm rather fond of the Mayan calendar.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

Similar Threads

  1. Access 97/Access 2000 on same server
    By FPL in forum ASP.NET
    Replies: 2
    Last Post: 05-21-2002, 07:16 AM
  2. ACCESS XP, SQL Server 2000 Stored Procedures
    By Mike in forum VB Classic
    Replies: 0
    Last Post: 08-11-2001, 09:44 PM
  3. NNTP, OWA and Outlook 2000 access to the same folders
    By edwin rutsch in forum Enterprise
    Replies: 0
    Last Post: 09-14-2000, 05:54 PM
  4. Office 97 db failure if Access 2000 installed
    By Kathleen Dollard-Joeris in forum VB Classic
    Replies: 8
    Last Post: 05-23-2000, 10:54 PM
  5. Multi-row calculations
    By Bob Hines in forum Database
    Replies: 7
    Last Post: 04-27-2000, 11:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center