If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Object or class does not support the set of events" Quick Question
All,
I built a MS Access database in MS Access 2003, which I have set up in a shared folder. I have a form with some standard components such as text boxs, bottons. When a user updates the form I wish to record the time/date and username in the record. I have posted a copy of the code I'm using for the "BeforeUpdate" event below. Now this works fine on my machine and updates without a problem. However when a user on another machine (also using MS Access 2003) tries to update the same field, he gets the following error: "The expression Before Update you entered as the event property setting produced the following error: Object or class does not support the set of events." Because I am geographically away from my user, I haven't been able to test this very well. I'm hoping that someone might have some good ideas off hand. I'm open to either a fix for the problem as is or an alternative approach. the code is as follows: Private Sub Combo104_BeforeUpdate(Cancel As Integer) Me!Date_Modified = Now() Me!User_Modified = CurrentUser() End Sub Thank you! |
#2
|
|||
|
|||
"Object or class does not support the set of events" Quick Question
It would be better to use the BeforeUpdate event procedure of the *form*
rather than the combo. That way the update gets recorded whether they change the combo or some other field. (If you only want to record the changes resulting form a change in the combo, use its AfterUpate event procedure.) But that doesn't deal with the difference between your machine and the other one. Something else must be going on here. Suggestions: 1. If the other user is on Windows Vista, see: http://allenbrowne.com/bug-17.html 2. Could be a problem with the library references: http://allenbrowne.com/ser-38.html 3. If neither of those apply, a compact/decompile/compact might fix it. Post back if you need details of how to do that, or search for Decompile on this page: http://allenbrowne.com/ser-47.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. wrote in message ... All, I built a MS Access database in MS Access 2003, which I have set up in a shared folder. I have a form with some standard components such as text boxs, bottons. When a user updates the form I wish to record the time/date and username in the record. I have posted a copy of the code I'm using for the "BeforeUpdate" event below. Now this works fine on my machine and updates without a problem. However when a user on another machine (also using MS Access 2003) tries to update the same field, he gets the following error: "The expression Before Update you entered as the event property setting produced the following error: Object or class does not support the set of events." Because I am geographically away from my user, I haven't been able to test this very well. I'm hoping that someone might have some good ideas off hand. I'm open to either a fix for the problem as is or an alternative approach. the code is as follows: Private Sub Combo104_BeforeUpdate(Cancel As Integer) Me!Date_Modified = Now() Me!User_Modified = CurrentUser() End Sub Thank you! |
#3
|
|||
|
|||
"Object or class does not support the set of events" QuickQuestion
My user isn't using Vista. So that rules out 1.
I checked and my user has exactly the same libraries enabled as I do. That rules out 2. I tried 3 and this seems to have made the problem worse. I have a button to open my form that has an event that users the CurrentUser() function. Before doing the compact/decompile/compact this worked fine for the user but he had problems on the form. Now he's getting the error when he clicks on the button to open the form. any ideas? thanks. On Feb 18, 3:30*am, "Allen Browne" wrote: It would be better to use the BeforeUpdate event procedure of the *form* rather than the combo. That way the update gets recorded whether they change the combo or some other field. (If you only want to record the changes resulting form a change in the combo, use its AfterUpate event procedure.) But that doesn't deal with the difference between your machine and the other one. Something else must be going on here. Suggestions: 1. If the other user is on Windows Vista, see: * *http://allenbrowne.com/bug-17.html 2. Could be a problem with the library references: * *http://allenbrowne.com/ser-38.html 3. If neither of those apply, a compact/decompile/compact might fix it. Post back if you need details of how to do that, or search for Decompile on this page: * *http://allenbrowne.com/ser-47.html -- Allen Browne - Microsoft MVP. *Perth, Western Australia Tips for Access users -http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot wrote in message ... All, I built a MS Access database in MS Access 2003, which I have set up in a shared folder. *I have a form with some standard components such as text boxs, bottons. *When a user updates the form I wish to record the time/date and username in the record. I have posted a copy of the code I'm using for the "BeforeUpdate" event below. Now this works fine on my machine and updates without a problem. However when a user on another machine (also using MS Access 2003) tries to update the same field, he gets the following error: "The expression Before Update you entered as the event property setting produced the following error: Object or class does not support the set of events." Because I am geographically away from my user, I haven't been able to test this very well. I'm hoping that someone might have some good ideas off hand. I'm open to either a fix for the problem as is or an alternative approach. the code is as follows: Private Sub Combo104_BeforeUpdate(Cancel As Integer) Me!Date_Modified = Now() Me!User_Modified = CurrentUser() End Sub Thank you!- Hide quoted text - - Show quoted text - |
#4
|
|||
|
|||
"Object or class does not support the set of events" Quick Question
Okay, if it got worse, you have progress. :-)
Have them remove the DAO library, and re-register it. (The references web page explains how to do this.) After re-registering, have them add the DAO 3.6 library again. There are cases where this library doesn't show as "MISSING", but re-registering it solves the problems. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. wrote in message ... My user isn't using Vista. So that rules out 1. I checked and my user has exactly the same libraries enabled as I do. That rules out 2. I tried 3 and this seems to have made the problem worse. I have a button to open my form that has an event that users the CurrentUser() function. Before doing the compact/decompile/compact this worked fine for the user but he had problems on the form. Now he's getting the error when he clicks on the button to open the form. any ideas? thanks. On Feb 18, 3:30 am, "Allen Browne" wrote: It would be better to use the BeforeUpdate event procedure of the *form* rather than the combo. That way the update gets recorded whether they change the combo or some other field. (If you only want to record the changes resulting form a change in the combo, use its AfterUpate event procedure.) But that doesn't deal with the difference between your machine and the other one. Something else must be going on here. Suggestions: 1. If the other user is on Windows Vista, see: http://allenbrowne.com/bug-17.html 2. Could be a problem with the library references: http://allenbrowne.com/ser-38.html 3. If neither of those apply, a compact/decompile/compact might fix it. Post back if you need details of how to do that, or search for Decompile on this page: http://allenbrowne.com/ser-47.html wrote in message ... All, I built a MS Access database in MS Access 2003, which I have set up in a shared folder. I have a form with some standard components such as text boxs, bottons. When a user updates the form I wish to record the time/date and username in the record. I have posted a copy of the code I'm using for the "BeforeUpdate" event below. Now this works fine on my machine and updates without a problem. However when a user on another machine (also using MS Access 2003) tries to update the same field, he gets the following error: "The expression Before Update you entered as the event property setting produced the following error: Object or class does not support the set of events." Because I am geographically away from my user, I haven't been able to test this very well. I'm hoping that someone might have some good ideas off hand. I'm open to either a fix for the problem as is or an alternative approach. the code is as follows: Private Sub Combo104_BeforeUpdate(Cancel As Integer) Me!Date_Modified = Now() Me!User_Modified = CurrentUser() End Sub |
Thread Tools | |
Display Modes | |
|
|