Search results

PS to my reply to Rich. I realise it may read as a little tetchy. The form I wish to produce contains a lot of calculations with many more lines of textboxes and more VBA. If I used a query just for this section I still have do a further query or another section and then another and then...

Thanks for responding. Believe me, any query I try to do for this gives me "Query too complex". Also this section is only a small part of what I need to do. And anyway, I need to know how to invoke tables in the future. So please, HOW do do you do it? I've 5 books on VBA but NONE tell me how.

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, Harry, for responding. My posting should have been a thread on the same subject 13 postings previously, first replied to by "Anna". That may make more sense. Thanks again.

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

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