Closed Thread
Results 1 to 2 of 2

Method or data member not found - Creating a String

  1. #1
    Registered User
    Join Date
    11-07-2013
    Location
    Kidderminster, England
    MS-Off Ver
    Excel 2003
    Posts
    6

    Method or data member not found - Creating a String

    *** Please ignore - it was a typo after all!! Sorry if anyone's time was wasted ***


    Hi all.

    I'm having a very weird error on a straightforward piece of forms code:

    tmpStringNotes = "Payments and correspondence being handled by " & SUAgreement.Account_Name & " - " & SUAgreement.Account_Address

    This gives the Method or Data Member not found error highlighting SUAgreement.Account_Name as the problem. It definitely does exist on the form named SUAgreement.
    If I remove the second control and leave the code as shown here:

    tmpStringNotes = "Payments and correspondence being handled by " & SUAgreement.Account_Name

    it works fine. I can't see anything wrong with the syntax that concatenates the two values with a space dash space between them.

    Any help would be much appreciated.
    Last edited by dsajones; 05-23-2019 at 06:39 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Method or data member not found - Creating a String

    I'll close the thread just to be sure. Cheers

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Method or Data Member Not Found
    By adbrad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2016, 09:05 AM
  2. Method or data member not found
    By Rob K in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-27-2015, 03:50 PM
  3. Compile error:Method or data member not found
    By vshukla in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2015, 11:44 AM
  4. [SOLVED] Error: Method or Data Member Not Found
    By k64 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-21-2015, 08:39 AM
  5. Method or data member not found
    By katieshields in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-02-2014, 08:49 AM
  6. [SOLVED] error: Method or Data Member not found
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 11:01 AM
  7. Method or Data Member not Found
    By Syed Haider Ali in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2005, 09:27 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1