资产升级表 [英] Asset Upgrade Form

问题描述

您好，我是创建具有访问权限的数据库的新手。

我正在使用Access 2003并创建了一个资产跟踪数据库。

我有一个表单用主键作为资产ID＃输入资产信息表单我想添加一个按钮来打开升级表单。在升级表单上，我希望资产ID＃字段自动填入按钮所在表单上的字段。有任何想法吗？我认为这可能比我做的更容易。任何帮助将不胜感激。


谢谢，

Cr @ sh

解决方案

< blockquote class =post_quotes>
您好，我是创建具有访问权限的数据库的新手。

我正在使用Access 2003并创建了一个资产跟踪数据库。

我有一个表单用主键作为资产ID＃输入资产信息表单我想添加一个按钮来打开升级表单。在升级表单上，我希望资产ID＃字段自动填入按钮所在表单上的字段。有任何想法吗？我认为这可能比我做的更容易。任何帮助将不胜感激。


谢谢，

Cr @ sh

假设带有按钮的表单称为frmTracking，包含要携带的ID的文本框是txtAssetID，升级表单上的文本框也称为txtAssetID，然后打开第二个表单并从第一个表单中继承资产ID ：

展开 | 选择 | Wrap | 行号

假设带有按钮的表单被称为frmTracking和文本B.包含要携带的ID的牛是txtAssetID，升级表单上的文本框也称为txtAssetID，然后打开第二个表格并从第一个表格中继承资产ID：

展开 | 选择 | Wrap | 行号

我的错误...这实际上给出了运行时错误2448

你不能指定一个值对象是一个文本框，表中的字段是一个长整数


这就产生了错误...


Private Sub Form_Open（取消为整数）

我！[AssetID] =表格！[frmAssetInfo]！[AssetID]

结束子


表中的字段是一个长整数...尝试将其更改为文本而没有帮助......

Hello, I am fairly new to creating databases with access.
I am using Access 2003 and have created an Asset tracking database.
I have a form to enter the asset information with the primary key as the asset ID#, on this form I would like to add a button to open an upgrade form. On the upgrade form I would like to have the Asset ID# field automatically filled in with the one on the form that the button resides. Any ideas? I think that this probably easier than I am making it. Any help would be greatly appreciated.

Thanks,
Cr@sh

解决方案

Hello, I am fairly new to creating databases with access.
I am using Access 2003 and have created an Asset tracking database.
I have a form to enter the asset information with the primary key as the asset ID#, on this form I would like to add a button to open an upgrade form. On the upgrade form I would like to have the Asset ID# field automatically filled in with the one on the form that the button resides. Any ideas? I think that this probably easier than I am making it. Any help would be greatly appreciated.

Thanks,
Cr@sh

Assuming the Form with the button is called frmTracking, and the Text Box containing the ID to carry over is txtAssetID, and the Text Box on the Upgrade Form is also called txtAssetID, then to open the 2nd Form and carry over the Asset ID from the 1st Form:

Expand|Select|Wrap|Line Numbers

Assuming the Form with the button is called frmTracking, and the Text Box containing the ID to carry over is txtAssetID, and the Text Box on the Upgrade Form is also called txtAssetID, then to open the 2nd Form and carry over the Asset ID from the 1st Form:

Expand|Select|Wrap|Line Numbers

My mistake ... this is actually giving a runtime error 2448
You can''t assign a value to this object...The object is a text box the field in the table is a longinteger

This is producing the error...

Private Sub Form_Open(Cancel As Integer)
Me![AssetID] = Forms![frmAssetInfo]![AssetID]
End Sub

The field in the table is a long integer...Tried changing it to text and no help...

这篇关于资产升级表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！