Microsoft Access：将数据输入表单 [英] Microsoft Access: Entering Data into Forms

问题描述

目前我有一个数据库，用于控制库存。我有一个通过条形码扫描仪输入数据的表格。它输入运输编号，资产编号和状态。是否有可能只提示一次发货号码，然后我扫描其余的数据，然后当我重新打开表格时扫描另一个发货号码等等。目前我每次都在扫描发货号码。


为任何帮助干杯，

Brethser

Currently i have a database which I use to keep control of stock. I have a form for inputting data via a barcode scanner. It inputs the shipping number, Asset number and Status. Is it possible to only prompt for the shipping number once and then I scan the rest of the data in and then when i reopen the form scan another shipping number in etc. At the moment I am Scanning in the shipping number each time.

Cheers for any help,
Brethser

推荐答案

你可以有一个过程（在表格中）如果你喜欢）扫描发货号码。


一旦完成，下一个代码可以打开表格，通过表格'的OpenArgs参数传递货运编号。


在Form'的Open事件过程中，将Shipping Number控件的.DefaultValue设置为该值。

You could have a process (in a form if you like) which scans in the shipping number.

Once this is accomplished the next code could open the form, passing across the Shipping Number in the form''s OpenArgs parameter.

In the Form''s Open event procedure set the .DefaultValue of the Shipping Number control to that value.

感谢您的帮助但是我害怕我只是在初学阶段，当你说有一个打开表格的过程时，我不明白你的意思。任何例子将不胜感激。再次感谢任何人。

干杯

Brethser

Thank you for your help but i''m afraid i''m only at the beginner stage and i don''t understand what you mean when you say have a process that opens a form. Any examples would be appreciated. Thanks again for any hep.
Cheers
Brethser

我没有这么说。请重新阅读帖子并说明是否/卡住了。


我会知道什么时候可能是合适的例子谢谢。

I didn''t say that. Please reread the post and explain if/where you get stuck.

I will know when an example might be appropriate thank you.

这篇关于Microsoft Access：将数据输入表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！