•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Windows Software section within the Tech Talk category of DaniWeb, a massive community of 397,589 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,018 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Windows Software advertiser:
Views: 3493 | Replies: 0
 |
•
•
Join Date: Jan 2006
Location: Land of Hope & Glory
Posts: 88
Reputation: 
Rep Power: 3
Solved Threads: 0
Junior Poster in Training
Microsoft Access Format/Validation ??? Wonder if anyone could possibly help by pointing me in the right direction towards the problem that a friend of mine is experiencing while working on Microsoft Access.
Firstly, he's "Account No" field with Data Type as "Number" & in the "Field Properties" at the bottom, he's Field Size set to "Integer" & Format to "00000". However, what we want is a RANDOM NUMBER (so NO increament) of EXACT 5 digit appearing automatically, when we start creating a new record. (as the picture shows). Sadly, all we get is ONLY "00000" written in the "Account No" field.
Secondly, he's "Card Number" field with Data Type as "Number" & in the "Field Properties" at the bottom, he's Field Size set to "Long Integer" & Format to "0000 0000 0000 0000". However, what we want is a RANDOM NUMBER (so again, NO increment) of EXACT 16 digits appearning automatically, when we start creating a new record (as the picture shows). Again, sadly, all we get is ONLY "0000 0000 0000 0000" written in the "Card Number" field.
Additionally, in "Card Number" what we want is ONLY 19 character in the format "0000(space)0000(space)0000(space)0000", all generating AUTOMATICALLY, so users won't have to type in long numbers manually.
Firstly, we can't have TWO Auto Numbers in one table (since Access don't allow it) & secondly, if we do "AutoNumber" as Data Type for say "Account No" & in "Field Properties", Field Size at Long Integer (the only available option other than Replication ID, which I've NO CLUE whatsoever) & the "Format" as "0000 0000 0000 0000", we can't get exactly the requirements I mentioned above, since sometimes we get negative numbers & sometimes with decimals in it.
He'll have many tables by the time he finishes, since it's bank a/c database he's creating & "Account Number" would be a Primary Key.
Wonder if there's any way, we could achieve what's required ???
Firstly, he's "Account No" field with Data Type as "Number" & in the "Field Properties" at the bottom, he's Field Size set to "Integer" & Format to "00000". However, what we want is a RANDOM NUMBER (so NO increament) of EXACT 5 digit appearing automatically, when we start creating a new record. (as the picture shows). Sadly, all we get is ONLY "00000" written in the "Account No" field.
Secondly, he's "Card Number" field with Data Type as "Number" & in the "Field Properties" at the bottom, he's Field Size set to "Long Integer" & Format to "0000 0000 0000 0000". However, what we want is a RANDOM NUMBER (so again, NO increment) of EXACT 16 digits appearning automatically, when we start creating a new record (as the picture shows). Again, sadly, all we get is ONLY "0000 0000 0000 0000" written in the "Card Number" field.
Additionally, in "Card Number" what we want is ONLY 19 character in the format "0000(space)0000(space)0000(space)0000", all generating AUTOMATICALLY, so users won't have to type in long numbers manually.
Firstly, we can't have TWO Auto Numbers in one table (since Access don't allow it) & secondly, if we do "AutoNumber" as Data Type for say "Account No" & in "Field Properties", Field Size at Long Integer (the only available option other than Replication ID, which I've NO CLUE whatsoever) & the "Format" as "0000 0000 0000 0000", we can't get exactly the requirements I mentioned above, since sometimes we get negative numbers & sometimes with decimals in it.
He'll have many tables by the time he finishes, since it's bank a/c database he's creating & "Account Number" would be a Primary Key.
Wonder if there's any way, we could achieve what's required ???
Nope, I'm NOT God, but I'm British (which is the next best thing ;)
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Windows Software Marketplace
Linear Mode
•
•
•
•
apple browser business c# code computer console dell development drm dvd erp systems firefox game google hd india internet ipod linux malware media microsoft mobile mozilla news office open operating os pc search security server software software selection source spyware survey system technology evaluation ubuntu upgrade virus vista web windows xbox 360 xp zune
- Is it possible to display report in Visual Basic which is created in Microsoft Access (Visual Basic 4 / 5 / 6)
- Microsoft Access 2003 Validation Rule (MS Access and FileMaker Pro)
- Microsoft Access Field Format ??? (Windows Software)
- Microsoft Access date validation (Computer Science and Software Design)
- Upgrading to Microsoft Access 2002 (MS Access and FileMaker Pro)
Other Threads in the Windows Software Forum
- Previous Thread: Protection Suite with certain characteristics?
- Next Thread: WIN32 Application Loss?
