Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2008

Tip: Looking for answers? Try searching our database.

active / retired auto update

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ed - 29 Mar 2008 05:50 GMT
I'm involed with an organization that I have a data base of names with
addresses and other info. I have an Yes/No check mark for if a member is
active. I would like to generate a "Roll Call Form" with current active
members.This would be a simple list of active members on the date of a
meeting and some other info. I also need to have the active listing stay with
that date and not change when a member goes inactive. I'm a novice to Access
so take it easy on me. Thanks
Signature

Newbie trying but not succesfull

Albert D. Kallal - 29 Mar 2008 07:05 GMT
I think this simple solution in this case is to simply build a query that
uses a date range for the meeting.

simply don't use the active, inactive flag for this report, but only enter a
given date range of the people you want for a particular meeting.

if you're going to generate a list of the active members, then you're not
likely including meeting information, and even if you do that's a different
report any way. this report most certainly will have a query that includes
true or false for the active "member" field.

Of course the only detail here is we don't know how your meeting database is
setup. However, I shall assume you have a master table of members, and then
you have a child table that lists each members meetings + date they
attended.

The report to show who attended a meeting will not use the active/inactive
flag, and simply only query by a date range (or single date) to produce the
list of members who attended a given meeting.

The two reports are different, and the active, inactive field setting can be
ignored for the attendance report.

Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Ed - 29 Mar 2008 07:57 GMT
Thanks Kallal
I understand using a query to come up with active members and to use a date
query to find a paticular meeting. But what I forgot to post in my original
post is in the "roll call form" I will need to check off active members
present and keep that info with that table.
Signature

Newbie trying but not succesfull

> I'm involed with an organization that I have a data base of names with
> addresses and other info. I have an Yes/No check mark for if a member is
[quoted text clipped - 3 lines]
> that date and not change when a member goes inactive. I'm a novice to Access
> so take it easy on me. Thanks
Rob Parker - 29 Mar 2008 09:03 GMT
Hi Ed,

You haven't given any details of your tables and their fields.  To
accomplish what you want, you must have a field that records the date at
which the membership becomes inactive.  Unless/until you do so, what you are
asking cannot be done.  If you do have such a field, then it's simple (or
maybe not, if you're a beginner) to set up a query to do what you want.

HTH,

Rob

> Thanks Kallal
> I understand using a query to come up with active members and to use a
[quoted text clipped - 13 lines]
>> Access
>> so take it easy on me. Thanks
Rob Parker - 29 Mar 2008 09:30 GMT
And a little more ...

My previous post assumed that a member starts as active, then becomes
inactive.  However, if the real-life situation is more complicated than this
(ie. members can change from active to inactive, and back to active), then
you will need a separate table to record each change of membership status
(with fields for Member ID, Status, and StatusDate).  With that, you can
then write a custom function to return the membership status at any date.

Rob

> Hi Ed,
>
[quoted text clipped - 26 lines]
>>> Access
>>> so take it easy on me. Thanks
Bob Quintal - 29 Mar 2008 11:51 GMT
> Thanks Kallal
> I understand using a query to come up with active members and to
> use a date query to find a paticular meeting. But what I forgot to
> post in my original post is in the "roll call form" I will need to
> check off active members present and keep that info with that
> table.

You will need a separate table to store meeting attendances. Instead of
storing the tickbox in the members table, you add the member's ID and
the date of the meeting in this new table, triggered by checking the
tickbox on the rollcall form. You can keep the Active tickbox in the
members table, and use it only to filter which members to show on the
rollcall form.

Signature

Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.