I've got a function which takes about 25 variables and is used to validate the net worth of a balance sheet. Works fine in access 97 SR-2 in the NT environment at work. Home Win 98 access 2000 chops off the last third of the expression in the expression builder:
e_NetWorth: e_NetWorth([cash_and_equivalents_year_1],[net_trade_receivables_year_1],[inventory_year_1],[other_current_assets_1_year_1],[other_current_assets_2_year_1],[other_current_assets_3_year_1],[net_plant_and_equip_year_1],[other_non_curr_assets_1_year_1],[other_non_curr_assets_2_year_1],[other_non_curr_assets_3_year_1],[intangible_assets_year_1],[notes_payable_year_1],[current_long_term_debt_year_1],[trade_payables_year_1],[taxes_payable_year_1],[other_curr_liabilities_1_yr_1],[other_curr_liabilities
Function e_NetWorth(CashEQ, AR, INV, OCA1, OCA2, OCA3, NPE, ONCA1, ONCA2, ONCA3, _
IntA, NP, CLTD, TradeP, TaxP, OCL1, OCL2, OCL3, OLTL1, OLTL2, OLTL3, NW, OverrideReason, decision, TypeFin) As Variant
The query itself has about 40+ fields using custom functions to check a database for data validity - works fast in NT, slow in Win 98 despite PIII w/ 128 RAM. Does anybody know if there is a limitation on the length of the expression or if there is a difference between NT and Win98 causing this to happen?
Any help, ideas, or clues would be very welcome.
Thanks
e_NetWorth: e_NetWorth([cash_and_equivalents_year_1],[net_trade_receivables_year_1],[inventory_year_1],[other_current_assets_1_year_1],[other_current_assets_2_year_1],[other_current_assets_3_year_1],[net_plant_and_equip_year_1],[other_non_curr_assets_1_year_1],[other_non_curr_assets_2_year_1],[other_non_curr_assets_3_year_1],[intangible_assets_year_1],[notes_payable_year_1],[current_long_term_debt_year_1],[trade_payables_year_1],[taxes_payable_year_1],[other_curr_liabilities_1_yr_1],[other_curr_liabilities
Function e_NetWorth(CashEQ, AR, INV, OCA1, OCA2, OCA3, NPE, ONCA1, ONCA2, ONCA3, _
IntA, NP, CLTD, TradeP, TaxP, OCL1, OCL2, OCL3, OLTL1, OLTL2, OLTL3, NW, OverrideReason, decision, TypeFin) As Variant
The query itself has about 40+ fields using custom functions to check a database for data validity - works fast in NT, slow in Win 98 despite PIII w/ 128 RAM. Does anybody know if there is a limitation on the length of the expression or if there is a difference between NT and Win98 causing this to happen?
Any help, ideas, or clues would be very welcome.
Thanks