Solved

How to set up a Task - Time reminder pop up form

Posted on 2012-04-09
12
911 Views
Last Modified: 2012-04-17
Hello All-

I have set up some forms and tables in an attemp to accomplish the following;

To create a pop-up reminder form, that remains on the desktop until the "complete" checkbox has been checked.

If the task was not completed on the same day, the pop up will remain until checked "complete" I have a field named "completed by" which will tell me who completed the task, I would like the check box not to be able to be checked until "completed by" is selected first.

Also, if the reminder checkbox is not checked no pop up reminder should be activated.
I repeat, if the “reminder” checkbox is checked a pop up reminder should be activated automatically.

The attached data is a subform to my main form, your help is greatly appreciated...you are my heroes!

Lucy
0
Comment
Question by:lucyLuna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
  • 2
12 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37826346
Why go through all the trouble to reinvent the wheel?

Most of this functionality already exists in MS Outlook.
Tasks
Reminders
Appointments
...et al
0
 
LVL 77

Expert Comment

by:peter57r
ID: 37826543
You cannot have a pop-up message or form within an Access application which will remain visible but let you do other work in the same database.
0
 

Author Comment

by:lucyLuna
ID: 37828956
@Boag2000, Thank you for your response.  

From what I understand there are lots of issues with Access/Outlook reminders, I was trying to stay clear of Outlook if at all possible...if there are no other options, I will have to link to Outlook.

@Peter57r Thanks for responding.
 
That makes sense, how can I set up the pop up reminder to pop up when a task's reminder checkbox has been checked?

Thanks again to both,

Lucy
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37829375
<From what I understand there are lots of issues with Access/Outlook reminders,>
I have never had any issues with outlook reminders...
Please state where you got this info from...?
0
 

Author Comment

by:lucyLuna
ID: 37829492
@boag2000,

Some of the Outlook reminder issues are on this site. Can you offer a workaround for not using Outlook?

All I need the for the pop up form to  say message "this task has not been completed" the message will be driven by the checked "remind" checkbox on the 'to do' task field.

Basically I need VBA code...

Thanks much,

Lucy
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37829649
<Some of the Outlook reminder issues are on this site.>
Please be specific...
This site has "Notification" emails that it sends out...but the site has no "Outlook Reminder" specific functionality...

I am sure will help you with the popup issue
0
 

Author Comment

by:lucyLuna
ID: 37829670
boag2000, I am willing to try Outlook if that is the only option available. Do you have a suggestion of how I may implement it in my design?

Thanks much,

Lucy
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37829807
First lets let Pete handle your "Popup" question...
0
 

Author Comment

by:lucyLuna
ID: 37830632
@boag2000, ok.
0
 
LVL 77

Expert Comment

by:peter57r
ID: 37831399
I think my only point was that what was being requested is not possible, if the user needs to do other actions in the databse..

I think you need to explain how you expect to be using your app.
Are you saying that a user will be working on just one task until it is finished?
Or can they have several un-completed tasks?
Does the task involve ongoing use of the database or is the database just monitoring the progress of external tasks?
0
 

Accepted Solution

by:
lucyLuna earned 0 total points
ID: 37840214
I have finally made my pop up form work...without the connectivity to Outlook.

The process required VBA code which I found on a net search.

I don't know how well this pop up will work in a multi user environment...because my tests are just on my laptop.

Thanks all for your input, but I am going to delete this question.
0
 

Author Closing Comment

by:lucyLuna
ID: 37854995
Because I did not want to use Outlook as a reminder option, I opted for searching and further investigating the possibility of creating a pop up reminder without the use of Outlook, I found what I needed and retro fitted to my requirements.

I don't know how this will work in a multi user environment, and if I have to keep searching for a better solution,but I have got to give my solution a try.

Thanks all
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question