我现在创建了一个简单的表单，我想在访问时提交 [英] I created simple form now I want to submit on access

问题描述

我用4个文本框(姓名，电话号码，电子邮件，备注)创建了简单表单.
并且还创建2按钮保存并清除，现在清除工作，但是当我想在Access 2007上保存此数据时该怎么办?如果可能的话，请让我知道如何进行编码...

I created Simple form with 4 text box (NAME,Phone Number, Email,Remark)
and also create 2 button save and clear now clear working but when I want to save this data on access 2007 so what to do any ? if possible let me know with out coding if possible ...

推荐答案

您需要使用Office Excel Interop程序集，您可以通过添加引用"在应用程序中引用该程序集(解决方案资源管理器上下文菜单项，然后是窗口)，则来自选项卡".NET"，因为此程序集已放入GAC中.

可从CodeProject中找到的大量文章之一可以指导您:
使用VB.Net导出到Excel [ http://www.codeproject.com/search.aspx?doctypeid=1& q = Access + VB.NET [ ^ ].

这个问题并不是完全不正确的，但是可以大大改善.您应该重新编写它:

如何使用Wikipedia，Google，Bing，CodeProject和StackOverflow.com?"

如果您提出了很好的答案，那么就不需要像您原来的问题了！

祝你好运，

—SA

You need to use Office Excel Interop assembly, which you can reference by your application through "Add Reference" (Solution Explorer context menu item, and then the window), from tab ".NET", because this assembly is put in GAC.

One of the huge number of articles which could walk you through this is this one, from CodeProject:
Export to Excel using VB.Net[^].

But this question is way too redundant. Do you think CodeProject don''t have search capability? Think again:
http://www.codeproject.com/search.aspx?doctypeid=1&q=Access+VB.NET[^].

This question in not completely incorrect, but can be greatly improved. You should have re-formulated it:

"How to use Wikipedia, Google, Bing, CodeProject and StackOverflow.com?"

If you asked and got good Answers, the Questions like your original one would not be needed!

Good luck,

—SA

谢尔盖的回答非常好！

以下是一些有用的链接的集合:
http://msdn.microsoft.com/en-us/library/ms971485.aspx [ ^ ]-推荐！
http://connectionstrings.com/ [ ^ ]
为初学者使用ADO.NET [

Sergey''s answer is very good!

Here is the collection of few useful links:
http://msdn.microsoft.com/en-us/library/ms971485.aspx[^] - recommended!
http://connectionstrings.com/[^]
Using ADO.NET for beginners[^]

这篇关于我现在创建了一个简单的表单，我想在访问时提交的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！