I am very new to Access especially 2010. I am trying to do a data macro. I followed the instruction from help menu. I open my table as per instruction and then try to click on the before and after event however the toolbar for the before and after event under the table toolbar is grey out and I cannot access it for some reason. Can someone tell me what I am doing wrong? Please help.
Data macro - before and after event on the toolbar is locked? (1 Viewer)
- Thread starter Emily
- Start date
AccessJunkie
Senior Managing Editor
- Local time
- Today, 04:15
- Joined
- May 11, 2006
- Messages
- 278
Hi Emily,
Is this a local Access table or a linked Access table?
If it's a linked table, that's why the options are grayed out. You can only create data macros on local tables. To create them on the linked tables, you'll need to open the source database file that contains the actual tables. You can then add/edit/delete data macros attached to those tables.
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
Is this a local Access table or a linked Access table?
If it's a linked table, that's why the options are grayed out. You can only create data macros on local tables. To create them on the linked tables, you'll need to open the source database file that contains the actual tables. You can then add/edit/delete data macros attached to those tables.
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
Hi Jeff,
Thanks for your reply. None of the tables work in my database, I even tried to create a new table and it still did'nt work. However when I created a brand new Database with a new table, those options become available to me. There must be something that is locking me from creating data macro. The original database is local on my PC and was written in Access 2003 which got upgrade to 2010. Do you think that might have something to do with it?
Thanks for your reply. None of the tables work in my database, I even tried to create a new table and it still did'nt work. However when I created a brand new Database with a new table, those options become available to me. There must be something that is locking me from creating data macro. The original database is local on my PC and was written in Access 2003 which got upgrade to 2010. Do you think that might have something to do with it?
AccessJunkie
Senior Managing Editor
- Local time
- Today, 04:15
- Joined
- May 11, 2006
- Messages
- 278
Hi Emily,
If your existing database is a .mdb file with the 2000 or 2002-2003 format, you cannot create data macros on those tables. You can only create data macros on your tables if the database is using the .accdb file format. MDB files cannot understand data macros so those options are grayed out.
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
If your existing database is a .mdb file with the 2000 or 2002-2003 format, you cannot create data macros on those tables. You can only create data macros on your tables if the database is using the .accdb file format. MDB files cannot understand data macros so those options are grayed out.
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
AccessJunkie
Senior Managing Editor
- Local time
- Today, 04:15
- Joined
- May 11, 2006
- Messages
- 278
That's great Emily, I'm glad to hear your issue is resolved.
Good luck with your study of Access 2010.
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
Good luck with your study of Access 2010.
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
