Results 1 to 3 of 3
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    Form will not save in Proper Format


    In the db file that I have attached with a pdf file there is a screenshot of what I am talking about. The first instance of the RunMacro command is like this:

    Do.Cmd.RunMacro ("FormHeading - MAC")

    and that is incorrect when it should be like this:

    Do.Cmd.RunMacro("FormHeading-MAC")

    The second line is the correct one! However, when I modify the first line the to look like the second line and then save it. The first line is saved - not second line.

    This is critical since only the second line is correct. The first line running in the software causes a software crash.

    So how do I save the file once I have changed it and the files remains as the second line, with no corrections back to the first line?

    Any help appreciated.

    Thanks in advance.

    Respectfully,

    Lou Reed
    Attached Files Attached Files

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Do.Cmd.RunMacro ("FormHeading - MAC")
    That is not what the code has. Your code does not have the quotation marks around the macro name, so Access thinks it is an arithmetic expression and puts in the blanks.

  3. #3
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Okay, thanks very much. I will correct that. It just seems it would not save it the way that I wanted it to be saved.

    Respectfully,

    Lou Reed

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

Similar Threads

  1. Replies: 4
    Last Post: 10-10-2016, 10:12 AM
  2. Creating Proper format on Address Direction
    By wes9659 in forum Programming
    Replies: 11
    Last Post: 09-03-2014, 06:40 PM
  3. Replies: 1
    Last Post: 06-29-2014, 01:40 PM
  4. Replies: 2
    Last Post: 09-19-2013, 10:22 PM
  5. Open / Save as Excel File and specifiy format
    By jaykappy in forum Access
    Replies: 8
    Last Post: 03-24-2009, 03:26 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