问题描述
首先，提前感谢所提供的任何帮助！我在Microsoft Access 2007中使用由不再与公司合作开发的数据库。
我正在处理的数据库是为使用特定SKU /标识号输入的部件而设计的，并且在单独的计算机上运行。最初的开发人员为SKU号码设定了一个起点，但它的使用已经超出了原来的意图。我被要求在表单中添加代码，以便可以在每台计算机上设置一个范围，以防止在将数据编译到中央计算机时出现重复。我输入了以下代码来设置范围和功能但是一旦满足范围，你必须单击okay按钮16次才能返回到表格。任何帮助将不胜感激。
First, thanks in advance for any assistance given! I''m working in Microsoft Access 2007 on a data base developed by someone no longer with the company.
The database I''m working on is designed for parts to be entered with a specific SKU/Identification number and is running on seperate computers. The original developer set a starting point for the SKU number that works but its usage has grown beyond its original intentions. I was asked to add code into the form so a range could be set on each computer as to prevent duplicates when the data is compiled to a central computer. I entered the following code which sets up the range and functions but once the range is met you have to click the okay button 16 times to return to the form. Any help would be greatly appreciated.
推荐答案
这篇关于从MsgBox返回到Form Stalling的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！