Clarification of incrementing a numberic portion of a string

[pewilson]

I really want to create a primary key similar to D-1001where part is "text" and the other part is "numberic", but I found an sample code that will give the results that I am after. But I do not fully understand what's going on here.

Private SomeField_AfterUpdate()
Dim StrMax as String
strMax=DMax("FOO","FOOTable&quot
me!HiddenFooCrl = "REC-" &
right(strMax,_
len(strMax)-_
Instr(1,strMax,"-&quot)+1
End Sub

1. Can someone tell how the process works?
2. Is there another method to use that may have more clarity than this?

I appreciate any all the help I can get in trying to comprehend this process.

 

[richardii]

Open the table with the ID you want to change in Design View, and click on the ID field. Type "REC-"& in the Format area. Your data will now display (and note that display only - because if you use VB to access the data it's still a number only) - as you want it. Hope that helps.

 

[Aivars]

Read about functions DMax(), Right(), Len(), Instr() in the help or on sites

http://msdn.microsoft.com/scripting/default.htm?/scripting/VBScript/doc/vsfctLeft.htm

http://msdn.microsoft.com/library/d.../en-us/office97/xhtml/output/F1/D2/S5A0D6.asp

http://msdn.microsoft.com/library/d.../en-us/office97/xhtml/output/F1/D6/S5B249.asp

http://msdn.microsoft.com/library/d.../en-us/office97/xhtml/output/F1/D6/S5B29D.asp

Aivars

 

[pewilson]

Thank you for the help.