P
Phreake
Hi,
I am creating an invenotry database for our asset managment. for this
I am using Access 2007 on a Win XP Pro machine of which I am an
administrator.
In my Database I have a username field and a users country field (both
in a users table), what i want to do is auto populate the the users
country when the user is selected from a combo box.
A colleague knows how to do this by running an Event procedure on
"After Update". but to test this he put in the following code to see
if the After update works.
Public Function trythis()
MsgBox ("Hello")
End Function
but every time we add in a user name we get the following error:
"The expression After Update you entered as the event property setting
produced the following error: Object or class does not support the set
of events.
*The expression may not result in the name of a macro, the name of the
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event or macro.
I originally had this DB on a network drive and then moved it to my
PC, i have also added the locations to the Trusted Locations in the
settings. I have even tried doing a run-as and used my domain admin
account, but still no joy.
I have re-installed, repaired access and office.
Please help as this is doing my nut in...i actually like office 2007
but it has been causing alot of new found issues recently!!
Thanks in advance
Zubair
I am creating an invenotry database for our asset managment. for this
I am using Access 2007 on a Win XP Pro machine of which I am an
administrator.
In my Database I have a username field and a users country field (both
in a users table), what i want to do is auto populate the the users
country when the user is selected from a combo box.
A colleague knows how to do this by running an Event procedure on
"After Update". but to test this he put in the following code to see
if the After update works.
Public Function trythis()
MsgBox ("Hello")
End Function
but every time we add in a user name we get the following error:
"The expression After Update you entered as the event property setting
produced the following error: Object or class does not support the set
of events.
*The expression may not result in the name of a macro, the name of the
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event or macro.
I originally had this DB on a network drive and then moved it to my
PC, i have also added the locations to the Trusted Locations in the
settings. I have even tried doing a run-as and used my domain admin
account, but still no joy.
I have re-installed, repaired access and office.
Please help as this is doing my nut in...i actually like office 2007
but it has been causing alot of new found issues recently!!
Thanks in advance
Zubair