我需要一个类似于Microsoft自定义快速访问工具栏对话框的解决方案 [英] I need a solution similar to the Microsoft Customize Quick Access Toolbar dialog

问题描述

大家好，


我需要一个类似于Microsoft Customize Quick Access Toolbar对话框的解决方案。从一侧选择项目的地方|单击添加，所选项目将复制到所选项目列表/框中。重复此过程，直到选中所有适用的项目。然后单击确定，将所选项目（PrimaryID）复制/添加到表/查询中。

Hello all,

I need a solution similar to the Microsoft Customize Quick Access Toolbar dialog. Where you select the item from one side | Click Add and the selected item is copied to the selected item list/box. You repeat the process until all items that apply are selected. Then Click OK and the selected items (PrimaryID) are copied/added to a table/query.

推荐答案

您的问题太模糊，无法回答。这些项目是什么？他们来自哪里？他们是否从桌子上看出来的价值？


我附上了我认为你正在寻找的东西，其中有一个船型的表格，所选择的是在右侧列表框和一些，未在左侧框中选中。


他们通过使用箭头或双击船的类型在箱子之间移动


Phil

Your question is too vague to answer. Wha are these "Items"? Where do they come from? Are they values from a table?

I have attached what I think you mat be looking for where there is a table of boat types and the selected ones are in the right hand listbox and the ones, not selected in the left hand box.

They are moved between the boxes by either using the arrows or double clicking the type of boat

Phil

很抱歉，它在我的脑海里非常有意义，奇怪的是你已经指出了它！与设备可用 - 设备选择的例子。

这正是我想要的！这里有更多细节。 。 。


我有一个数据库，可以跟踪每个成员访问和每天请求的服务。


表和主要字段名称

MemberService - MSID-PK;帐号＃，MemberFName，

MemberLName，SignInDate，SignInTime，EmpID-FK，PSID-FK

员工 - EmpID-PK; EmpFName，EmpLName，Depart。 。 。

ProdServ - PSID- PK; ProductName，ServiceName，Description

PK =主键和FK =外键


步骤＃1：成员走进并在dataEntry表单上登录 - 数据直接发送到MemberService表。

步骤2：员工向该成员提供服务。会员只需要一项服务，即重置密码

步骤3：员工滚动列表75并选择重置密码。来自ProdServ表

点击提交 - 完成！ - 所选服务的主键填充在MemberService表中。稍后我将生成不同的查询。


但是，如果成员在当前会话期间需要多个服务。 。 。

我希望员工能够选择所有适用的选项，并实际看到所选的服务。（如你的例子）或

点击确定，显示所选服务在表格的某个地方。点，员工需要查看他们为WrapUp选择的内容。


PSID密钥填充在PSID-FK字段的MemberService表中，即（34,44） ，75）

但是，当我运行我的查询时，它将显示像列表框一样的服务SName.value

PSID 34 | ServiceName |重置密码

PSID 44 | ServiceName |更新姓名，地址和电子邮件

PSID 75 | ServiceName |副本，传真


我尝试使用MS Access Listbox - 但遇到了悲观锁定的事情。这是一个问题，因为数据库将被共享。无法获得乐观锁定。所以，我正在向社区寻求帮助！


如果无法将所有选定的服务添加到一个字段中 - 然后解析每个服务以查询或报告---

他们可以拥有自己的记录（MSID-PK）。我们需要将MSID，帐号＃和memberName复制到每个新记录中，以显示它是一次访问。


我刚学会了规范化的重要性，我正试图变暖与多对多关系模糊;这个数据库的结果会告诉你。我希望这能更好地展示我想要实现的目标。


最终结果：显示按日期和员工分组的服务计数的查询＃


会员名称（First& Last Concatenated）;帐号;服务，SignInDate，SignInTime，Emp＃


这是我的第一篇文章，提前感谢您的帮助。哦!我可以提供照片和我所拥有的样本。 。 。如果那没关系。

So sorry, it made so much sense in my mind and strangely YOU NAILED IT! with Equipment Avail - Equipment Selected example.
That is exactly what I want! Here are more details. . .

I have a database that tracks the each members visit and requested service per day.

Tables and major field names
MemberService – MSID-PK; Account#, MemberFName,
MemberLName, SignInDate, SignInTime, EmpID-FK, PSID-FK
Employee – EmpID-PK; EmpFName, EmpLName, Depart . . .
ProdServ – PSID- PK; ProductName, ServiceName, Description
PK = Primary Key and FK = Foreign Key

Step #1: A member walks in and SignIn on a dataEntry form - that data goes straight to the MemberService Table.
Step #2: An employee provides a service(s) to that member. The member only wants one service i.e. Reset password
Step #3: The employee scrolls through a list of 75 and selects "Reset Password" from the ProdServ table
Click Submit - Done! - The Primary Key of the selected service is populated in the MemberService table. I will generate different queries from that later.

However, if the member wants multiple services during the current session . . .
I would like the employee to be able to select all that applies and actually see the services selected.(like your example) Or
Click OK and the selected services are displayed somewhere on the form. Point, the employee will need to see what they selected for the WrapUp.

The PSID key(s) is populated in the MemberService table in the PSID-FK field i.e.(34, 44, 75)
However when I run my query it will display the services like a List Box SName.value
PSID 34| ServiceName | Reset password
PSID 44| ServiceName | Update name, address and email
PSID 75| ServiceName | Copies, Fax

I tried using MS Access Listbox - but ran into the pessimistic locking thing. That''s a problem because the database will be shared. Could not get Optimistic locking to work either. So, I''m reaching out to the community for HElp!

If it''s not possible to add all selected services into one field - and then parse each service for a query or report ---
they can have their own record (MSID-PK). We would need to copy the MSID, account# and memberName to each new record to show it was one visit.

I have just learned the importance of normalization and I am trying to get warm and fuzzy with many to many relationship; the results of this database will tell. I hope this provides a better picture of what I''m trying to achieve.

End result: Query showing the Count of services grouped by Date and Employee#

Member Name (First&Last Concatenated); Account Number; Service, SignInDate, SignInTime, Emp#

This is my first post, thanks in advance for your help. Oh! I can provide pics and a sample of what I have . . . if that''s okay.

很好，至少我理解这个问题......在多用户情况下解决它会更加棘手。

您是否有某种表来显示哪些用户已登录。这与您的员工表相同吗？我们需要知道哪个用户从ProdServ表中做出了哪些选择。

不幸的是，我发布的示例中的简单设置仅适用于单个用户，只需要一个名为Selected的字段即可。设备表（您的ProdServ表）中的（True / False）但是不同的用户更改了已选择的值。那不行。


我怀疑答案是将一个连接表加入用户（员工？）到ProdServ表。


Phil

Great, well at least I understand the problem ... solving it is much more tricky in a multi-user situation.
Do you have some sort of table to show which users are logged on. Is this the same as your Employee table? We will need to know which user has made which selection(s) from the ProdServ table.
Unfortunately, the simple setup in the example I posted works for a single user by simply having a field called "Selected" (True/False) in the Equipment table (your ProdServ table) but with different users changing the value of "Selected" that won''t work.

I suspect the answer will be to have a join table joining the User (Employee?) to the ProdServ table.

Phil

这篇关于我需要一个类似于Microsoft自定义快速访问工具栏对话框的解决方案的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！