ok.. i need to add an input textbox to my message alert..
i have this right now..
Option Compare Database
Private Sub Form_Open(Cancel As Integer)
MsgBox ("Enter the date:")
End Sub
i also need the value they enter to be saved as 'formdate'
then i will assign my date field to that value using something like
datefield = formdate
Hi all, wondering if anyone can help me.
I have an access database, with a form called "Stock Maintenance", the controls on the form are QTY & Min QTY.
What i would like if possible, is once the Min QTY is below (10) an alert message/flag appears, saying QTY LOW Re-order Stock!!
I hope I have expressed what im trying to do.
any help on this matter would be greatly appricated.
I have a screen that has 8 different buttons and clicking on any of these buttons generates an appropriate letter and once the button was clicked in also inserts a date, today's date.
Private Sub btnSecondReport_Click()
On Error GoTo Err_btnSecondReport_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
'* Call the standard letter printing routine for this form.
Call StandardLetterVariables("Bd$50paid.doc")
btnFirstReport.SetFocus
[DTSecondLetterSent] = Date
Exit_btnSecondReport_Click:
Exit Sub
Err_btnSecondReport_Click:
MsgBox Err.Description
Resume Exit_btnSecondReport_Click
So I would like to create an alert that looks at this date and 14 days from that date will alert, remind whatever I want to do.
I am thinking it wouldn't be too hard to create a reminder that pops up when the record is opened but I am sure users will want to be reminded without having to go into the record.
My question: can I and is it hard to create a reminder that will take care of paying attention when and who needs to be reminded or should I just create a report and let them run this.
I hope this makes sense and sombody has done this.
Hi
I am trying to create an alert function so that when a user open up a form and displays a record, it will also display any alerts that have been created for that record. e.g. missed payments etc.
I have created a table to store the alert data along with the job number to which the alert relates so in essence I can have more that one alert per job record. I amtrying get one of the alerts to display ok using the following code
alerts = DLookup("[Job _Number]", "Alerts", "[Job _Number]='" & Me.Job_Number & "'" And "[Start_Date]" >= Date)
You will see that I am trying to only display alerts that are within the valid date range (I have not yet included [End_Date] as I cannot get the code above to work.
Can anyone help me correct this code please?
The other thing is that because I am using a dlookup, I am assuming it will only display the first alert it finds in the table and that's it? If so, how do it get it to display all 'active' alerts with a matching job number. By active I mean where the Start date is >= Date() and End date is <= Date()
I would really appreciate any help on this..
Thank you all for reading.
i want to make alert message that will be pop up when the return date for borrowing book is one day before the date. and the alert message will also can show the information about the borrower.the alert message will be something like this. Tomorrow one borrower need to return the book. click ok to view the data.can access 2007 do this kind of alert message..?
View 4 Replies View RelatedI have a form in my db and i would like it to show me a warning message if a specific field in a record is empty or even better not to allow me to close the form. I would like to have this in order to avoid incomplete data.
View 2 Replies View RelatedMy requirements is to send the alert messages with the approaching due date on every Monday of the week. I am able to send alert messages on Monday. My Problem is: How to send alert messages on Tuesday if Monday is Vacation. Is there a way to do it in access? I don't have much experience in access.
View 6 Replies View RelatedI want to make alert message that will be pop up when the return date for borrowing book is one day before the date. and the alert message will also can show the information about the borrower.
the alert message will be something like this. Tomorrow one borrower need to return the book. click ok to view the data.
Can access 2007 do this kind of alert message..?
I get the 'this is read only you will not be able to make changes, etc..
whe I open my database. How do i fix it? No one else is in making changes.
Hi,
I have a query which uses manual input on two fields. I would like to automate this query by pulling the input values from another table.
How do I read the input values from the other table instead of having the users type them in ?
Al
I routinely export queries etc from my development database to the 'live' master database used by users. Every so often I get the error message 'The database Mydatabase.accdb is read only'. Then I can't export anything to it. I don't know why it should suddenly become read only. How do I make the database changeable, and not read only?
View 3 Replies View RelatedIs it possible to change the message that will be displayed when someone enters data that doesn't meet the criteria of an input mask?
Thx,
Lion85heart
Hi
I'm just doing an access form to link to a mysql daabase to update a websites products, using a odbc connection.
When i input a new record and go back to it i see only #Deleted in all fields i have to close the database and open again to see the data correctly.
Is there a way to cure this problem?
Cheers
Neil
I want to have an input mask on an 'Expiry Data' Field so that the input method is 'MON-YY" and I need access to realise it as a data. And then I also need when a user opens a record an anything that is 2 weeks from expiring I need an error message to pop up.
View 1 Replies View RelatedI am trying to change the standard input mask violation error message to a personalised one. I have found this code:
Private Sub Form_Error(DataErr As Integer, Response As Integer)
Const INPUTMASK_VIOLATION = 2279
If DataErr = INPUTMASK_VIOLATION Then
MsgBox "There was an input mask violation in the field no!!"
Response = acDataErrContinue
End If
End Sub
However, i would like to change the message for a number of different text boxes. and i don't know how to isolate each one, and give each one a different message?
All,
I'm getting the following message in Access and it's causing all kinds of headaches for the user. Any ideas why it's appearing and how to get rid of it?
Thanks,
I am developing a database for our fleet of company vehicles. What I'd like to know is is it possible to set up some kind of alert where a dialog box appears (like the sort of thing in Outlook with reminders).
What I'd like is, for example, if a vehicle requires a service a pop up would appear, a couple of weeks before, when the database is opened to alert the user that it will be required soon.
If anyone knows how to do this it would be greatly appreciated.
When I start my database, I would like a field to be checked for todays date. If the condition is true, I would like it to use an alert to tell me that the condition is met. Any ideas?
View 1 Replies View RelatedHope you guys may be able to help
I have a form with a sub form. On the sub form I have #Ordered, #Supplied & #Used. These fields calculate to give the user the # in stock. This figure is displayed on the form. On the form I also have the Reorder level which is set by the user.
I would like to be able to make a message alert pop up when the database is opened or when any of these records show the # in stock is lower than the Reorder level, ensuring that we do not run out of stock.
Many thanks for any help you can give.
My knowledge of access is pretty limited. Can anyone help me with this problem.
I have some due dates entered into the database via a form. Is it possible to send an email alert say 1 month and then 1 week before the due date?
In my form I have a combo box. The combo box has several selections. I want a message box to appear after any but one of the selections within the combo box are selected. Thanks.
View 3 Replies View RelatedI have what is probably a simple question for regular Access users. Before I ask the question, here is a simplified version of the tables involved:
Structure of EMPLOYEE
=====================
EmplID
Name
Structure of TRAINING
=====================
EmplID
CourseID
CourseName
DateTaken
Data in EMPLOYEE
================
EmplID----Name
1234------John Smith
5678------Mike Smith
Data in TRAINING
================
EmplID------CourseID----Course------DateTaken
1234--------NS01--------HeatStreet--06/15/2000
1234--------NS01--------HeatStreet--07/11/2001
1234--------NS01--------HeatStreet--02/07/2002
1234--------NS01--------HeatStreet--08/22/2004
1234--------NS01--------HeatStreet--01/28/2006
1234--------NS27--------Lockout-----01/06/2002
1234--------NS27--------Lockout-----01/27/2004
5678--------NS01--------HeatStreet--12/27/2002
5678--------NS01--------HeatStreet--08/11/2004
Its easy enough to join the two tables in the query and return ALL 9 training records, but I would like to find a way to display only the most recent occurance of each employee taking a course. ie, the max date for each unique EmplID-Name-CourseID-Course combination:
EmplID------Name--------CourseID----Course------DateTaken
1234--------John Smith--NS01--------HeatStreet--01/28/2006
1234--------John Smith--NS27--------Lockout-----01/27/2004
5678--------Mike Smith--NS01--------HeatStreet--08/11/2004
I thought maybe "GroupBy" on EmplID, Name, CourseID and Course and "Max" on DateTaken would do the trick, but apparently not. Is there a way to do this without code?
Thanks in advance........ :)
-SD
I need to know how to send an email to myself when someone adds a new record
to my database. If someone can help me it would be greatly appreciated.
Amanda
I have a brand new database in-the-works that is causing me headaches. For some reason, if I create a query and then exit and re-enter the database, I cannot re-open that query. I get an Error 3112 (cannot be read; no read permission on <name>) and to contact the administrator or creater of the database.
I'M the creator and the administrator on this thing - so why can't I get into the darn thing? I haven't added any security features. This has never happened before on any database I've created, so obviously, it's frustrating.
Any ideas?
HI all,
I've been searching the threads, but to no avail! (be gentle - a curious beginner in a crazy world of demands!)
My database (table) has a date field, when this date is 'now()' I need to send a reminder email to a 1 collegue and 'cc' 2 others. And automatically change the background colour of the date field; say to red.
A step by step guide would be great, or a nudge in the direction of a good example would help,
Thanks for your time,
Id
I am hoping someone out there will be able to help me figure this one out! I have a database I just created which houses approximately data on about 500 physicians/practitioners - from their personal info to information regarding their licensures, liability coverage, and DEA. In order for us to be compliant with administration and government criteria we have to monitor expirations of their license, liability, DEA, and other things. We do this by sending letters/e-mails out 30 days in advance of expiration dates (which is a field in my database). What would really be great if when I bring up my database it would automatically give me a pop-up saying these licensures are expiring in 30 days and send out reminders. I am a rather new user to Access but I do recall a few years ago hearing something about databases that have crystal reports??? I am not sure if that is the same thing or not.
I do have parameter queries set up from date to date but it sure would be impressive if I could get it to do the above. Or maybe another way to do this. Any suggestions????????? CMElady in :confused: distress!!!
Thanks.