问题描述
晚上好我有一个数据库，其中我有一个命令按钮，当按下时，我想看到前一个记录/字段的值，然后加1。我从来没有构建过一个代码，我不得不向后看一部分方程式给我的价值。以下是我正在玩的内容，看看我是否可以在没有帮助的情况下使用它，但是我无法让它向后看部分价值。
应该， acLast，Me.DRAWING_NO> = 105999 ,, acNewRec，Me.DRAWING_NO = 106000
应该，acLast，Me.DRAWING_NO = Me.DRAWING_NO< = 106000 ,, acNewRec，Me.DRAWING_NO = Me .DRAWING_NO + 1
任何帮助都会很感激。
Lloyd
Good evening I have a database where I a command button that when pressed I wan to see the value from the previous record/field and then add 1 to it. I have never built a code where I had to look backwards for part of the equations to give me the value. Below is what I was playing with just to see if I could get it to work with out help, but I can not get it to look backwards for part of the value.
Should , acLast, Me.DRAWING_NO >= 105999, , acNewRec, Me.DRAWING_NO = 106000
Should , acLast, Me.DRAWING_NO = Me.DRAWING_NO <= 106000, , acNewRec, Me.DRAWING_NO = Me.DRAWING_NO + 1
I would be happy using auto number if I knew how to reset the first number it puts out instead of it being 1 I need it to start out at 10600.
Any help would be thankful.
Lloyd
推荐答案
这篇关于自动编号数据库中的特定字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！