Recent content by AndrewForrest

Hi Dan, Thanks for your assistance, I managed to get on line with a Macola Tech, and we seem to have sorted this out, we needed to apply VBA65-KB974945 patch and reboot the server. The Macola client is now running with Flex & ERS on the SQL server. I have also installed the client on another...

Good Day, We are upgrading to Macola 7.9.330 on a new SQL server 2019, Standard Macola is up and running but we are having problems with screens containing flex code. I have check with ECi and have been told that Flex should work! @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Case ID: xxxxxx Account...

Sorted "Don't worry about the world coming to an end today. We're already in tomorrow in Australia."

Hi, Moving from Macola 7.8.900i sever/SQL 2012 to 7.9.330 on 2019 Sever & SQL. Until tested we do not want to mess with the production box. So we are setting up a virtual server the same as our production server to act as a jump box, however there is not a 7.8.900 install just update, we have...

Hi Peter, Thanks for responding, Yes they where and yes they do, we have solved the problem. Because we are a Australian/European based company when we set up servers we install English/Australian and get rid of the English/USA language pack. What we believe happened is that when we removed the...

Hi All, Next Stage of the upgrade.... Having solved the invoice post problem on 2012 platform we have now created a new Win 2016 server with SQL 2016 and installed Macola 7.9.300 Previous upgrade for 2012 was 7.8.900 bring over database and then upgrade macola to 7.9.300. Win 2016 upgrade...

Hi Don, Sorry did not see your post of the 4th, I was on factory shutdown. I have received a response fro ECi with a hot fix "Prog79300UHT.zip" this seems to have fixed the problem, back to testing.... The problem (was also in Macola ES), occurs when you have the same item and lot number...

Hi Don, No, no resolution yet - ECi are looking at it but no joy, the latest hot topic has been installed, my understanding is that we are not the only ones with this bug/problem, it may be to do with older item records. Happy Safe & Prosperous New Year to you and yours. Andrew. "Don't...

No I had not taken the orders back to status 8 - good catch,. I have now taken all the orders back to status 8, i have tried printing and posting the orders 1 at a time - taking each back to status 8 after it failed. "Invoice on List" means when i ran the pre post report the invoices where on...

Hi Don, apologies. I invoiced from an existing order type O (created prior to the upgrade). select for billing - bill certain items selected item to ship entered Qty to ship, ticked selected and then selected the serial-lot exited out viewed Billing Info printed invoice -...

Hi, We are in the process of upgrading to Macola 7.9.3 and moving to MS server 2016 & SQL 2016, at present we have just upgraded to 7.9.300 on MS 2012 & SQL 2012. we create a separate SQL box and installed Macola 7.8.900,created the companies brought the databases across and then upgraded to...

Gooday, I am using VS2005/VB to create a report in a word document format, my problem is that when I draw a line on page one it appears but lines drawn on page 2 + donot. some of the code is below - any Ideas?? Thanks. Imports Microsoft.Office.Interop.Word Imports Microsoft.Office.Core...

Thanks Djang, I will give it a go. I use .Activate() when I switch to the 4 other sheets, but as I have 50+ lines of code loading cells between xlSheetCol.Name = "Full List" and With xlSheetCol which all work ok, it seemed redundant. "Don't worry about the world coming to an end...

I am getting an intermittent problem "Select method of Range class failed" whilst building an excel spread sheet from a VS2005 VB program. I have tried both xlSheetCol.Range("a1:p34").Select() and xlSheetCol.Columns("A:P").Select() they both work in testing for a while and then give...

Sorry don't use 2008 but in VB2005, you can use the datepicker to do both calander and manual entry - I have set the 'Custom Format' to "dd/MM/yyyy" (euro date format) - vb Month = MM, minute = mm, and then 'Format' = Custom, but it will work for 'Format'=Short when you enter the control just...