Search results for query: *

Macola 7.7.3 SQL 2008 R2- Are there any repercussions if I purge the gltrxhst file? Mine is huge. Thanks, Vanessa

When I log on as Supervisor and go into Designer, I right clicked on the page, go into Special and "The Add Entry Field" is grayed out. Is there something else I need to do? Again thanks for your help.

That sounds great! But I have never added a vba only field. Where do you add that in designer? Thanks again!

So, If I break up 1 30 char UDF into 2, then how do I show two separate input fields on the order entry screen? Thanks for your help.

I have Macola Progression 7.6 SQL 2008 R2/Designer & Flex. My problem is I have used all 5 of the UDF fields on the Oeordhdr table. I need 2 more fields for the order header, not line. If anyone has any suggestions on how to handle this I would appreciate your help. Thanks.

That's what I was afraid of. Unfortunately this is a MYSql Database for TimeIPS software. I have read rights only to it. I guess I will have to do the mock crosstab. Thanks for responding.

Crystal 2011- SQL 2008 R2 I have detailed payroll records with time in and time out for each employee. I need to be able to total up hours by Reg Time and OT by week by quarter. The problem is my week starts Sunday's at 7:00am, so if an employee punches in Saturday night at midnight and...

Thanks all for your input!

Progression 7.7.6 SQL 2008 R2 I can't find anything on Exact's web site about installing on a virtual server. Has anyone done this and is it supported? Thanks.

Thanks so much for the feedback!

Progression 7.7.500

Is anyone using the new F9 Version 5 for Macola. We will be upgrading to SQL 2008 and want to upgrade F9 as well. Any problems or thoughts?

Currently my company is on Macola Progression. They would like to be able to have more description in the GL. In AP entry in Macola ES is there the ability to enter more description for each GL account entry on an invoice/voucher? If so does this carry to the GL transactions? Thanks

Macola Progression 7.7.200 SQL 2000- Does anyone know how the localization kit in the GL works? It looks like it puts the vendor/customer number in a separate field acct_id in the gl transaction history table. My company would really like to use that feature, so it would give them more room in...

Thanks AceMan for getting back to me. I did make an Update Query to add one to the CurrentRunNo (integer in table, but displayed in text box txtCurrentRunNo on form). Then in code I used the following in the click event of my button: DoCmd.OpenQuery "qryQCUpdateNextRunNo" (this update query...

Thanks so much for replying, but I guess what I am asking do I use a SQL update command to update that record or do I have to actually open & close a recordset and update it that way? I was just afraid since the record is open via the combo box query it would be locked and not let me update it...

I am not quite sure the best way to do this. I have a combo box that uses a query on table tblQCMillMatCstType. I then display in a locked text box on after update of combo the following: txtCurrentRunNo.Value = cboMatCstType.Column(3) (which is CurrentRunNo in that table). I now want to...

Thanks I will look into that and see what I can do.

We use POP (Enter Production/Report Production).

Macola Progression 7.7.200 SQL 2000 Flex Has anyone written any Flex code (or is it even possible) to put production entry (serial lot) on lot hold automatically. I want all of our production lots and pallets on Lot hold until it is QC'd. And I don't really want to use another location to do...