Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AndrewForrest

    Flex Code in Macola Progression 7.9.330 on SQL server 2019.

    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...
  2. AndrewForrest

    Flex Code in Macola Progression 7.9.330 on SQL server 2019.

    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...
  3. AndrewForrest

    Macola Activx

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

    Macola Activx

    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...
  5. AndrewForrest

    Upgrade Macola to 7.9.300 on Win2016 & SQL1026

    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...
  6. AndrewForrest

    Upgrade Macola to 7.9.300 on Win2016 & SQL1026

    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...
  7. AndrewForrest

    Upgrade from Macola 7.8.900 to 7.9.300 - Post invoice problem

    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...
  8. AndrewForrest

    Upgrade from Macola 7.8.900 to 7.9.300 - Post invoice problem

    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...
  9. AndrewForrest

    Upgrade from Macola 7.8.900 to 7.9.300 - Post invoice problem

    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...
  10. AndrewForrest

    Upgrade from Macola 7.8.900 to 7.9.300 - Post invoice problem

    ...printed invoice - printed correctly = Yes. order status = 9 Printed Pre-Post invoice list - invoice on list run post invoices message ****************************************** **** Distributions Are Out Of Balance **** **** (Or Total-Sales-Amount Is Not **** ****...
  11. AndrewForrest

    Upgrade from Macola 7.8.900 to 7.9.300 - Post invoice problem

    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...
  12. AndrewForrest

    Report Writing in Word - Draw lines Using VS2005/VB.

    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...
  13. AndrewForrest

    Select method of Range class failed when building Excel SS

    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...
  14. AndrewForrest

    Select method of Range class failed when building Excel SS

    ...xlSheetCol = xlBook.Worksheets("Sheet1") xlSheetCol.Name = "Full List" With xlSheetCol strSql = "A1:P" & iRowEnd '********* this bit fails .Range(strSql).Select() '********* .Columns.Select() .Columns.NumberFormat = "0.00"...
  15. AndrewForrest

    DATE INPUT

    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...
  16. AndrewForrest

    Importing into PO Module.

    Hi Zedsded, We also need to import production info from an external source which we do with a Visual Basic program we also need to produce multiple items from a single item which Shop floor orders do not do very well, which we do through PO using Flex code. The PO using flex code works through...
  17. AndrewForrest

    VB2008 How to search Listbox for match to Textbox.Text

    Just a thought, Why not use a ComboBox with "AutocompleteMode" = SuggestAppend "AutocompleteSource" = ListItems "Don't worry about the world coming to an end today. It’s already tomorrow in Australia." - Charles Schulz
  18. AndrewForrest

    What file to link to

    Hi Mariegee, What version of Macola are yourunning and what are you using to produce this report ? "Don't worry about the world coming to an end today. It’s already tomorrow in Australia." - Charles Schulz
  19. AndrewForrest

    Macola 7.7.100 Development options

    Hello, Don it's funny, as a long time and heavy user of ERS5 I have been told for years that it is no longer supported, however it was upgraded with the release of 7.7 and Macola are still using it to front end the "New" Crystal Reports. Regards "Don't worry about the world coming to an end...
  20. AndrewForrest

    Sales tax

    Hi, Try [Tax_Amt] about 2/3 down the OELINHST_SQL table. Regards "Don't worry about the world coming to an end today. It’s already tomorrow in Australia." - Charles Schulz

Part and Inventory Search

Back
Top