generate random number

I require a function where Access will generate an Autonumber with each
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14029-generate-random-number.html
number beginning with the letters 'BNS'; I would like about 8 numbers after
this. Also the numbers have to be unique. I am still a novice in Access so if
someone can give me a step by step guide it would be great!
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
--
Thank you for your help

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Kirt84 wrote:
> I require a function where Access will generate an Autonumber with
> each number beginning with the letters 'BNS'; I would like about 8
> numbers after this. Also the numbers have to be unique. I am still a
> novice in Access so if someone can give me a step by step guide it
> would be great!

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
No what you want is a random number (autonumber will generate one) and
then you want to DISPLAY that number with the letters "BNS" in front of it.
Don't bother trying to store the "BNS" in a table as there is no need to.
There are several ways of displaying the BNS depending on where you will
need it.

Note: the user should never see the table directly or enter or edit data
there. They should only see data in forms, reports and maybe queries.
Tables are only buckets of data and a list of field definitions.

--
Joseph Meehan

Dia duit

Thanks, but how do I have the letters in front of the Autonumber???
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
--
Thank you for your help


"Joseph Meehan" wrote:

> Kirt84 wrote:
> > I require a function where Access will generate an Autonumber with
> > each number beginning with the letters 'BNS'; I would like about 8
> > numbers after this. Also the numbers have to be unique. I am still a
> > novice in Access so if someone can give me a step by step guide it
> > would be great!
>
> No what you want is a random number (autonumber will generate one) and
> then you want to DISPLAY that number with the letters "BNS" in front of it.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
> Don't bother trying to store the "BNS" in a table as there is no need to.
> There are several ways of displaying the BNS depending on where you will
> need it.
>
> Note: the user should never see the table directly or enter or edit data
> there. They should only see data in forms, reports and maybe queries.
> Tables are only buckets of data and a list of field definitions.
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>

Control: DisplayNum ControlSource: ="BSN" & Format([IDField],"00000000")
Note you may have to use ';' instead of ',' dependant on the windows
regional setting
& swap [IDField] for the actual Field

Pieter

"Kirt84" wrote in message
news:555BEA73-3687-4460-A984-B91282EE6771@microsoft.com...
> Thanks, but how do I have the letters in front of the Autonumber???
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
> --
> Thank you for your help
>
>
> "Joseph Meehan" wrote:
>
>> Kirt84 wrote:
>> > I require a function where Access will generate an Autonumber with
>> > each number beginning with the letters 'BNS'; I would like about 8
>> > numbers after this. Also the numbers have to be unique. I am still a
>> > novice in Access so if someone can give me a step by step guide it
>> > would be great!
>>
>> No what you want is a random number (autonumber will generate one)
>> and
>> then you want to DISPLAY that number with the letters "BNS" in front of
>> it.
>> Don't bother trying to store the "BNS" in a table as there is no need to.
>> There are several ways of displaying the BNS depending on where you will
>> need it.
>>
>> Note: the user should never see the table directly or enter or edit
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
>> data
>> there. They should only see data in forms, reports and maybe queries.
>> Tables are only buckets of data and a list of field definitions.
>>
>> --
>> Joseph Meehan
>>
>> Dia duit
>>
>>
>>

--------------------------------------------------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4382 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!