How to implement automatic numbers in "Default" in "Default"? Documentation generation problem.
Brief description: Documentary production problem
problem:
How to implement automatic numbers in "Default" in "Default"? Documentation generation problem. How to implement automatic numbers in "Default" in "Default"? If I want to achieve different types of automatic numbers, how should I set up code? Such as: No. 1, No. 2, ..........., No. 198 .................. or: CN0001-A, CN0002 -B, cn0003-b, ........., CN0004-A, CN1998-B ... is the code in the default value, or where, please advise, thank you!
Reply:
These requirements do not need to be done in the "table" field properties, generally solved in interface programming. Get numbered with a DCOUNT () or DMAX () function to take the value
Private subfield1_enter () if isnull (field1.value) THEN FIELD1.VALUE = "CN" & format (CLNG (DMAX ("MID (Field1, 3, 4)", "Table1") 1), "0000") & "-A" end ifend sub of course, you must use the "default value" method you must use to change the table in the future, but you feel unnecessary.
Http://access911.net webmaster collection
