var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Autonumber Custom Format
Hi all.......I'M Using Ms Access to develope a db...which I want to set an
autonumber format like this "FAMAOR-YY-XXXXX"....The YY = Year and
the xxxxx = autonumber...and the example of generate autonumber
should be like this "FAMAOR0200001".....can anybody
tell me how to do this
You could have another text field in the table that has a default value of "FAMAOR"+Format(Date(),"yy").
Then concatenate both in a query to achieve the format that you want.
Hello ROCKy......Thanx for reply but can tell a little bit more on how to
do this coz I'm kindda new in this whole db thing......may god bless you for your help
Last edited by Rockey; 02-02-04 at 20:07.