Microsoft Access Format/Validation ??? - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 02-04-2006, 08:44 AM   #1 (permalink)
Junior Techie
 
Join Date: Jun 2005
Posts: 48
Send a message via Yahoo to j4mes_bond25
Default 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. 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. 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) ;)
j4mes_bond25 is offline  
Closed Thread

Thread Tools
Display Modes

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 04:08 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.