Howdy,
Ok, I did a search of the forums, and couldn't find an answer. I have a feeling that the answer is either here or on the net somewhere, so if someone could point me in the right direction, I'd be much obliged.
I have a DB that tracks clients attendance. The clients are refered to us via the County. When the county refers them to us, they have two days to contact us. What I need is some way to enter the clients info when I get the referral, and then have some sort of pop up reminder two days later to see if they contacted us.
Also, what is such a function called? that way I can do a better search for it :p
I have a problem with the sending of emails in a database. the question is, passed 5 days wants that the database sends an email. So far so good… the problem is that I desire that the recipient send me a notification of delivery and a notification of reading automatically everything this with VBA code. It will be that somebody will be able to help me? Thanks :
I create a make table query. But every time I run the query, the notification will prompt out "are you sure....". Is there any way to disable this notification?
I have a command button on a form that is going to run 5 append queries into a temporary table. As it is right now each time the program will display to command boxes 1 being the "You are about to run an append query" and also the "You are about to append X rows", having to press ok 10 times for one report gets a little annoying. Is there any way to suppress these notification boxes from popping up?
I need to make a returns notification if people bring back there rentals back late in my database for a rental place like blockbuster. Please any help would be appreicated. Sorry I rushed this post If you need any more information reply
I am in major need of help. I am need Access or Excel to notify a user when a change has been made to a table. I have a potiential database/spreadsheet, and this would help me. Can anybody help me out?
My database at the moment counts how many records of each Pupil is entered into the system. When a pupil has been entered into the system 10 times I would like a Notification Message to come up, are such messages possible?
I have a simple question on the usage of an Access project by multiple users.
1. Is it possible to store and reflect information in the project about which user updated or deleted information to any field/record in the project?
2. What would be a nice way to communicate to other users when they log in that such-and-such field record was updated/deleted by such-an-such user at xxx (date/time).?
I have an inventory database, and would like to know if there was any way to have a auto email notification when a specific item in a table is out of stock, or is low in quantity? I know who to do the auto notification when a form is created or modified, but I can't seem to figure out how to do this.
I am using Access 97 at work, Access 2000 at home. This is a work project.
I have a database that tracks employee awards. One type of award is the Peer Award. An employee can receive more than one award during the reporting period (01 May 05 through 30 April 06), but an employee can nominate someone only ONCE during this period. The query also filters all award for the word PEER in the Award_Type field.
I need a method in my subform (where all of the award info is entered) to display a message if the NOMINATED_BY field contains the name of a nominator more than once. I am using a combobox (cboNominated_By) to select the nominator from a query based on the Employee_Name table.
I had thought of making the field NO DUPLICATES, but cannot do that, as I also keep these records as multi-year archives.
In my query I have as the criteria to limit records for the reporting period above.
In my subform, is there a method to check the combobox that I'm using for a duplicate nominator, then notify the user of this duplicate?
I've seen something similar to what I want in the below thread, but FoFa didn't offer an example of how this would be accomplished; Notification of Duplicate Records http://www.access-programmers.co.uk/forums/showpost.php?p=158082&postcount=2
I want to create a button on my form so that once I have entered results of an Audit into the form, I want to be able to press the button to send the manager an email stating the Audit Observation Record ID to action.
I have a marco that sends a report to other users, is it possible to stop the same report being sent twice to the same person . the user who sends the report is prompted for a number for that specific report...
Syntax for finding a change /update in a table. I want to add a data macro to my table "After update" , to send email to group as soon as a new DB entry is made in the table...
Question: I have a make-table query which is runned when clicking on a button in a form. Of course after clicking the button the following notifications appear:
1) You are about to run a make-table query that will modify the data in your table (yes, no help) 2) (if the table exists) The Existing Table <<tablename>> will be delted before you run the query (yes, no) 3) your are about to paste 1 row(s) into a new table (yes, no)
How can i make it possible that on forehand all three questions are "yes", so that the user does not see these questions, but the table is filled with the relevant information and can be used?
How can I send an automated email notification everytime a new record is created. I have a macro set up with the send object completed, I just can't figure out how to tweak the logic so it will do it everytime a new record is created.
