通过按cmd在表单中设置查询条件并从该表单运行查询 [英] Setting query criteria in a form and running a query from that form by pressing a cmd
问题描述
大家好。我对访问这个论坛有些新意。希望这将是一次伟大而有益的体验。
我的问题是这个。我有一个数据库（大约65,000条记录）。
我每个月都会以文本格式（记事本）从另一方运行，我将其导入到我的数据库中并进行比较通过运行查询，前几个月和当前月份表（某些字段）。我想要做的是创建一个很好的表单，它将自动导入文件（它每个月都会在本地网络上的文件中更新[相同] name]现在我链接了它，当它改变时我运行一个查询并将表保存为新月）我想自动化它。 （如果可能的话）
b）有一个表格可以让我输入不同的数据（标准），按下cmd按钮后它会为我运行一个查询。 （这是最重要的）我试着去做一些真正疯狂的事情开始发生。
c）将运行导出或保存到特定文件夹和所选名称。 （我不知道是否有可能，再次自动）
无论谁能，请帮忙。所有的建议和帮助都非常感谢。
谢谢
-Arthur
Hello everyone. I am somewhat new to access and this forum. Hopefully it will be a great and helpful experience.
My problem is this. I have a database (about 65,000 records).
I get a run from another party every month in a text format (notepad) which I import into my database and make a comparison between the previous months and current months tables (some fields) by running a query. What I am trying to do is create a nice form that will
a) have an option to import the the file automatically (it gets updated every month in a file on the local network [same name] now I have it linked and when it changes I run a query and save the table as the new month) I want to automate that. (if possible)
b) have a form that will alow me to enter different data (criteria) and after pressing a cmd button it will run a query for me. (This is most important) I tried to do something and something really crazy began to happen.
c) export or save that run to a specific folder and chosen name. (i do not know if it is possible, again automatically)
Whoever can, please help. All advice and help is very much appreciated in advance.
Thanks
-Arthur
推荐答案
顺便说一句，它有点像找人。换句话说，如果我输入许多不同的标准，它将以单独的形式给我结果。如果我输入一个独特的标准，比如Social Sec＃，那么它将提取所有关于那个人的所需信息。非常感谢alll .......... plz帮助:-(
By the way, it is sort of like a Find A Person. In other words, if I enter many different criteria, it will give me the results in a separate form. If I enter a unique criteria, say Social Sec #, then it will pull up all the needed information just about that 1 person. Thank you alll so much..........plz help :-(
大家好。我有点新来访问和这个论坛。希望这将是一次非常有用的体验。
我的问题是这个。我有一个数据库（约65,000条记录）。
我每月都会以文本格式（记事本）从另一方运行，我将其导入到我的数据库中并通过运行查询对前几个月和当前月份表（某些字段）进行比较。我想要的是什么do是创建一个很好的表单，它将自动导入文件（它每个月都会在本地网络[同名]的文件中更新）现在我有了它链接，当它改变时，我运行一个查询并将表保存为新月）我想自动化它。 （如果可能的话）
b）有一个表格可以让我输入不同的数据（标准），按下cmd按钮后它会为我运行一个查询。 （这是最重要的）我试着去做一些真正疯狂的事情开始发生。
c）将运行导出或保存到特定文件夹和所选名称。 （我不知道是否有可能，再次自动）
无论谁能，请帮忙。所有建议和帮助都非常感谢。
谢谢
-Arthur
Hello everyone. I am somewhat new to access and this forum. Hopefully it will be a great and helpful experience.
My problem is this. I have a database (about 65,000 records).
I get a run from another party every month in a text format (notepad) which I import into my database and make a comparison between the previous months and current months tables (some fields) by running a query. What I am trying to do is create a nice form that will
a) have an option to import the the file automatically (it gets updated every month in a file on the local network [same name] now I have it linked and when it changes I run a query and save the table as the new month) I want to automate that. (if possible)
b) have a form that will alow me to enter different data (criteria) and after pressing a cmd button it will run a query for me. (This is most important) I tried to do something and something really crazy began to happen.
c) export or save that run to a specific folder and chosen name. (i do not know if it is possible, again automatically)
Whoever can, please help. All advice and help is very much appreciated in advance.
Thanks
-Arthur
a）有一个选项可以自动导入文件（它每个月都会在本地网络[同名]的文件中更新现在我拥有它链接，当它改变时，我运行一个查询并将表保存为新月）我想自动化它。 （如果可能的话）
a) have an option to import the the file automatically (it gets updated every month in a file on the local network [same name] now I have it linked and when it changes I run a query and save the table as the new month) I want to automate that. (if possible)
下次导入文件时，单击向导中的高级选项卡并保存导入规范文件（记住名称）。
然后你可以在命令按钮后面编写以下代码
When you import the file next click on the advanced tab in the wizard and save an import specification file (remember the name).
Then you can code the following behind a command button
谢谢你的帮助。 :-)
虽然我仍然很丢失，但我需要将表单链接到一个查询，而不是我在查询的设计视图中输入标准，我可以使用输入文本框以输入条件并单击cmd按钮搜索按钮并且查询将运行。我正在创建一个更加用户友好的环境，以便除了我以外的人可以在工作中使用它而不需要知道多少访问权限。我认为这对他们非常有帮助和有益。所以基本上我的查询非常复杂。它有很多标准（虽然我只需要将标准链接到表单文本框的基本方法，然后创建一个运行查询的按钮。其余的我希望我能弄明白。
谢谢
Thank you for the help.! :-)
Although I am still quite lost, I need the form to be linked to a query where instead of me entering criteria into the design view of a query, I can use the input text boxes to enter the criteria and click a cmd button "Search" and the query will run. I am creating a more user friendly environment so that people other than me can use this at work without knowing much abouit access. I think it would be very helpful and beneficial to them. So basically my query is quite complicated. It has many criteria (although I just need the basic way to link the criteria into a forms text box and create a button that will run the query. the rest I hope I will figure out.
Thanks
这篇关于通过按cmd在表单中设置查询条件并从该表单运行查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
