User Profile

Collapse

Profile Sidebar

Collapse
Yongo
Yongo
Last Activity: May 26 '11, 02:18 PM
Joined: Nov 17 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Yongo
    replied to Sub or Function not Defined
    Thank you for your reply but I don't thing is a problem of quote or bracket. Because these variables are controls name in the form. Printing the SQL i can't since when the code enter the specific sub, it display the message highlighting my controls name. And not only in one computer but I found the same message in two differents application. Can it be, a software bug or what?
    See more | Go to post

    Leave a comment:


  • Yongo
    started a topic Sub or Function not Defined

    Sub or Function not Defined

    I am getting error sub or function not defined when I am trying to save data into my database using values on controls defined in the form. The application is seeing the control name as a name of function or sub here is the code
    Code:
    If isCompanyNameExist(CompanyName) = False Then
     strSQL = "INSERT INTO Companies (CompanyID, CompanyName, PostAdr, treetAdr, AreaID, ContactID) " _
    & "Values('" & CompanyID
    ...
    See more | Go to post
No activity results to display
Show More
Working...