How To Terminate Pop Up Reminder That Has Been Set (check Out)

Dec 3, 2012

How to terminate reminders. I have made borrowing system and it will have date taken and date return..

For now, my pop up reminder will pop up in a week before the date return.

My problem right now is if the user return the cd early than the actual date return, the reminder will still pop up. it is because, i have no function to check out the cd..

How to make the check out and also can disable the reminder if i click the check out for that borrowing.

View Replies


ADVERTISEMENT

General :: How To Terminate Pop Up Reminder That Has Been Set

Dec 3, 2012

how to terminate reminders.i have made borrowing system and it will have date taken and date return..for now, my pop up reminder will pop up in a week before the date return.

my problem right now is if the user return the cd early than the actual date return, the reminder will still pop up. it is because, i have no function to check out the cd..how to make the check out and also can disable the reminder if i click the check out for that borrowing.

View 4 Replies View Related

Terminate Program In 30 Days Unless Enter This Password?

May 17, 2006

I would like to add to the initial startup of my application a form with a password command that if you do not enter the correct password in 30 days it will terminate this application? Is that possible?
Thanks
matt

View 3 Replies View Related

Date Reminder

Sep 21, 2005

This is my problem!!! Bit new to Access, so here goes! I am setting up a claibration database for test equipment, what i need to do is to set up the database so that say a week before a calibration date is due, the database will flag this up, say display a reminder!! Can anyone tell me is this possible and the best way to set this up????

Thanks.

View 1 Replies View Related

Reminder In Access?

Mar 6, 2007

hi all.
there's a new db im making and i'd like to add in a 'follow up reminder' feature where; after 1 month of job completion (as updated by a auto update date field) we can give a 1 month follow up call with the customer just to say 'hey, just wanted to make sure your stuff is working' or so to speak. the reminder must say something to the likes of '1 month follow up required for customer vin deisel acct # 5777'... in other words the popup box gotta have the option to capture data from the db as well!

about 2 or 3 guys in here (total access noobs-myself included) are the ones making the db and we'd like some assistance here.

*hopes i posted this in the right forum!*

View 3 Replies View Related

Help With Reminder Program

Oct 5, 2004

hi!
I'm doing a reminder program this program alerts you if you have things to do each day it has a code that I obtained on the internet wich retrieves the user name. My problem is that when I enter as a user a window shows up say my username and the number of things I have to do but I can't get it to count the number of things to do. I tried a query but it doesn't work (either it shows "#name" or it goes all blank)please help.
thanks in advance, newbiepr

View 4 Replies View Related

Clearing MS Outlook Reminder

Dec 28, 2005

I have created an email message to be sent via a closing button on a form, using the DoCmd.SendObject command. It all works fine except that MS Outlook then puts a message box on the screen with a countdown bar saying that MS Access is trying to access Outlook and to press Yes if this is to be allowed.

Is there any way that I can disable this message box please. I appreciate that this is more an Outlook problem than an Access one, but some database programmer has probably come across the same problem before.

Many thanks

Roger,
Newcastle, UK

View 3 Replies View Related

General :: Implement Pop-up Reminder From Within Access

Oct 26, 2012

I'd like to know how to implement a pop-reminder that runs reminding the user of the database of :

1. some to-do actions for the current day or, for example, a week ahead of a certain event, that is related to some date previously entered in a table.

2. this should be within the access database.

3. I saw something like that in the [URL]... website, but actually couldn't understand it.

View 12 Replies View Related

Reminder Every 6 Months On Opening Certain Report

Oct 16, 2013

I want to create a query that says starting on a specific date, every 6 months a reminder will pop up when a certain report opens (or form, preferably a report). So if I said the starting date is 10/16/2013, once April 16th, 2014 hits and this user opens the report, a message pops up.

Another way would be to add that message to the report itself, so it's not technically a pop up but its built-in to the report.

View 9 Replies View Related

Trigger Reminder To Occur At Later Date

Apr 22, 2014

