How to Delete table data macros via vba code?

Question

I am looking for sample vba code showing/describing how to delete table data macros via code. I have tried DoCmd.DeleteObject acTableDataMacro, .... but get the message

Error 2487 (The Object Type argument for the action or method is blank or invalid.)

Thanks in advance.

jdraw

Answer 1

The file is zero bytes.

Answer 2

Imb_HB,

You have provided the manual steps required to Rename/Delete a Data Macro.

I am aware of the manual approach. My question/goal is to find an automated means of Deleting an existing TableDataMacro(s).

Tom provided a line of code, but I am unable to get it to work without knowing details of what he used as XML_BLANK_FILE.

Thanks for responding.

Answer 3

I am looking for sample vba code showing/describing how to delete table data macros via code. I have tried DoCmd.DeleteObject acTableDataMacro, .... but get the message

Error 2487 (The Object Type argument for the action or method is blank or invalid.)

Hi jdraw,

I found this:

Use this procedure to delete any named or event-driven data macro:

1. In the Navigation Pane, double-click any table to open it in Datasheet view.
2. On the Table tab, in the Named Macros group, click Named Macro, and then click Rename/Delete Macro.
3. In the Data Macro Manager dialog box, click Delete next to the data macro that you want to rename.

Note: You can also delete an event-driven macro by deleting all of its actions.

Until now (A2007) never heard of Data Macro's.

Are they just handy to start, and - like MVF's - give more problems than they solve?

I want to keep the tables as "clean" as possible, so just tables, and dynamical forms to manipiulate the data.

Imb.

Answer 4

Tom,

Thanks for responding. I have downloaded latest NW developer template and can not find any reference to XML_FILE_BLANK. I also have had no luck with searching for deleting Table Data Macro within NorthWind or other.

I have tried creating a minimal xml file named XML_BLANK.xml.

<?xml version="1.0" encoding="UTF-8"?>
<root>
<!-- This is a blank XML file -->
</root>

but when using it with

LoadFromText acTableDataMacro,"tblSource", "C:\users\jp\documents\XML_BLANK.xml"

The following error results.

Error 3870 (Microsoft Access cannot interpret the text you are pasting as a data macro. Correct the text and then try again.)

Do you have a sample XML_FILE_BLANK you can share?

Answer 5

We were doing that in the NW2 project: import an empty data macro.

Example:
LoadFromText acTableDataMacro, "Customers", XML_FILE_BLANK