Search results for query: *

Hi Eva Marie, We use Progression, but I cannot imagine there are great differences between the two packages. In Progression, there is a Shop calendar located under MRP, Maintenance, Calendars. Make sure whatever Calendar Number you are using has an end date out into the future. The second...

Hello, Has anyone written SQL queries to report on SQL database statistics? Like how many Sales Orders received how many sales order line items received, Purchase Orders and Purchase Order Line Item over a specific time period? These queries could get pretty involved with blankets purchase...

Good Luck

??? The id and password for the database are in the script. Here is the scenario in order to make this work in Excel 2010. Openthe workbook, change dates which will affect the query. Press the button to run the macro, get the Timeout error above, click debug and remove a character from the...

This does not explain why it works after I intentionally break it and then fix it by changing the password. I was looking to get some specific OLE/Excel 10 help. The code works just fine, just it isn't logging into the database when the workbook is initially opened. Changing the database...

I have no idea what this means: object, object group or variable and Add Watches

Well that doesn't appear to work the print screen states: Microsoft Excel Objects Sheet1 (Sheet1) Sheet2 (BMB) Sheet3 (RNM) Sheet4 (FFD) Sheet5 (TUM) Sheet6 (MTV) ThisWorkbook Thanks Again Rich

http://www.strawbridgepta.org/public_html/VBA print screen1.png

Hi Skip, I have attached a print screen. I think this will answer your question. I did not write the macro or the VBA code.http://www.strawbridgepta.org/public_html/VBA print screen1.png

Hello, My company recently migrated to Windows 7 and Excel 2010, the below macro used to work in Windows XP and Excel 07. The first time the macro is run I get a: "Microsoft Visual Basic run-time error '-2147467249 (80004005)': Query timeout expired Here is the code: Sub ImportMacola()...

Hello, My company is in the process of virtualizing all of our servers. The CIO is pressuring me to migrate the Macola progression application. I did find older posts where most describe the process as working. Are there currently any Macola installations running on VMWare 4.0 or 4.1...

Hi Dgills, Sorry you are correct the packing slip, I don't know why I have been calling it a pick ticket. I did added the fields to the form and they seem to print correctly. I will need to do more testing. Thank you for your time and help. Rich

Hi Dgills, Yes Progression 7.6.300c, we are using EDI, but I dont see how that would matter. Rich

Hello, All I am looking to do is add two fields into the Pick Ticket printout. The two fields will 1. calculate the total number of cases being shipped and 2. calculate the total weight of the items being shipped. As I stated before, these two fields were already added to a custom purchase...

Hi Dgillz, No I need additional fields added to the Pick Ticket printout. When we print out a Purchase Order there is a line that is printing Total Cases in the SubTotal area, after the line items. The Total Weight line is printing in the trailer area. I need these two fields to also print...

Hello, I have a custom Purchase Order form that is printing out Total Cases and Total Weight. I would like these to also print out on the Pick Ticket form. One field is total cases where the UOM is calulated out from the Qty. Ordered per line then printed at the bottom of the line items...