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

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.

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

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.

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

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

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

Macola 7.7.200 SQL2000- Since upgrading from 7.6.300 the lose focus event doesn't seem to be firing consisently. I have a message box in the lose focus event of the Collect\Prepaid drop down box on the Order Entry screen if the freight code is P. If I tab through all the fields it fires the...

This seems to me to be a simple thing, but alas I can't figure it out. I have a combo box -cboSelYearMo. My query for the combo box is as follows: SELECT DISTINCT Format([DateforYear],("yyyymm")) AS SelYrMo FROM tblPPDates; That seems to be working fine. My subform works off a query of the...

Weird, weird problem Crystal 8.5 - Access 2003 query I have created a bar chart based on grand totals. I can create it and it looks fine - meaning the 4 bars are different colors and it has pretty legend. However, once I save it or go to the chart expert and change something, then all of the...

Macola 7.6.300b SQL2000 I have a user that only has PO module access. Today I was told that she needed to be able to enter, edit & post AP vouchers. I gave her access to these menu items, however, the Enter Vouchers won't work. I thought maybe it had to do with she needed access to add a...

Access 2003- I have 3 forms: Main Form- frmProductionForecast SubForm 1- fsubProductionForecast SubForm 2- fsubProductionForecastPivotTable I am trying to requery the subform 2 after updating a field on subform 1(they both use the same table), but to no avail. I can put the code in a command...

I have inserted the Execute statement in the following code below to run an update query to update the date the labels were printed. It works great, however, when I go to design mode after testing, I get the error "You do Not have Exclusive Access to the Database". I physically have to get out...

Macola 7.6 300b SQL- A user just brought it to my attention that when she goes to add a customer the alternate address field disappears when she tabs out of customer number. It comes up when you maintenance a customer, but disappears on an add. I do have custom screen sets, so I copied the...

Once again I thank all who contribute their knowledge here, because without this forum, who knows how long it would have taken me to do this project. Now the problem.. I have a tabbed form and when the user clicks on page 2 I want the program to automatically select the 1st row of the subform...

I am new to programming in Access 2003. What is the perferred method of creating a database, but continuing to develop more code. I want to implement part of the database, but continue to work on the second phase. Do programmers use a test database for further programming or do you have test...

I want to update a linked excel file in Access with a field from a linked SQL table. This is the query. UPDATE BudgetUpload INNER JOIN dbo_IMITMIDX_SQL ON BudgetUpload.[Item No] = dbo_IMITMIDX_SQL.item_no SET BudgetUpload.[Prod Cat] = dbo_IMITMIDX_SQL.prod_cat; I get the error message -...

Macola 7.6.300b SQL2000 We upgraded our Symantec Anti-virus to Endpoint Protection 11.0.MR1. I have noticed that some of the data intensive processes seem to hang, but the process will finally finish. I have tested the same processes without the anti-virus and it runs up to 6 times faster...