[AccessD] Data Macros Unavailable

ewaldt at gdls.com ewaldt at gdls.com
Wed Jun 8 05:46:46 CDT 2016

Charlotte and Doug, thanks.

Charlotte, thanks but that's not strictly true. Following a book's 
instructions, I double-click on a table (which opens it, of course), and a 
Table Tools section appears on the ribbon, containing Fields and Tables 
tabs. Clicking on the Tables tab (sorry that I wasn't this specific the 
first time) yields several icons, including before change and delete, etc. 
Those are greyed out within my app, although the book says that's how I'm 
to access them. In another app, though, they're available. I can't find 
any difference between the two apps that would cause this. OTOH, opening 
in design view as you suggest DOES bring up the Table Tools section again, 
but this time without only one tab, Design. Under that is an icon for 
Create Data Macros, and the same options (before change and delete, etc.) 
are present, and are NOT greyed out, so I definitely thank you for that. 
Still wondering why that other way is available in one app but not the 

Doug, I created the app in Access 2007. Since I'm using 2013 now, I guess 
that's kinda, sorta a legacy app. :-)  But not really.

Thanks, again.

Tom Ewald
Mass Properties
General Dynamics Land Systems

You have to be in design view for the table to get at the data macro 

Charlotte Foust

From: "Doug Murphy" <dw-murphy at cox.net>
To: "'Access Developers discussion and problem solving'"
                 <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Data Macros Unavailable
Message-ID: <00a301d1c0e6$3eceb400$bc6c1c00$@cox.net>
Content-Type: text/plain;                charset="us-ascii"


Is this a legacy project with mdb file type?


> I've used VBA in Access for several years, and have ignored macros, 
> for the autoexec on occasion. Now we have Access 2013 (64 bit), in which
> macros have taken major steps forward. I was interested in data macros,
> but when I open a table and click on the Table tab, the icons for
> Properties, Before Events, and After Events are all greyed out. I'm
> guessing I've got a setting off somewhere. Could someone help, please?
> Thanks.

This is an e-mail from General Dynamics Land Systems. It is for the intended recipient only and may contain confidential and privileged information.  No one else may read, print, store, copy, forward or act in reliance on it or its attachments.  If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

More information about the AccessD mailing list