Search results

I need to bill people monthly within a set period and within a set budget. My table (tB) has fields (M1 etc) each representing a month’s billing. Because the query coming from it uses a lot of itineration (carrying forward of balances, each with quite involved Iif statements, I keep getting...

Thanks, Anna, for your prompt response. Sorry if I appear dumb, but this is my first VBA day although I have two year’s experience in designing in Access 2000 the conventional way (tables, queries etc). I tried the code below incorporating your suggestion and it locked on the very first...

How does one invoke, call up or insert the name of a table cell or query cell in a VBA routine. Is it [table].[cell]; or table.cell; or table!cell or what. Thanks.

Im using a series of expressions containing IIF statements to carry forward (itinerate) balances. I get this message and sometimes "System resource exceeded". I'm not using nested queries nor, do I think, too many fields. Access Specifications don't mention any such limitation. Im using...