Automatic Pop Up Reminders
Jan 21, 2005
Hi
I'm fairly new to Access and databases in general but I have built a great database which I am really pleased with, but I want to be able to have a pop-up reminder which is activated when a date in one of the form fields is reached.
First of all is this technically possible?
If it is could somebody give me an indication of how to go about doing it because I have no idea!
If it is not possible, is there any other way around it?
Thanks in advance for your assistance and the simpler you can keep any advice the better!!
Many thanks
Steve
View Replies
ADVERTISEMENT
Mar 9, 2006
real long shot here.....
Is there any way a record produce a pop up reminder (like tasks do in outlook) ?
I am considering running a database as a kind of WIP log and report but I am trying to avoid having to run two systems (Access to report , A task list in Outlook to remind)
Thanks
View 1 Replies
View Related
Jun 28, 2007
i have searched on this forum but so far am not finding the answer.
i have a database and i would like to have a reminder to events .
i have a form in which we have to indicate the place a person goes to.
i need to set a reminder if the person does not the minimum visits in a month.
we need at least three visits or outings in a month per person. i would the reminder to pop up 10 days before the end of each month.
sorry, i am still learning how to do codes. please help me with codes if you can.
i thank all for your help , i have learnt a lot from this forum that i did not learn in class.
View 2 Replies
View Related
Jun 16, 2005
Hiya guys,
I have just been asked to add a reminder function into a database, I have searced the forum, but not sure what I`m looking for.
When we deal with customers, some times we have to contact them again at a later date.
Is there anyway that we can get a reminder to popup, or send a reminder to a specific email address when a certain date criteria is met ?
obviously the database need to be open ( which is not a problem, as it`ll be used on a daily basis anyway )
Would I need to use querys, macro, VB etc to do this, or is there an in built function in access that I dont know about that could do this automatically.
Thanks in advance for any help.
Max
View 4 Replies
View Related
Jun 30, 2005
How can I go about creating pop up reminders for expired dates in (MS Acess 2003) forms for each record.
For example: Date Renewal = 31/01/2005
I need a pop up reminder popping up a month before the date renewal.
Thanks in advance! :)
View 11 Replies
View Related
Mar 1, 2007
Let me preface this thread by stating I'm an Access noob. However, I am fully capable of using the "search forum" section. Unfortunately, many of the answers given to somewhat similar queries are out of my range of understanding.
Here's what I am looking to do:
I work for a R & D company. My lab receives media and reagents of all sorts with various expiration dates.
We have an Access Database setup for what is in storage and from who... but it's really quite basic.
What I have been asked to look into is:
Is it possible to have Access automatically send an Outlook Reminder or Email based on the expiration date field within the database?
For example:
4 days to expiry of a Tryptic Soy Agar Plate, Outlook sends a reminder to the relevant people with a message that says something like:
Notice
You have <number of days until expiry> days until <item description> Lot # <lot number> expires.
----------
of course, i'm not even sure how to setup the email so it pulls the relevant information. I would be fine with it just sending out an email telling which item expires a set amount of days before.
um..
help please
View 2 Replies
View Related
Sep 10, 2015
I have a database where I have a number of contacts/clients/customers, I want to be able to put a next contact date in a field on a form and for either 1. get a reminder in the access welcome screen when the date is approaching along with the name of contact/client/customer or export that date along with info to an outlook reminder.
View 1 Replies
View Related
Aug 23, 2007
Is there anyway to use Access to run reminders?
I am trying to figure out the easiest way to have a reminder pop-up to run a letter for specific reps that would happen every 3 months.
Thanks for any help on this.
View 1 Replies
View Related
Jul 9, 2014
I am fairly new to Access, but understand it well enough to use it on a daily basis. I just need to know if it's possible to set a reminder in access and how to do it if it is possible.
View 2 Replies
View Related
Feb 25, 2014
In my database, I have a form of reminder.
Query collect all the information about the unfinished business at the base and at the start-up of the base shows form reminders.
The base is splitet into front and back end, and are located on the server. Each user is assigned rights what can be done in the database.
The problem where I am "stuck" is to make the form reminder that can be seen only by those users whose jobs are not completed and not all users of the database. Each user uses his computer with your username and password. I tried to connect to form reminder with this information, but I failed.
View 5 Replies
View Related
Jun 11, 2013
I am in the process of development of a database and one of the functionality that I would like to achieve is a custom ID to become automatic on my 'ADD-CUSTOMER' form (e.g. CID0001 - CID0002) so on an so forth. From my research all I can see in access 2010 is a autonumber which cannot be altered (or at least i don't know how).
View 3 Replies
View Related
May 9, 2005
auto date no problem but just an automatic month ??
any ideas???
View 4 Replies
View Related
Jul 28, 2005
I am tying to create a setup application in access. The setup forms are incorporated in the database application.It has to split my database into a FE and BE so that the corresponding files can be placed in thier corresponding files folders automatically.
Iam doing this because the database has to be exported to a number of remote locations every after two weeks.
Apart from using the Database Splitter, Could there be any Ideas on how i can split and link my database through code.
View 5 Replies
View Related
Oct 2, 2005
I am using DMax function for my custom autonumber
I just realized that when using this in a multi user environment, I am getting duplications.
This field is not the primary key, and I am using this as a group ID and cannot set it to “no duplications”
My form also has a sub form, and when entering the sub form, the main record gets saved automatically.
First I added the following procedure
Private Sub Form_AfterInsert()
If IsNull(Me.OrderNo) Then
Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1
End If
Private Sub cmdSave_Click()
If IsNull(Me.OrderNo) Then
Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1
End If
However, I then realized the after insert function will add the new autonumber to the form. However, it will not saved it to the table until the main record is saved again (which may not happen)
“DoCmd.RunCommand acCmdSaveRecord” doesn’t seems to be working after the “Form_AfterInsert”
Now I moved the code to the “Form_BeforeUpdate” (still testing)
Does anyone have any experience on this problem?
Thank you
Joe
View 6 Replies
View Related
Oct 23, 2006
Hi there,I know very little about Access but been asked to find out if this is possible:On a database we have a date field for when subscription is due, is there any way that if a DirectDebit method of payment has been chosen, when the date of renewal is, access will automatically update the year to the next one?Thank you very muchCathy
View 1 Replies
View Related
Aug 9, 2007
Our small newspaper needs to create a database of subscribers from which we can print labels in what the post office calls "Walk Sort" order, the order in which the mail carrier hand delivers the mail on his route. The number associated with a particular subscriber is not fixed because if another subscriber is added on that mail carriers route, it may fall between two existing entries. So the Walk Sort field needs to automatically renumber up or down when an entry is added or deleted. I will use that field to sort chronologically and print form feed labels.
I've figured out a way to do this in Excel, but I think Access might be a better program to use for this database. My question is, can Access automatically renumber a Walk Sort field if I add or remove entries? If so, how do I set it up to do that?
P.S. I haven't used Access for quite some time, and I wasn't very proficient with it then. :o
View 1 Replies
View Related
Dec 5, 2007
Hello everybody,
I have many front end's (using ACCESS 2007 runtime version) in different terminals. Suppose that from 'terminalA', I am assigning a task to an employee who's using 'terminalB'. The user is already looged on to the program by this time, so I want that 'task' to appear on his terminal without him having to press the 'Refresh' button (that I placed on the form) every time I give him a new task when he's logged on so he could see it. How would I do this?
Thank you very much.
View 3 Replies
View Related
Jan 14, 2008
Hi,
i need to run a specific qry that runs from 5th to 5th of every month to show payments made between the dates. i dont want to fill anything in as these dates are set. can a qry be made to run and retrive the info between 5th of last month & 5th of current month automatically ( by the press of a button ) every month?
many thanks,
NS
View 3 Replies
View Related
Feb 24, 2005
hi i have two tables.
One with Item Data - ITem ID, Item Name and Item Value
On another table, i have transaction data - Transaction ID, Item 1, Item 1 Value, Item 2, Item 2 Value etc.
What i am looking for is a way of when i lookup item 1 and enter it, item 1 value will appear automatically.
Any ideas
View 1 Replies
View Related
Nov 27, 2006
I am creating three columns a,b,c in a table in MS access
When I enter the value of a and b, the value of c should be a+b automatically
Is this possible in MS Access, if yes how?
View 3 Replies
View Related
Dec 4, 2006
I am building an employee performance report database. Part of this report I need to integrate initial and midterm feedback dates. These dates are as such:
The initial is 30 days after supervision started or annual performance report completed
The midterm is 120 after supervision started or annual performance report completed
I'd like to give the supervisor a set month for their feedback completions as a guidline. If they are a few days prior or after the "30 day or 120 day mark" it is not a big deal, so I am just wanting it to automatically calculate the month rather than a specific day. After a performance report is completed the intial and midterm feilds should automatically update to calculate the new feedback dates for the next year.
The most updated dates need to be available for supervisors to print on a master report on all their subordinates. No need to store older dates (unless the performance report has not been completed yet)
Pertinent Info:
Form: Perf_Report
Table: Rater_tbl
Field Name 1: Initial ::: (format = mmmm)
Field Name 2: Midterm ::: (format = mmmm)
Field Name 3: Date of Supervision ::: (format = dd mmm yyyy)
Field Name 4: Report Completion ::: (format = dd mmm yyyy)
View 1 Replies
View Related
Dec 8, 2005
Hi
I have a column which is made up of two parts from the table as follows...
function area .... FINANCE
ID number ... 001, 002, 003 etc
combined together this will make my ID column which should look somehting likie this : FINANCE 001, MARKETING 002 etc
BUT
the problem is that now i need to import some existing data into the tables and it appears as though the existing data has repeating numbers for different function areas
e.g.
FINANCE 001
FINANCE 002
MARKETING 001
MARKETING 002
how would i get this imported into my current table structure?
View 4 Replies
View Related
Jul 1, 2006
Please Could any one help out, i have this Database am building for students in a school, The attached WORLD file respresnt a query in the database. The Position in class and Position in level is suppose to grade the student automatically i.e 1st, 2nd, 3rd, 4th, 5th e.t.c. according to the score in a particular subject in their class and in the level.
I dont know how to go about this, am not even sure if this could be done using the query or i should do it using VBA on the report sheet that i generated from the query.
If any one has any idea on how to go about it please let me know it will be highly appreciated.
David
View 3 Replies
View Related
Jun 27, 2007
i build a query that filter names.
i want that when the user start to write the name he want to find in the query , he will get a list of names that starting with the same letter he wrote
how can i do this thing in access ?
View 3 Replies
View Related
Jun 2, 2005
This is going to be a dumb question for all you Access experts, but how do I insert a field that will automatically display the date that the record was created (not updated, but created)?
Thanks!
View 1 Replies
View Related
Jun 2, 2005
This is going to be a dumb question for all you Access experts, but how do I insert a field that will automatically display the date that the record was created (not updated, but created)?
Thanks!
View 3 Replies
View Related
