Search results for query: *

Peter, In your text you said you create company. Do you do this by Creating an Empty Company in ES? Then use SQL to restore the existing database bak file into the new database?

Support and some contacts I have...

I agree.. Backup/Restore seems easier and less prone to error. That's why I was curious if there was some advantage to doing it via detach/attach... Thanks

I asked around. Was told script was problematic...and could not find one that anyone would support...

I've noticed in some of the Macola ES docs when copying a company to create a new test company in a SQL 2000 environment, they typically tell you to do a detach, copy and attach. I would normally just create a blank ES company, do a SQL backup of the original database to bak file and Restore...

Yes, it's a network printer, served off of a different server than macola server, print driver installed on server (i believe, will double-check. Initialized report passing file, print default files...

Problem is that when I say quarter, I mean our Reporting quarter which may not correspond to 3/31 6/30 9/30, etc.. Would need to determine 'quarter' by formula

Sorry.. Version is 8.5

Anyone have any thoughts on how to approach this? Sales manager wants a report summarizing sales by quarter and/or year. Would like to be able to do everything - run for 1 quarter or range of quarters or likewise for years or combination of years and quarters. This is all working off of...

Have a Macola ES question. If I want to create a new test company by copying my production company to a new company, ES still shows the original company number in the screen headers within ES? It shows the correct company when entering ES, but once I'm in it still shows the old company. I...

Thanks everyone... Looks like hyphens are ignored in sorts unless all the other text is identical.. Thought I was losing it... Thanks!!

Either did I.. Very strange...

Just saw this on-line.. Apostrophes and hyphens are ignored unless two cells are identical except for the presence of an apostrophe or hyphen. For example, Co-ordinator follows Coordinator. Does excel sort ignore hyphens?

Shouldn't it be printing PM- PMA PMB PMC Why is PML between PM-L and PM-N?

PM-LBL-UNSC-3.5 PM-LBL-UNSC-3.5 PML-BTL-1/2 OZ-CLEAR PML-BTL-1/2 OZ-CLEAR PML-BTL-1/2 OZ-CLEAR PML-BTL-1/2 OZ-CLEAR PM-N-BX-BALS-3.5 PM-N-BX-BALS-3.5 PM-N-BX-BALS-3.5 PM-N-BX-BALS-3.5...

yes, set for General....same thing...This is weird...It's treating the -very weird

Exported a spreadsheet out of access. Now am trying to sort data. For some reason will sort PM-LA PM-LB PML-1 PM-N Almost like it is ignoring the -. I would think it would do all the PM- together????

Have an OKIDATA 591 that prints our Order Acknowledgement and Invoice forms in a Progression 400a environment. We upgraded to a new Macola server in addition to upgrading to 400a from 300c. In addition to all this we upgraded a separate server from 2000 server to Windows 2003 Server. This...

Lost me again...So I run an MS QUERY against my datafile.xls and somehow I manipulate the file. So I would run my Crystal Report, which creates the datafile.xls then run this MS Query against the datafile to prep my data. Then I would be able to open and refresh my Pivot Table (which is another...

The crystal report creates the Excel spreadsheet which is the datafile for the PivotTable. Crystal creates a completely new data file upon it's execution