Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sm0wb04rd3r
Starting Member
15 Posts |
 Posted - 2004-01-23 : 04:12:38
|
| Hi!I promise this is my last question for today.. :))) I wont be bothering more.I still have two problems. 1. I am making a database and of course before I will finish it I am testing it. The problem is that the Customer ID (which is set to primary key and it is autonumber) is beginnig with 0004 (because of testing with records) and I would like the finished database to begin with 0001. So how could I reset this record to begin wiht 0001??2. I have another database where the Customer Id (also primary key) should be 4digitnumber_year_mont of registration. (Example: 0001-04-01; where 0001 stands for the code/number/id of customer, 04 stands for 2004 and 01 stands for January. What I would like is that the code/number/id section should be increasing automatically and the other part of the ID (year and month) should be changed manually or automatically. Example: if today is 2004 february of 14th and this is my 214th customer the Customer Id (automatically) should be set: 0214-04-02. Can this be done with ms access or not?? Thanx a looooot!! |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2004-01-23 : 05:50:16
|
| 1. Just Compact (see menu >> service >>) your db. By thisthe autonumber field will be reset (if the table itself is empty).2. This trick with autonumber field is impossible........ Why notjust add into the table one more field for storing the "year-month"s? |
 |
|
|
sm0wb04rd3r
Starting Member
15 Posts |
Posted - 2004-01-23 : 06:35:11
|
| THANX A LOT!!! |
|
|
|
sm0wb04rd3r
Starting Member
15 Posts |
Posted - 2004-01-23 : 06:38:27
|
| By the way!! What is this? (see menu >> service >>) where can I find it??? |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2004-01-23 : 06:59:14
|
| This is ms access main menu bar, old bean.The case is my ms access of Swuahili version, henceI don't know english equivalents for those option names. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-01-28 : 16:31:09
|
The English equivalent is Tools / Database Utilities / Compact and Repair Database.(Hey Stoad, you ever think about doing AccessTeam.com  )--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2004-01-29 : 02:03:29
|
| Never, Mark.. lol.. |
|
|
|
|
|
|
two imortant questions and I am off.. :)) thanx!