Results 1 to 5 of 5
  1. #1
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480

    Easiest Question Ever

    Code:
       If InStr(oIE.Document.Body.innertext, "New User Request") > 0 Then
       Call EfrmAdd
       End If
    I receive an error saying "Compile Error" "Expected variable or procedure, not module"

    EfrmAdd is on a different module, but why can't I call it...any ideas?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Is that the line that errors? Is that a Public procedure?

  3. #3
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    When it hits " Call EfrmAdd " thats when I get the error. At first it was a basic sub, I tried making it public but that failed as well.

  4. #4
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    Wow, I need more redbull.... I named the module and the sub the same thing... Is it friday yet?

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    That was going to be my next post. You're awake now so good job.

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

Similar Threads

  1. The easiest way to make a point of sale
    By eskybel in forum Queries
    Replies: 79
    Last Post: 11-20-2012, 07:30 AM
  2. Replies: 4
    Last Post: 08-25-2012, 07:19 PM
  3. Replies: 6
    Last Post: 09-01-2010, 03:12 PM
  4. Replies: 5
    Last Post: 08-20-2010, 09:10 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