How to create pop up reminders

I need to know how I can create pop up reminders based on if a query has data or not. I need this reminder to show when the database is opened if the query has any data in the fields.

Sponsored Links:

Related Topics

Calendar Entries
I need to create a database for a call centre. In this database, I need to be able to create a "calendar form" in which I can add / edit and delete entries

It must look similar to Outlook's calendar where you can dbl click and enter "to-do tasks, and memo's into the calendar"

It must also be able to print each days tasks, for the day, week, month,etc and able to have 'reminders' which pop up for reminders...


Reminders/Appointments/logins etc.
Basically I have the following issues to resolve;

1. A reminder system. A constant recurring reminder, the time period of which can be adjusted by the user to suit the situation of the client. I.e. for a hot lead, the user would choose "one week" reminders, and then if this lead went cold, they could change this in a form to "three month" reminders.

Values could either be based on the 1st contact date entry, or the actual date of modification by user.

2. Whether the best way to do this is linking in to outlook or by creating a login form for each user, with pop up alerts for each client?

3. I wish to create a sales in progress form that will auto-complete fields from the "vendors" table, and the "clients" table, plus also add a couple more data entry boxes (such as agreed price), all of which would save as a record in the "Sales in Progress" table.


Access to Outlook Calendar for Alert or Alarm Message Reminders
I'm using MS XP. Can a Date I enter into my Access db automatically be sent to MS Outlook Calendar so I receive a pop-up message reminding me of the appointment? If so, how?


pop-up that asks a question
I would like to create pop-ups that respond to options that are chosen. For | example, I have a form with a drop down for yes/no.
want to be able give the user as option to chose whether radiation was | completed or not. I know how to connect the main form to a subform and have | the subform pop up, but I don't want the whole subform to pop-up -- only one |


Can not close pop up form after second pop was opened
I have a pop up form which opens another pop up form.
I wish to close them both afterwards.

I open the second pop up with acdialog and after that I placed
a docmd command to close the form.

I get the error: "The action can not be carried out while processing form or report 2285".

How can I solve it ?


Reminders In Outlook - almost working
I am using the following code to send reminders to outllook using acess:

Function AddOutLookTask() Dim appOutLook As Outlook.Application Dim taskOutLook As Outlook.TaskItem Set appOutLook = CreateObject("Outlook.Application") Set taskOutLook = appOutLook.CreateItem(olTaskItem) With taskOutLook .Subject = "This is the subject of my task" .Body = "This is the body of my task." .ReminderSet = True .ReminderTime = DateAdd("n", 2, Now) ' Set to remind us 2 ' minutes from now. .DueDate = DateAdd("n", 5, Now) ' Set the due date to ' 5 minutes from now. .ReminderPlaySound = True 'add the path to a .wav file on your computer. .ReminderSoundFile = "C:\Win95\media\ding.wav" .Save End With End Function

This is working fine, however, I would like to be able to change this code so that the SUBJECT, BODY, AND DATE AND TIME of the task / reminder comes from data entered in the Reminders Form, how would I do this


Access duplicate records pop up
I need to add a pop up message to prevent duplicate records. I was able to create a simple pop up (see below) which works; but I need the dlookup to check an additional field before it pops up.

So in total I need the dlookup for 1. ID (done), and 2. From (this is the Date in the Form).


Custom Ribbon for Pop Up Form
I have a custom ribbon attached to my main menu. I decided to change it to a pop-up form and the custom ribbon doesn't display. Is there something special about the ribbon for pop-ups, or is it not possible to create a custom ribbon for a pop-up form.


Using ListBox value as "Body of outlook task"
Using ListBox value as "Body of outlook task"

I have inserted an "add outlook reminder" button to my database, this is working perfectly. Now, I would like the "body" of the outlook task to get its data from a list box on my reminders form

it is currently getting the "body" from a text box on the reminders form, which works fine, but instead of the user entering the body, I would like the body to populate from alistbox (not a selected item in the list box, just every record in the listbox)


Pop up won't stop popping up
I created a form and initially though I would want it to be a pop up form, so I set the Pop Up property to yes. After testing it for a bit I decided it would be better as a tabbed form so I set the pop up property to No, but the form still pop's up when I open it. I've closed the db and reopened it, checked the property settings all to no avail. Anyone have any thoughts? Access


Maintenance reminders using email
What I need now is a way to have the database sift through the records, select records that have suggested repairs attached to them and sendone email to each client with a tabular list in the body of the email displaying the suggested repair table entries pertaining to that client.

The configuration for this is a main form with just the customer information attached to it, then a subform that records the maintenance history for that customer and a second subform that records "suggested repairs", all connected through the "ID" field on each form.

I'm looking for a command button that will send these email reminders in one click,

Is there a way to set up a mass email this way?


Using ListBox value as "Body of outlook task"
Using ListBox value as "Body of outlook task"

I have inserted an "add outlook reminder" button to my database, this is working perfectly. Now, I would like the "body" of the outlook task to get its data from a list box on my reminders form

it is currently getting the "body" from a text box on the reminders form, which works fine, but instead of the user entering the body, I would like the body to populate from a listbox (not a selected item in the list box, just every record in the listbox


pop out message!!
how to do the pop out message when user log in? IN my case, if there have pending leave require to approve the message box will pop out once user log in the system. but I dunno how write the code to link the pending leave data in the table with the pop put message?Anyone can


Trouble opening a pop-up form
I have a form with a field for "Account Number" and would like to have a form pop up when you click on the number in the field.

I figured out how to use a macro to open the pop-up form when you double click the field, but all of the records pop up. I would like for only the records that are linked to the account number that was clicked to be returned.

I need to know what to enter in Filter name and Condition so that only the specific records will be included in the pop up.


form and pop form saving to different records
I have created a database which 4 forms (1 main form, and 3 pop up).
In the main form, after the CutSize field has been populated through a combo box, one of the three pop-ups pop up depending on the value of the Cutsize field. The user then enters information in the pop up, that should be saved on the same record with the information from the main form.

problem: the information is saving to consecutive records, not hte same one.
the pop up saves to one record, then the main form to the record after.

is there a way to have both forms save to the same record. perhaps my database design is faulty, but I have deadlines that I must meet coming up rather quickly


form and pop form saving to different records
I have created a database which 4 forms (1 main form, and 3 pop up). In the main form, after the CutSize field has been populated through a combo box, one of the three pop-ups pop up depending on the value of the Cutsize field. The user then enters information in the pop up, that should be saved on the same record with the information from the main form.

problem: the information is saving to consecutive records, not the same one. the pop up saves to one record, then the main form to the record after.

is there a way to have both forms save to the same record. perhaps my database design is faulty, but I have deadlines that I must meet coming up rather quickly.


Pop up form not showing
I have a form an when I select it to be a pop up it doesn't’t open. It did not always do this. I had to delete all the tables an reimport them from excel. Ever since then it gives me this problem.

I was able to get it back to pop up once then I had to go fix an error an then since then I had that problem. Why is this? How do I fix?


Custom button for Built-in Filter pop-up
I would like to be able to access the built-in Filter pop-up dialog box that you can get by clicking in the control/field that you want to filter on the report and then clicking on the filter icon in the ribbon.

I would like to be able to create a custom button that would bring up this built-in pop-up box when you click it.


Minimize a Pop Up Form?
Access 2010
Windows 7 (Fully Updated)

I have a Pop up form that is used to get user input in two fields. [StartDate] and [EndDate].
The form must remain open for these 2 Parameters to be used in subsequent Queries.
I am still developing this application and testing the Queries and Macros.
The Pop Up Form is constantly in the way when working on other items.
Is there a way to minimize a Pop Up Form so that is still active but not in the way.
I have looked through all the Tabs in the Property Sheet for this Form but cannot identify one that would allow me to Minimize the Form in a Macro after I have obtained the User Input.


Macro Msgbox
I need some urgent help.

I need to create a pop-up text box that requires me to display the data of a certain field.

for example, I have a form that allows me to update these particulars:

- name
- address

and after manually typing in the details, I would have to click on a command button that creates this pop-up msgbox that displays "hello, (name)! you live at (address)."

i've applied the macro msgbox function. however I was stuck for a long time at the message part! how can I put name and address field into the actual pop-up box