Solved

Remove unused VBA Window in Dynamics

Posted on 2011-02-18
21
786 Views
Last Modified: 2012-05-11
I downloaded a package for dynamics GP to a test server. the packaged had some modified forms and vba I removed most of them , but few vba code are still in my visual basic , how can I remove those form from VBA , I know that usually you go into the form click in the toolbar and remove the form from Visual basic , but I can't find the actual window listed in my VBA
here are the windows that I would like to remove, how can I find them in dynamics:
Toolbar(Window)
SalesAnalysisReportOptions (window)

thanks
David
0
Comment
Question by:taverny
  • 11
  • 10
21 Comments
 
LVL 10

Expert Comment

by:Abdulmalek_Hamsho
ID: 34929979
Well, I'm gonna give you the cleanup solution. In order to clean all of your VBA code for one dictionary, do the following:

1- Go the GP folder.
2- Delete the respective .vba file; means if your VBA code belong to Dynamics dictionary, then you need to delete Dynamics.vba. If your VBA code belong to Field Service dictionary, you need to delete SrvcAdv.vba file.

FYI, the Toolbar window is the main GP window, while SalesAnalysisReportOptions is in: Reports -> Sales -> Analysis.
0
 

Author Comment

by:taverny
ID: 34930053
Thanks but if I have other VBA code in my dynamics.vba that I don't want to delete only want to delete the one for the toolbar. how do I do that , can I go into the dynamics.vba and delete from there, if so how or is there another approach?
0
 

Author Comment

by:taverny
ID: 34930067
and I did try to remove the salesAnalysisReportOptions, from the one you told me , but it's still not removing . just to make sure when I go to Reports -> Sales -> Analysis. the one display is the Sales Analysis Reports not the option one.
0
 
LVL 10

Expert Comment

by:Abdulmalek_Hamsho
ID: 34930080
No, go the window and Rmove It from VBA. I've told in my previous post where are the remaining windows (Toolbar and SalesAnalysis...).
0
 
LVL 10

Expert Comment

by:Abdulmalek_Hamsho
ID: 34930129
You're right, I was mistaken. After opening the Sales Analysis Report window, click New button and remove this window from VBA.
0
 

Author Comment

by:taverny
ID: 34930170
This one works thanks. what about the toolbar?
0
 
LVL 10

Expert Comment

by:Abdulmalek_Hamsho
ID: 34930196
It's the main GP window, close all of the opened GP windows and remove the main one from VBA (Same one contains the Home Page).
0
 

Author Comment

by:taverny
ID: 34930226
hmm, I can't figure this one out , I click on both place noted red and It doesn't seem to show me the customize >remove vba. Am I clicking in the wrong place?
Capture.JPG
0
 
LVL 10

Expert Comment

by:Abdulmalek_Hamsho
ID: 34930254
Have you imported a modifications package from GP 8.0 or earlier version?
0
 
LVL 10

Accepted Solution

by:
Abdulmalek_Hamsho earned 500 total points
ID: 34930323
It's a bit difficult to remove the Toolbar from VBA, and I suggest you to leave it.

To remove it do the followings:
 
1- Export all of your VBA modifications to a package.

2- Edit the export file in Notepad.

3- Remove all of the lines starting from:
<Component Name="Toolbar" ProductId="0" Object="VBAForm" >
Ending and including this line:
</Component>
The you may find many lines like this "</Component>", but you need to remove the code to the first occurance after the first line as following:

<Component Name="Toolbar" ProductId="0" Object="VBAForm" >
VBAForm "Toolbar"
{
 Windows
 {
  Window "Main_Menu_1"  
  {
   EventMode "0"
   Fields
   {
    WindowField "(L) eEnterpriseUser ID"    
    {
     ArrayIndex "0"
     DisplayName "eEnterpriseUserID"
     Local "true"
     ProgrammerName "eEnterpriseUser ID"
    }
    WindowField "Company Name"    
    {
     ArrayIndex "0"
     DisplayName "CompanyName"
     Local "false"
     ProgrammerName "Company Name"
    }
    WindowField "Date"    
    {
     ArrayIndex "0"
     DisplayName "UserDate"
     Local "false"
     ProgrammerName "Date"
    }
   }
   Title "Toolbar"
  }
 }
}
</Component>

0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

by:taverny
ID: 34930807
ok so I exported all the packages and modified like you said and removed only the code for the toolbar.
now what should I do ? since if I reimport it it will only overwrite what I currently have in the package so the toolbar will still be in my system .
0
 
LVL 10

Assisted Solution

by:Abdulmalek_Hamsho
Abdulmalek_Hamsho earned 500 total points
ID: 34930819
I'm sorry, my comments above needs to be continued:

4- Delete the dynamics.vba file from GP folder.

5- Import the package you've altered in Notepad.
0
 

Author Comment

by:taverny
ID: 34930847
when I delete the dynamics.vba then I close dynamics and reopen it. it tells me that I need dynamics.vba for the Srvcadv.vba and ask me to point to it. so I put it back.
Do you think I should delete both VBA and reimport everything?
0
 
LVL 10

Expert Comment

by:Abdulmalek_Hamsho
ID: 34930856
Yes, no problem delete both. But you'll be able to delete them after closing GP only.
0
 

Author Comment

by:taverny
ID: 34930864
ok I will try that right now.
0
 

Author Comment

by:taverny
ID: 34930898
ok  I think it worked , I just have to test everyform to make sure that all of my code got imported correctly.

But here is something weird that happened. All my forms were into a folder called "Microsoft Dynamics GP Object"
now the folder is called "Interfund Management Objects"
do you think it's correct?
0
 

Author Comment

by:taverny
ID: 34930901
Never mind. I closed dynamics and reopen it and now the name of the folder is back to normal . that was weird.
0
 

Author Comment

by:taverny
ID: 34930903
Well thank you for this one, one more step done.
thank you so much.
0
 
LVL 10

Expert Comment

by:Abdulmalek_Hamsho
ID: 34930914
Any time.
0
 

Author Comment

by:taverny
ID: 34930938
well, I have alot more to do. and I would like you to be able to help me more since you did help me the most in this project.
Just to give you the heads up on what else needs to be accomplish , and of course I will open a question for each part along this project.
-I need to create a new form that will pull the price list of an item on a separate window from the RMA
( I will elaborate more on that on the question)
- I also need to modify or create a new window for the creation of an item from an RMA that will have a bunch of rules and drop down list with the manufacturer in it
- create a new VBA software outside of dynamics to enable my users to post time into a WO Job without logging into Dynamics. I have about 30 Tech and I don't see 30 computers sitting around just for them to post time to the job. and at the same time it would take too long for one take to log in dynamics post time and log out for another user to post his time.
-and some other little modification to make dynamics more friendly

so hoppefully you will be along for this project since I really like your way of thinking throught the programming .
thank you so much again for all your help on all my questions.
David
0
 
LVL 10

Expert Comment

by:Abdulmalek_Hamsho
ID: 34930950
I with other EE experts will do our best.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now