Recent content by stapes

  1. S

    #ERROR? in Memo Field

    What a complete waste of space that was. dbforums.com would not let me in without consent from a parent. I am 52 years old!!
  2. S

    Is there a way to disable all controls on a form w/out specifying them by name?

    Well does anyone have an answer i.e. to get it working on a subform ???
  3. S

    DoCmd.CloseReport "blah"

  4. S

    DoCmd.CloseReport "blah"

    This is an accountancy application, and the calculations involved are far too complex for a single query. I solved the problem anyway. I was using the wrong syntax as expected. It should have been: DoCmd.Close acReport, "blah" Stapes
  5. S

    Using data from subReports

    Hi Today I am trying to use data from a subReport in the calling report. It works fine if I have data for the subReport, but on occasions there will be no data, so the subreport is empty. On this occasion I just get #error in the field. I have tried IsNull, IsEmpty, IsMissing all to no avail...
  6. S

    DoCmd.CloseReport "blah"

    Hi The above doesn't work - I guess it is incorrect syntax. I am running a script that needs to run a number of reports for several preceding periods and carry forward some totals to the following report. The script accesses the report output like so: PMinus3ESPAll =...
Top Bottom