Results 1 to 3 of 3
  1. #1
    RoyLittle0 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2012
    Posts
    25

    Error Data macro could not be found

    Hi,


    i am running a modified Northwind Traders database and have come across an error that i have not seen before, when i add a purchase order and select the product, the Macro looks up the item price and insert it in the field, but now it is not working, it is obviously something i have done, but i have been modifying this database for some time and cant see any differences between a working backup and the none working copy, i have made numerous other changes to the database so its not as simple as reverting back to the backup, unless i have to.


    Code:
    Products.GetStandardCost	{CC671F14-88F5-45BD-BF65-8CB6CA5E1DA3}	-8979	Execution	Macro	The data macro 'Products.GetStandardCost' could not be found.		25/12/2012 17:03:45

    PurchaseOrderLineItem : cboProductID : AfterUpdate
    Code:
    OnError
    GotoMacro ErrorHandler
    /*Determine standard cost for specfied product*/
    If Not (IsNull([cboProductID])) Then
    RunDataMacro
    Macro Name Products.GetStandardCost
    Parameters prmProductID
    SetProperty ControlName txtUnitCost
    Property Value
    Value=[ReturnVars]![retStandardCost]
    Else UndoRecord
    DeleteRecord
    RunMacro
    MacroName Utilityies.ErrorAlert


  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    That message is saying:
    The data macro 'Products.GetStandardCost' could not be found.
    Does the 'Products.GetStandardCost' Macro actually exist?
    If it DOES exist - are you able to run it independently?

  3. #3
    RoyLittle0 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2012
    Posts
    25
    The DesignView
    Click image for larger version. 

Name:	Untitled.jpg 
Views:	5 
Size:	181.7 KB 
ID:	10475

    The Macro
    Click image for larger version. 

Name:	Macro.jpg 
Views:	6 
Size:	86.2 KB 
ID:	10474
    The macro does not run independently, it gives an error of "The object doesn't contain the Automation object 'cboProductID.'

    I have copied the form and macros from my backup, which works to this database and that doesn't work either, so it looks like the fault is not with the form/macro but with something else?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Method or data member not found
    By papa yaw in forum Programming
    Replies: 5
    Last Post: 12-17-2012, 02:19 PM
  2. Compiler error: Method or member not found
    By JosmithTwo in forum Programming
    Replies: 3
    Last Post: 11-26-2012, 07:10 AM
  3. Replies: 7
    Last Post: 06-08-2012, 09:55 PM
  4. Replies: 2
    Last Post: 05-05-2012, 02:34 AM
  5. Compile Error: Method or data member not found
    By subtilty in forum Programming
    Replies: 5
    Last Post: 02-09-2012, 07:56 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums