Results 1 to 5 of 5
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,919

    Access can't find a module via macro


    Seems simple enough, AutoExec macro runs a function that gates whether app is running un-attended as a scheduled task or is being opened for access to DB elements. The AutoExec macro is to run a function called NASCopyGate. The NASCopyGate function examines the CMD parameter to determine how to proceed, either call the app's primary Sub NAStoUSB or do nothing, which would leave the DB at the database window.

    As you can see from the composite screenshot, the function exists and the macro is coded accordingly. Obviously, I'm not seeing something.

    Maybe I just need a nap

    Thanks,
    Bill

    Click image for larger version. 

Name:	MacroProblem.jpg 
Views:	6 
Size:	166.2 KB 
ID:	22280

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Hi Bill! The module and function can't have the same name.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,919
    Hey Paul, Yes, I failed to follow my own convention. I always prefix module names with "Mod", like you see with the other two................. long day

    Thanks,
    Bill
    (PS) We need to have lunch sometime soon.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I noticed the other two were prefixed. Any time for lunch!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    1,919
    Okay, thanks.

    Hi to Mrs B.

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

Similar Threads

  1. create excel module/macro with access vba
    By trevor40 in forum Programming
    Replies: 3
    Last Post: 02-01-2015, 08:55 PM
  2. Replies: 8
    Last Post: 06-27-2013, 11:58 AM
  3. Replies: 9
    Last Post: 03-16-2013, 11:10 AM
  4. Replies: 4
    Last Post: 03-13-2013, 08:57 PM
  5. Converting Excel Macro into Access Module
    By diddyville in forum Modules
    Replies: 1
    Last Post: 03-28-2011, 07:02 PM

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