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..?
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 an Access database keeping track of the number of cars registered under the company. The cars have details like type, make, license plate number, road permit dates, etc.
I would like to get alerts 3 days before the expiry date of the road permit. which is the best way to go about it?
Thanx in advance
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.
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
As an "admin" of our corporate local db, maintaining and/or upgrading is my task.
Usually there are logged-in users, then I have to ask them (mostly via communicator) to please log off, because I can not modify with users in the db.
I would like to send these users a message via Access, like "Please log off from the db for maintenance blabla".
I 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 RelatedNot being a code person. This code worked great for 2003, but we just installed 2007. I get an error message when the this code runs:
Its a complie error
User-defined type not found
Sub ShowUserRosterMultipleUsers()
Dim cn As New ADODB.Connection.....red shows where I get the error message
Dim rs As New ADODB.Recordset
Dim i, j As Long
Set cn = CurrentProject.Connection
' The user roster is exposed as a provider-specific schema rowset
' in the Jet 4.0 OLE DB provider. You have to use a GUID to
' reference the schema, as provider-specific schemas are not
' listed in ADO's type library for schema rowsets
Set rs = cn.OpenSchema(adSchemaProviderSpecific, _
, "{947bb102-5d43-11d1-bdbf-00c04fb92675}")
'Output the list of all users in the current database.
Debug.Print rs.Fields(0).Name, "", rs.Fields(1).Name, _
"", rs.Fields(2).Name, rs.Fields(3).Name
While Not rs.EOF
Debug.Print rs.Fields(0), rs.Fields(1), _
rs.Fields(2), rs.Fields(3)
rs.MoveNext
Wend
End Sub
I would like to have a message box popup 30 minutes after a user checks a checkbox (check5). I am thinking I would have to have VBA code to run on the After Update property of the checkbox but not sure what the correct code would be.
View 3 Replies View RelatedI had used a form to come up as a popup, and on that popup, the person can chose a report to go to (button). Is there a way that once they chose the button they want, to make the popup to go away automatically?
View 11 Replies View RelatedIs there and possiblity to have a pop up message box asking for password when changing file extension from accdr to accdb ?
View 6 Replies View RelatedI am creating payment database for a community gym, the data will be created on a data sheet.
There are 2 payment types monthly and annual (these are on a dropdown box with their own id number).
I have a joining date and a paid date, but reflected against the payment type ie 31 days or 365 days.
I have been trying to do something along the lines of:
if [monthly] (is selected) (so this would call up a 31days) date() is > [joining date] then give message to renew and same kinda thing for annual.
I have a form with an option group to select subforms to be displayed .To save space on the main form I have added a subform (frmSubService) to the option group to display some of the data that was originally on the main form. The subforms data source is the same as that of the main form but only displays five fields.
After editing data in the subform frmSubService, if I then click on a field on the main form no problem, however if I click on an option button to view another subform I get a messagebox pop up with the following message;
The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-Edit the record.
If I click OK,and without re-editing the record, I can open another subform.
I have checked and the data changes made on frmSubService, in both cases, has been saved.
How do I prevent the pop-up message?
Hi,
I have a Data Access Page linked to an access database (of course!) and I would like to have a script in the submit button, so that it inputs the current time onto a particular field, and also throw up an alert box...could someone please help? I am not good at this, but it looks like it is javascript - thats currently on the button for the save action
Regards
Sunny
On trying to import an Excel 2007 file into Access 2007 I get the following:
1) Choose "External Data," Import, Exce
2) Select small file in MS Excel 2007 format.
3) Click on Import the source data into a new table ...
4) Choose OK
Immediately get "Microsoft Office Access has stopped working. Windows is checking for a solution to the problem..." This message never resolves, so I have to click 'Cancel'.
Then I get "Microsoft Office Access is trying to recover your information..." I have to click "Cancel" here as well and then kill MS Access in Task Manager.
Event Viewer gives following message, which is of no help:
"ID: 2, Application Name: Microsoft Office Access, Application Version: 12.0.6211.1000, Microsoft Office Version: 12.0.6215.1000. This session lasted 710 seconds with 120 seconds of active time. This session ended with a crash."
Trying to import a small Excel 2003 file leads the same result. The same happens with a CSV file.
I have uninstalled and reinstalled Office 2007 as well. I am using Vista Ultimate.
I have turned off DEP.
How can I get MS Access 2007 to import Excel?
Thanks
Ken
Hi,
When the user click the button, then it will give out a popup form to the screen, but I want to make the popup form's height as same as the screen/window/monitor's height, because the popup form's height is larger than the screen's height, and every user's monitor's height is different. So, I have to make it flexiable change of the height of the popup form.
How can I check the screen/window height by VBA function?
In Excel, it has Application.Height to check. In MS Access Form, I cannot find one for doing that.
Please let me know if you have one.
Thanks.
I installed Office Enterprise 2007. Then I installed DEveloper Exrtensions, then Access Runtime 2007. All appear to have installed OK - they appear in Program and Features.
Instructions on runtime packaging tell me that a Developer option should appear in the resulting drop-down when I click the Office button (top-left round thing) when I have a d/b open in Access. It's not there! I have un-installed and re-installed the extensions and the runtime - still nothing!
Help!
I do have Runtime 2002 (XP) on the same PC, is that relevant?
Is there a way to make the ESC key have the same results as the "No" button in message boxes?
View 2 Replies View RelatedHi,
I'm trying to implement a new pop up on one of my queries.
When the user runs the query a pop up will appear and he will enter a currency number (19.95) and it will display all currency (<) less than 19.95.
I use this wild card pop up currently and have tried to modify it, but can't seem to get to do what I need.
Code:Like [Enter Min-Amount] & "*"
Thanks for your help,
Leap!
Hi everybody,
Beginner here needs help !
I'm building a make-table query for which if the result is null (no record correspond to the set of criterias), a default message like "there was no activity during the period" would appear in the table (not a message box...I need the message in the output table). The best I could think of is an IIF function but it doesn't seem to work... Is there any way to do this without using VBA?
Thanks in advance !
I am designing a transactions database for some of my clerical staff. I've inserted a data entry subform into the main transactions form (which also has a subform that summarizes all the selected company's past transactions). This data entry subform actually has as it's record source a table that simply stores that one record temporarily.
So when the user is finished entering their current transaction, I have a Save button that actually just opens a popup form which displays the data they entered into the data entry subform, giving them a chance to verify their entry is accurate. This form has a Save button which runs an append query and a delete query, adding the record to the permanent Transacations table and also clearing the temp table.
The problem I have, I think, is that when the popup form opens, the main form data entry subform still has that record locked as exclusive. I believe this is the case because while I am indeed able to make changes to the fields on the popup form, none of these changes appear in the temp table. In other words, the user is not actually able to use the confirmation pop up form to make any necessary edits to their entry. This makes the form sort of useless!
I'm trying to do right click menu on listbox.
currently i'm trying to implement a right click menu which will show a simple messege box.
My problem is that the list box is on a pop up form which opened up maximized. Now when i'm right clicking on the list box i see the right click menu but when i'm clicking on one of the menu options, nothing happenning (it seems that it don't go to the function as it should). i've also putted breakpoints on the function but it never tips.
It's important to mention that if i'm setting the form popup option to no the right click menu works perfectly (when i'm clicking on one of the options i see its matching messege box).
I'm running the following vba code:
This is the mouse up event handler for my list box:
Private Sub Song_List_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
' Call the SetUpContextMenu function to ensure it is setup with most current context
' Note: This really only needs to be setup once for this example since nothing is
[Code] .....
setting up the "SetUpContextMenu" sub:
Public Sub SetUpContextMenu()
' Note: This requires a reference to Microsoft Office Object Library
Dim combo As CommandBarControl
' Since it may have been defined in the past, it should be deleted,
' or if it has not been defined in the past, the error should be ignored
[code].....
Hello,
I have installed Microsoft Access 2003 and Microsoft Access 2003 Developer Extensions. I can create Access application by using the Package Wizard.
But after I upgrade from Microsoft Access 2003 to Microsoft Access 2007.
I can't use the Package Wizard.
How can I do to solve this?
Thanks.