automating reference numbers

[gpurger]

I have a form (created from existing xl and word tables)that records memos etc. Each new memo is given a reference number in the format: Project Name (this is constant)/year (i.e. 2005) /C+number(restarts at one every year). example: Project/2005/C001.
To complicate things the user can add extra info to the reference number.
Is there a simple way of making this automatic.
To possibly make things harder I have over 800 entries already and the ref num is stored as a single string.

Cheers and a happy new year to you all,

Gordon

 

[BLeslie88]

yes of course

all it takes is willingness to code it and implement it...

str1
pr for project

str2
date format extract the 05 from it

str3
c & 'concatenate ' an autonumber which would movelast .
str3 = right(fldFileName,3)
str3 = cint(str3)

then str1 & str2 & str3

voila.. and if the pesky users want to add descr info, let them have a descr field in the table!

 

[gpurger]

Sorry fo the delay been away but can go home at weekends if I behave.

The problem was not ot remove the 05 but add it automatically and also increment it yearly. I do not know why I do as I am asked.

Cheers


Gordon