generate random number

#1 (**permalink**) 28-Jul-2006, 08:42 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14029-generate-random-number.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
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!
--
Thank you for your help

*

#2 (**permalink**) 28-Jul-2006, 08:42 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
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

#3 (**permalink**) 28-Jul-2006, 08:42 AM

Thanks, but how do I have the letters in front of the Autonumber???
--
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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
>
> Note: the user should never see the table directly or enter or edit data
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
> 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
>
>
>

#4 (**permalink**) 28-Jul-2006, 08:42 AM

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???
> --
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14029
>> > 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
>> 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!