Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old March 8th, 2005, 03:17 AM
Utarian Utarian is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2005
Posts: 11 Utarian User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 6 m 55 sec
Reputation Power: 0
Question how to generate automatically?

hi,
any one here know how to generate a number like document number automatically? tat means i do not want the user to key in after press the add button Access will generate a document number for that record.

any one can help me??
thanks a lot ...

Reply With Quote
  #2  
Old March 8th, 2005, 05:02 PM
alex_lee822 alex_lee822 is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2005
Posts: 43 alex_lee822 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 41 m 15 sec
Reputation Power: 4
Just add a field name called "Number" (or whatever you want it to call) in the table you're going to work with.. and then make that field a "Autonumber" and then add that field in the form you want the user to work on.. and then it will auto generate the number for you.. you can lock that field under "properties" (right clicking) so taht user can't change the number.

Reply With Quote
  #3  
Old March 8th, 2005, 07:27 PM
Utarian Utarian is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2005
Posts: 11 Utarian User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 6 m 55 sec
Reputation Power: 0
oic ..
now my case is i got a main form and a subform. the autonumber will be in the subform. so everytime the user add a record it will automatically add 1 according to the numbers of the records added.. that means 1 number for 1 record in the subform. and then everytime the form is reset the number will back to 1 again. is there any way to do so?

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > how to generate automatically?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway
Stay green...Green IT