Skip to main content

Notifications

Microsoft Dynamics SL forum
Unanswered

Chr function no longer works

Posted on by 280

I'm working in SL 2011.  There is an old VBA customization, imported from SL 6.5, that has been working fine up until a week ago.

The first error message, which we got upon opening the screen, was due to the event code from the customization going AWOL.  I took care of that by restoring the customization.  I then ran the report successfully.  I asked what happened on the system, and I was assured that no changes were made in SL, but they had installed QuickBooks on the same server.

One week later, same report, different error.  The customization code is still there, but it gives me a compile error because it doesn't recognize Chr(9) (code for tab).  Just to see what would happen, I replaced Chr(9) with a simple space.  It was willing to print the report - for the entire database and not just the past week.  I killed it before it could decimate an entire forest.

Has anyone encountered a situation in which Dynamics SL forgot how to speak VBA?

  • Bev Kaufman Profile Picture
    Bev Kaufman 280 on at
    RE: Chr function no longer works

    Never mind.  I just figured it out.  I should have been using PRMSEP instead of Chr(9) - and I have a nagging suspicion that this is a lesson I had to learn before.  Maybe when I restored the customization last week, I grabbed one with whiskers.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans