Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Remove unused VBA Window in Dynamics

Posted on 2011-02-18
21
Medium Priority
?
825 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
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 2000 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
 

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 2000 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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

610 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