How I would accomplish the following scenario in Access 2010. I have created a data base for a funeral home. One of my tables includes the date of death of the individual (DOD) (i.e. 04/16/2014). From that date I want to trigger a reminder to follow up with a family letter 6 months from that date. Would I do this with a macro or would I do this with VBA Script?

View 7 Replies View Related

Kind Of Countdown Reminder In A Date Column

Jun 29, 2007

hey,

Sorry to open with a question but its usually the way, i'm quite an experienced computer user but never used any office products before and just thought i should learn as i'm losing money every week by not keep track of things properly.

So then to my question..

I've made a table to cover all the orders i have had placed, this includes a date column for when that order was placed. I just wondered if it would be possible to have some kind of system where after 7 days without any acknowledgement from me it either pops up or turns red or something similiar. I'm thinking the acknowledgement could be the yes/no box and i tick that when i recieve the item back, if i dont it either pops up or turns red or something :confused:

any help much appreciated

View 2 Replies View Related

General :: Setting Monthly Reminder Using Outlook

Jun 22, 2015

I'm working on an access database and I need to connect that database to the reminder function of Outlook.

At first, I set the reminder precisely six months before the due date, everything was okay and the reminder worked. But after some revision required by my supervisor, I need to set the reminder based on month (not exactly on the due date), so the tasks which have due dates in the same month will be wrapped into a single reminder. The reminder also should be appear in every two weeks. Here's the code I've been worked on :

Code:
Private Sub Expired_AfterUpdate()
Dim outLookApp As Outlook.Application
Dim outLookTask As Outlook.TaskItem
Set outLookApp = CreateObject("outlook.application")
Set outLookTask = outLookApp.CreateItem(olTaskItem)

[Code]...

I put this code on the AfterUpdate event in the column containing the due date. How should I rearrange the code so it would be able for the reminder to appear based on the month? (just consider that the reminder will be active six months before due date).

View 4 Replies View Related

General :: Schedule Maintenance - Reminder By Date

Jul 15, 2015

I have a table called schedule maintenance.

In that table I have a "date" field

Is it possible that if " todays" date = a date in the field date a e-mail can be sent to me to remind me there is a scheduled maintenance to be done.

View 6 Replies View Related

General :: Pop Up Alert - Reminder For Birthdays Of Guests

Jun 18, 2013

I need to create a guest database for a small hotel. And I would like to create a pop-up alert that appears when I open MS Access to remind me birthdays of the guests.

View 1 Replies View Related

Automatically Sending An Email Reminder Every Thursday Of The Week

Jan 12, 2006

Hi all

I've got a db system linked with webpages that handles rent management and i'd like to set up an email reminder every thursday to tell the student tenants to put the rubbish out for the bin man. I have their email addresses in one table and another table telling them whether its recycling or landfill rubbish.

Basically the question is how would i go about getting access to send the email at a certain time and date ?


Many thanks

View 6 Replies View Related

How To Send Automatic Reminder Email In MS Access 2010

Apr 1, 2014

I created a Tracking System and would like to send an automatic reminder to the person the ticket has been assigned to, using the due date and the text message in the field "reminder message". Once the message send, I want the database to recognize and not send it again. I want the database to send a new message if the due date has changed.

View 3 Replies View Related

General :: How To Make Reminder Pop Up Based On Selected Time And Date

Oct 12, 2014

I want to make an application that reminder Radio Broadcaster to read ads based on airing hour.

I have a question , how to make reminder pop up based on selected hour or time and date of that advertisement.

View 3 Replies View Related

Forms :: Setting Popup Reminder On Form Load For Expiry Date

Jul 26, 2015

I have a form (Access 2010) in which i insert contracts; each contract has a start and an expiry date, but instead of dd/mm/yyyy i would like the user to be able to insert just the year, while the day and month are predefined values and they are automatically inserted (i.e. 01/10/yyyy; the year being the only value that changes, and it is manually inserted by the user).

I would like to set a pop up remainder (on form load) x days before the expiry date, but, because too many of them have the same expiry date i am wondering if the reminder can be set on different days, based on another field (i.e. partner location [country]).. i.e. reminder for contracts with Austria to pop up 60 days before expiring, for UK = 67 days and so on.. or even a specific day for each, i.e. for Austria = 01/08/yyyy, for UK 01/09/yyyy).

View 2 Replies View Related

Forms :: Make Image Appear In Form When There Is Check In Check Box From Table?

Jun 26, 2014

how can i make a image appear in my form when there is a check in the check box from the table?

View 14 Replies View Related

Creating Date Field For Reminder Date

Mar 14, 2006

I want to create a field for displaying a 90 day period date before the time of renewal.

This date will be displayed to remind me to send out a notice to a client and will be based on the actual renewal date field.

Can anyone please provide some insight into creating such a field.

Also, I will be creating a similar data field that will be based on 30 Days after the 90 day notice that I send out.

Thank you in advance...

Steve.

View 3 Replies View Related

Access Application For Check-in/check-out

Mar 19, 2007

Long time lurker, first time poster.

I'm in need a of a check-in/check-out application for my company. We have about 550-600 employees at any given time and our turnover is about 20-30% per year. Our check-in/check-out process requires our employees to personally visit between 30-40 areas in our company (personnel, safety, credentials, parking, insurance, etc) within the first month of employment. This is currently done manually and is a huge drain on labor, especially when check-in sheets are lost, misplaced or, in some cases, forged.

I'm looking to build a database that would be intranet based, password secure (by check-in area) that would allow the new employee to present at a particular check-in, check-out site, complete that portion of the check-in/out process and then allow the person responsible for the check-in/out to enter the status into the database. At any point in the process, I would want to know the status of the person checking in/out (how long they've been checking in/out and what portion of the process have they completed).

Can this be done in ACCESS?

Thanks

View 1 Replies View Related

Spell Check Contents Works , Need To Suppress The Spell Check Complete Msg Box

Apr 25, 2005

Hi
I have sendkey "{f7}" on loss focus.
this works great as a spell check but then I get the mesage box that spell check is complete.
How do I stop this box from occuring?

View 2 Replies View Related

Check Box??

Jun 8, 2005

Does anyone know or have an example of how to use check box's to filter out things in a form. What I want to do here is I have like 5 different locations and I want to be able to choose which of those location, whether it be one or more checked at a time and then have whatever those check boxes are checked to be filtered out.

View 1 Replies View Related

Check For Used ID's

Apr 8, 2008

Hello,

I have a continious form containing data from the table "tblToernament".
On that form there is a combobox containing teams that are stores in the table "tblTeams".

The table looks like this:

ID | TeamName

1 | Team01
2 | Team02
3 | Team03
4 | Team04

When I select, for example, Team02 in the combobox I want that value on, after I selected it from the combo NOT to be in the combobox.

Can anybody please help me on this?

View 9 Replies View Related

Please Will Someone Check Over My ER-D For Me, Once More?

May 15, 2007

Hello, im making a database for a charity as part of my work experience and id just like someone to check over it for me. If you see any issues please let me know. Im already aware of changing text PK's to autonumber, this is a prototype so im not going to change the PK's at the min.

Any ideas, or ways to improve it?

You can find the LDM or ER-D here: (i understand that it may be difficult for you to follow since you dont know the system! But please have a go...) 17447

Thanks very much for your help.
Ant...

View 1 Replies View Related

Check Box

May 3, 2005

Hey guys..

I was working on my project again as usual, which is about transaction of cars coming in and going out (car pool system), So i created a table then a form for this. In the table, i put the option of 'Yes/No'. So, for the form, i want to create a search system which will include a search system.

My Idea:

I want to make a check box, as a search system, so when it is checked and clicked on a command button, it searches for all records with 'Yes'. and if not checked, and clicked on command button, then it searches for all records with 'No'.

Now i did my research, on google and stuff also in the access help but it ddnt help much.

To be honest with you guys, i dont know much of visual basic writing, but i do understand most of it. ( you know, when you understand one language but can speak it?? same way :o ).

So i would request some one to give me instructions on this one. It would really be appriciated.

thanks a million !

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved