@Brandon Hayes The issue you are having is because you need to add .Value For example Field.Value = "test" .Value is optional in VBA but it isn't in C# or VB.Net. I would seriously look at using GP Power Tools to replace your VBA, much simpler, ...
Yes.. Though you have to be careful as you're going from one version of GP to another and there might be table changes in between.. This move would require careful planning ahead of time to make sure not miss anything at the table level.. I'd really ...
Do you mean using SQL Server's bulk export and import to copy all data from all tables into a new company? Just want to make sure I understand so I can consider all of my options. ------------------------------ Jon Godwin Database Administrator Boulder ...
That is indeed quite huge.. one more reason to not upgrade the historical companies at the same time as your LIVE database. I remember a forum response a long time ago where someone posted that their GP LIVE companies data was so huge that it couldn't ...
HI, @Beat Bucher . Thanks for the follow-up. Our company DB sizes are Production - 300 GB History 1 - 140 GB History 2 - 340 GB I'm going to do a round of testing where I try running the upgrades simultaneously to see how much it speeds up the process. ...
Hello all, Our GP install is being moved to a Windows Server 2019 box and VBA is not supported on that platform. I am trying to re-code the 35 customizations written in VBA to C#. I installed the Visual Studio Tools for GP SDK and the Microsoft Dynamics ...
Hi Jon, Though John mentioned that you can upgrade GP in parallel from different clients, it does have an impact on your overal upgrade performance.. it's not like you divide the total upgrade time by the number of GPU clients you run.. there is a loss ...
Jeff, I ran into a similar problem years ago when I was having an automated job scheduled once a week to run Inventory reconcile.. I had GPPT at the time as well and despite the order to close & exit GP at the end of the macro process, it would never ...
If you're reading this and use Word Templates to print GP documents (all of them), and experiencing all of a sudden some weird pop-ups when printing the documents to screen (see below), then it's because your computer was recently updated with the ...
It’s been a challenging year for everyone, no doubt about it. Personally, I am ready for 2020 to be over with, but we can’t wrap this year officially before ‘getting together’ at Community Summit North America ! The 14 th annual autumn gathering ...
Repost from Avalara The midyear update to our annual sales tax changes report takes stock of what’s transpired in the world of sales tax since the start of the year. It also introduces emerging trends. There’s often a surprise or two — a change ...