How to assign Pop Up Calendar Reminder within Workgroup

[JoanOC]

Workgroup is Pier to Pier that consists of 8 individuals with my Access being
the main one.
I have a great Reminder Pop Up Calendar that the other in the law firm would
like on each of their computers.
They access my Access that is where all the data entry is done. I have
created macros so they are able to click on a command and see/work on only
their cases (law firm).
Now they want some way to use the Reminder/Tickler PopUp Calendar that I use.
Please Help.

 

[NetworkTrade]

I know this isn't a reply that you want; but one would normally consider
using Outlook for group calendar stuff - - that is what it is made to do....
no sense re-inventing the wheel...

But concerning your situation; you need to split the database...and give
each one their own copy of the Front End (they each must have an Access
license of course)...

For it to only show their cases - you would need to tweak each front end
separately...not sure how you do it via query, filter or what...but whatever
you use just needs to be tweaked for each...

 

[Tom Wickerath]

Hi NTC,

Each user does not need a licensed copy of Access installed if the developer
(Joan) chooses to distribute the Access run-time. This would require her to
have the appropriate developer's version, in order to have the rights to
distribute the runtime. See this link for more information:

http://www.granite.ab.ca/access/developereditionversions.htm

For it to only show their cases - you would need to tweak each front end
separately...

You can use either the built-in User Level Security (ULS) with the
CurrentUser function, or the user's NT UserID to stamp each record with
ownership information. Here is code to grab the user's NT UserID:

http://www.mvps.org/access/api/api0008.htm


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[NetworkTrade]

of course true, she seemed like an end user in an office with co-workers
and didn't sound like a developer - - so the thought didn't occur to me....