Results 1 to 4 of 4
  1. #1
    KH Ahmed Bara is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2013
    Posts
    13

    VBA environment Does't support some Punctuation marks

    My Access 2010 VBA environment does not support some of punctuation marks. any help please

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Be more specific.

    If you are having trouble with ' or " marks those are to indicate strings if you are trying to indicate a single " mark in VBA you have to use something like

    Code:
    if instr(STRINGNAME, """") then
        debug.print "there is a "" mark in the string"
    endif
    similarly if you are manipulating a SQL string and a ' (or ") mark appears in any of the string fields you might have some difficulty.

  3. #3
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    What punc marks? In what context? Example? Question? Statement?

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    As redbull has suggested, "VBA environment does not support some of punctuation marks" isn't really a question...we need specifics of the problem(s) you're having in order to help you.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Ho to obtain TOP 5 marks
    By Som in forum Reports
    Replies: 21
    Last Post: 01-22-2015, 11:41 AM
  2. Replies: 5
    Last Post: 10-19-2014, 09:52 AM
  3. InStr() and quotation marks
    By Puebles in forum Programming
    Replies: 3
    Last Post: 11-22-2013, 07:36 AM
  4. Replies: 13
    Last Post: 07-05-2012, 10:33 AM
  5. Punctuation blowup
    By davisgwe in forum Access
    Replies: 2
    Last Post: 09-15-2011, 02:58 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