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).?
Thank you very much for your response
Hi
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 :
Nikko
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.
View 6 Replies View RelatedHow to create messagebox to alert when I open form that have a new record added , and if it can count No of new record ? could it be possible?
View 3 Replies View RelatedHow 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.
View 5 Replies View RelatedI have Access 2003 and I am trying secure my database.
I read thru the posts in this forum and I created a new mdw file and new id..I gave this new id all the powers of Admin, so that I can take away all the powers from Admin user and Admins Group...but I am unable to change owner for the database object..current owner is Admin.
What can owner do that admin cannot do?
Please help..
Thanks a bunch.
I have Access 2003 and I am trying secure my database.
I read thru the posts in this forum and I created a new mdw file and new id..I gave this new id all the powers of Admin, so that I can take away all the powers from Admin user and Admins Group...but I am unable to change owner for the database object..current owner is Admin.
What can owner do that admin cannot do?
Please help..
Thanks a bunch. :confused:
I have a table called tblCompanies. When a company acquires another company, I need a method by which the acquired company's CompanyID (PK) can be updated to the new company's CompanyID (PK). I also need to be able to update all related CompanyIDs (FKs) to the new value in related tables.
In cases in which the new company does not have an existing record, there is no problem: the company name simply gets changed to the new company and the existing CompanyID is maintained. I then use an audit table and Track Changes function to keep track of the company name data and a union query to keep the old names in the selection lists.
The problem is when both companies already have existing records in the table.
So, let's say I have records for Company A and Company B. Company A merges with Company B and Company B is now the main record. What is the best, simplest and easiest way to update the CompanyID (PK) from A to B and change the CompanyID (FK) to the new value in all related tables?
I am envisioning a pop-up form that directs the user to select the new company and then an update query happens behind the scenes... but exactly how does the criteria for the update query get selected and how do all the related tables get updated? My vba skills are pretty basic, will I need extensive coding to do something like this?
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
Thanks for lookin!
Dear all,
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?
Tq.
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?
View 1 Replies View RelatedI 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
View 5 Replies View RelatedI 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?
Chris
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?
View 1 Replies View RelatedI 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.
is it possible?
Greetings,
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
Thanks all for any assistance you might offer!
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...
View 2 Replies View RelatedSyntax 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...
View 1 Replies View RelatedQuestion:
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?
Thanks in advance for your answers/reactions/help
i want to be able to create an On Click Event when pushing a command button that will run an Update query to update a record and after it has been updated that specific record will pop up on a Form and be displayed. i know a different way is to run the Update query and then have it displayed in a Select query but i want it to be displayed on a Form instead. is it possible?
View 4 Replies View RelatedI need a way to dynamically store a particular value in "field_2" of the CURRENT record depending on whether or not the value of "field_1" of the CURRENT record is identical to the value of "field_1" of the PREVIOUS record within the same table. The table is sorted on "field_1".
So, if the value of "field_1" in the CURRENT record is "ABC" and the value of "field_1" in the PREVIOUS record is also "ABC", then store a value of "PPP" in "field_2" of the current record. IF on the other hand, the value of "field_1" in the CURRENT record is "ABC" and the value of "field_1" in the PREVIOUS record is "XYZ", then store a value of "WWW" in "field_2" of the current record.
I have a report that will use these results to count only the number of records that have a "WWW" in "field_2".
Is this doable, maybe in a query somehow?
I should add that whatever the solution, it needs to be compatible with Access 2000.
Good Day,
I have a record which is updated by customer services dept. for collection of container. Every time we received the collection alert from client we update into system. Sometimes we got more than one collection alert per day. Although the Job No is same but the Date Received the Time Received is different.
Example :
ID Job No Date Time
--------------------------------
1 1000 1-8-2005 8:00
2 1000 1-8-2005 8:30
3 1000 2-8-2005 8:30
4 1001 1-8-2005 9:00
5 1001 1-8-2005 9:30
I just want the last update of data and the result shuld be
ID Job No Date Time
--------------------------------
3 1000 2-8-2005 8:30
5 1001 1-8-2005 9:30
TQ
Hi,
Don't know if this is possible, or if im being just plain stoopid:
Is there a vb command that will update a record without having to use a query?
My problem is this - I have an HR database which has allows us to add employees that are going to start. We then set their [Activity Status] from "Starting" to "Active". At the moment this is done manually, but what i would like to do is have this automatically change when the [Start Date] = Date().
The code i tried to use (but is obviously wrong) is:
If [Activity Status] = "starting" And [Start Date] < Date Then
Set [Activity Status] = "Active"
End Sub
Any thoughts what i might change "Set" to, to make this work?
Thanks,
Ferg.
I hope I can convey what I am trying to figure out. I am at a loss right now. I have a form where I input personnel information. One of the fields is for how many months experience they have with the program. What i would like is for this record to update itself every month. for example, if they initially had 2 months experience, I would enter 2. Every month therafter, that number with change to 3, 4, 5...etc. Not everyone comes to our section with the same experience, so most will have a different starting number.
This information would be seen on the personnel form, and in a report to show experience levels. Other than those two, it is not called upon.
Any suggestions would be so helpful!
Thank You!!
Hello All,
I have a table with over 700 contact records, when I open contact form and select the contact I to want update , it only updates the first row in the table
message "you about to update 1 row(s)"
table set up ContactID is the PK autonumber
please advice
AA
Private Sub Update_Click()
' Dim QrySQL As String
On Error GoTo Err_Handler
DoCmd.RunSQL "Update Contacts " & _
"Set Company = '" & Me.TbxComp & "', " & _
" Street = '" & Me.TbxStreet & "', " & _
" Floor = '" & Me.TbxFloor & "', " & _
" CityStateZip = '" & Me.TbxCityStateZip & "', " & _
" Telephone = '" & Me.Telephone & "', " & _
" Fax = '" & Me.TbxFax & "', " & _
" Manager = '" & Me.TbxAcctMgr & "', " & _
" Email = '" & Me.TbxEmail & "' " & _
"Where ContactName = '" & Me.ContactName & "'"
Err_Handler:
If Err.Number = 2501 Then
Exit Sub
End If
'Else
' MsgBox Err.Description
MsgBox "Update Was Completed !!!"
' DoCmd.SetWarnings False
' DoCmd.RunSQL OrySQL
' DoCmd.SetWarnings True
End Sub
Hello all! I'm using a form in data entry mode to add new orders into a table. When the Save button is pressed, an append query posts the order number and date to another table, and then enables a subform for data in that table. The subform is linked to the main form by the order and date to get only the record that was just entered/created.
While the subform does display the desired record, the user cannot update other fields in that table through the subform. I've searched all over the forums, and I'm probably missing something really simple. I've tried turning data entry on and off, changing different subform properties but to no avail. I can filter out the proper record on the subform, I just can't update it! Any help would be much appreciated. Thanks!