I have a form called frmScheduledMeetings. On this form are three listboxes. lstMeetings is a list of meetings that have been scheduled for the year. lstMeetingDate is the the list of dates that the meeting will take place (some meetings are scheduled a few times a year). lstAttendees lists all clients who will be attending the meeting. When a user click on a meeting in lstMeetings, all the dates that this meeting is scheduled to take place will appear in the lstMeetingDate listbox. When a user select a date from the lstMeetingDate listbox, the lstAttendees will get filled in with clients (clientid) who has signed up to attend meeting XYZ on date mm/dd/yyyy. For each meeting, a staff maintains separate notes for the group as a whole as well as for each individual client. Occasionally though, there is a group note that the staff would like to be shared by all who attended that session. When a user double clicked on a selected date on lstMeetingDate, a blank frmGroupNote form will open. What I would like to know is, what is the best way to copy a group note which has been deemed as
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Run an append query and iterating down a listbox (Access2K)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Run an append query and iterating down a listbox (Access2K)
- This topic has 7 replies, 2 voices, and was last updated 20 years, 4 months ago.
AuthorTopicWSkucingtidur
AskWoody LoungerFebruary 7, 2005 at 2:33 pm #415574Viewing 0 reply threadsAuthorReplies-
WSHansV
AskWoody Lounger -
WSkucingtidur
AskWoody LoungerFebruary 7, 2005 at 3:06 pm #927185i have wondered about this too. but the the users are of the opinion that it is important to them to be able to copy the notes. for e.g. sometimes a participant will say something that the clinician think it is important for all attendees to share and keep in their notes. and you are right, the group note as well as the client note will be edited separately afterwards too.
-
WSHansV
AskWoody LoungerFebruary 7, 2005 at 3:37 pm #927192You can create a query based on TblGroupNotes and on the record source of lstAttendees. Set the criteria for the NoteID field from TblGroupNotes to the NoteID from frmGroupNote, and make sure that you have the same criteria for the attendees as those used in the record source of lstAttendees.
Change this query into an append query, and specify TblClientNotes as target.
Add Acct, MeetDate, Notes, NoteDate and StaffID from TblGroupNotes to the query grid, as well as ClientID from the record source of lstAttendees. Specify the corresponding fields as target (you only need to specify Note as target for Notes). I assume that NoteID is an AutoNumber field, so you should not include that in the query – Access will populate it automatically. -
WSkucingtidur
AskWoody LoungerFebruary 7, 2005 at 9:14 pm #927264Hello Hans,
I took up your suggestion. It works, somewhat when there is only one person attending a session. If there is more than one person attending the same meeting I get an error message when trying to copy the notes to all clients attending the session. How can run the append query for as many times as there are attendees in the lstAttendees listbox i.e. how can enumerate through the listbox? Am I making sense? I hope I am. -
WSHansV
AskWoody LoungerFebruary 7, 2005 at 9:27 pm #927266 -
WSkucingtidur
AskWoody LoungerFebruary 9, 2005 at 4:06 pm #927654Hello Hans,
The row source type for lstAttendees is Table/Query
The row source is:
SELECT dsdtcmas.clientid, Trim([lastname]) & “, ” & Trim([firstName]) AS ClientName
FROM dsdtcmas INNER JOIN dsdtchgp ON dsdtcmas.clientid = dsdtchgp.clientid
WHERE (((dsdtchgp.meeting)=[Forms]![frmScheduledMeetings]![lstMeetings]) AND ((dsdtchgp.MeetingDate)=[Forms]![frmScheduledMeetings]![lstMeetingDate]))
ORDER BY Trim([lastname]) & “, ” & Trim([firstName]);I was trying to run the append query from the query design grid with both frmScheduledMeetings and frmGroupNotes open. The append query works really well when there is only one person is listed as attending the meeting on the specified date in lstAttendees. When there are more than one attendees, the error message that I get is
-
WSHansV
AskWoody LoungerFebruary 9, 2005 at 7:24 pm #927694Try this as criteria for the ClientID field in tblClientNotes:
In (SELECT dsdtcmas.clientid FROM dsdtcmas INNER JOIN dsdtchgp ON dsdtcmas.clientid = dsdtchgp.clientid WHERE (((dsdtchgp.meeting)=[Forms]![frmScheduledMeetings]![lstMeetings]) AND ((dsdtchgp.MeetingDate)=[Forms]![frmScheduledMeetings]![lstMeetingDate])))
-
-
-
-
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Turn off right-click draw
by
Charles Billow
1 hour, 28 minutes ago -
Introducing ChromeOS M137 to The Stable Channel
by
Alex5723
4 hours, 59 minutes ago -
Brian Wilson (The Beach Boys) R.I.P
by
Alex5723
6 hours, 10 minutes ago -
Master patch listing for June 10, 2025
by
Susan Bradley
6 hours, 36 minutes ago -
Suggestions for New All in One Printer and a Photo Printer Windows 10
by
Win7and10
12 hours, 34 minutes ago -
Purchasing New Printer. Uninstall old Printer Software First?
by
Win7and10
12 hours, 38 minutes ago -
KB5060842 Issue (Minor)
by
AC641
17 hours, 11 minutes ago -
EchoLeak : Zero Click M365 Copilot leak sensitive information
by
Alex5723
19 hours, 43 minutes ago -
24H2 may not be offered June updates
by
Susan Bradley
2 hours, 7 minutes ago -
Acronis : Tracking Chaos RAT’s evolution (Windows, Linux)
by
Alex5723
1 day, 8 hours ago -
June 2025 updates are out
by
Susan Bradley
8 hours, 24 minutes ago -
Mozilla shutting Deep Fake Detector
by
Alex5723
1 day, 23 hours ago -
Windows-Maintenance-Tool (.bat)
by
Alex5723
1 day, 8 hours ago -
Windows 11 Insider Preview build 26200.5641 released to DEV
by
joep517
2 days, 1 hour ago -
Windows 11 Insider Preview build 26120.4250 (24H2) released to BETA
by
joep517
2 days, 1 hour ago -
Install Office 365 Outlook classic on new Win11 machine
by
WSrcull999
2 days, 1 hour ago -
win 10 to win 11 with cpu/mb replacement
by
aquatarkus
1 day, 17 hours ago -
re-install Windows Security
by
CWBillow
2 days, 4 hours ago -
WWDC 2025 Recap: All of Apple’s NEW Features in 10 Minutes!
by
Alex5723
2 days, 8 hours ago -
macOS Tahoe 26
by
Alex5723
2 days, 2 hours ago -
Migrating from win10 to win11, instructions coming?
by
astro46
13 hours, 54 minutes ago -
Device Eligibility for Apple 2026 Operating Systems due this Fall
by
PKCano
1 day, 17 hours ago -
Recommended watching : Mountainhead movie
by
Alex5723
1 day, 18 hours ago -
End of support for Windows 10
by
Old enough to know better
1 day, 1 hour ago -
What goes on inside an LLM
by
Michael Covington
1 day, 12 hours ago -
The risk of remote access
by
Susan Bradley
7 hours, 51 minutes ago -
The cruelest month for many Office users
by
Peter Deegan
20 hours, 3 minutes ago -
Tracking protection and trade-offs in Edge
by
Mary Branscombe
1 day, 22 hours ago -
Supreme Court grants DOGE access to confidential Social Security records
by
Alex5723
3 days, 6 hours ago -
EaseUS Partition Master free 19.6
by
Alex5723
2 days, 7 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.