Search results for query: *

That is your issue, the new MSL files should be unzipped to the Macsql\msl folder

Patrick, Honestly I cannot remember the last time I used Creystal Runtime with VBA, so I don't really know.

I meant to post your formulas that return the 2 dollar amounts, not the interest rate. Please try again.

Please share your current formulas.

fieldname.setfocus can work but has severe limitations vs sendkeys. This thread has some interesting discussion: https://www.vbforums.com/showthread.php?874379-RESOLVED-SendKeys-replacement Macola and Sage 50/Sage 100 Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

Create a parameter field, call it {?Part}. Then create a record selection formula like this: {MyPartNumberField} = {?Part} Macola and Sage 50/Sage 100 Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

7.9.340 is supported all the way through SQL 2019, all updates. Macola and Sage 50/Sage 100 Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

CU meaning? Macola and Sage 50/Sage 100 Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

You are supressing rows, which is a very bad idea. Supressed rows are still part of the report and will be included in any subtotals or grand totals of the report. You need to exclude these records from your report entirely with a record selection formula. Macola and Sage 50/Sage 100...

Crystal 8.5 came out in 2001. I would try this in a much newer version of crystal. Macola and Sage 50/Sage 100 Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

So you have IMDISFIL_SQL records with a Y in the int_fg field, but there is no corresponding record in the GLTRXFIL_SQL table? Did I get that right? The reason I asked about the "Interface To G/L Journal Trx File" flag is if it was checked, it is possible it was never posted or even deleted...

The IMDISFIL_SQL is the staging table. There is a field int_fg which indicates with a Y or N if that transaction has been posted to subledger or not. In your GL setup, there is a checkbox "interface to GL Jrnl Trx file?" or words to that effect. Is this box checked or not checked? Macola and...

I have start and end times that are stored as varchar such as "0700", "1600", etc. How do I convert these to time? Macola and Sage 50/Sage 100 Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

I have little experience with Cross Tab reports. I inherited one with month names as columns. But the sort is April, August, December, etc. - Alphabetic sort. How do I get this to sort as January, February, March, etc.? Macola and Sage 50/Sage 100 Consultant Check out our Macola tools...

In the BacoAppLog table, it logs every time you open an application in Macola ES/Macola 10. For example MACMDEBITR.slc is the entry made for customer maintenance. Is there a list or table that holds the English description of this? Macola and Sage 50/Sage 100 Consultant Check out our...

I just saw a case of a cycle count batch that is returning incorrect data on the pre-post register of "Post Count Tags". No external input from Wisys or any other application is being used. This will happen 3 or 4 times and they have been re-creating the cycle count batch to solve it. A very...

7.8.what? There is no 7.8 Server 2022 and SQL server 2022 are not even supported by 7.9.340, which is the most current version of Progression. Macola and Sage 50/Sage 100 Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

Coorsman, I have an excel VBA function that creates a GUID value. I tested it on 1 million records and it never duplicated. Will that help? Macola and SAP Business One Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

Looks like a GUID field to me. Can you confirm? Macola and SAP Business One Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

Its been 15 years since I worked with Pervasive SQL. I want to create a view. Here is my code to do so: CREATE VIEW "ItemBeginningBalance" AS select i.ItemID,i.ItemDescription, sum(c.quantity) as BegBal from LineItem i left outer join InventoryCosts c on c.ItemRecNumber=i.ItemRecordNumber...