Re: One for the MVPs?

Tech-Archive recommends: Fix windows errors by optimizing your registry



Hi, Rob.

> Where can I get a definitive answer, if no-one in the newsgroup(s) can help?

<Cough!> No one?!! Many of the people who answer questions in the
newsgroups can troubleshoot others' database problems most of the time with
just a few clues and after asking a few of the right questions -- without
ever laying eyes on the database itself. If you think about it, that takes
incredible talent. Many of these folks work with Access for a living, and
what assistance they offer to people in need in these newsgroups without
charge is only a fraction of the spectacular services they offer to their
paying clients.

If I needed a definitive answer but didn't already know how to troubleshoot
tricky problems in Access, I'd put my go-fasters on my feet and zoom over to
the reports newsgroup, do some research to find the consultants who can
obviously "walk the walk" and hire one of them for a fraction of what
Microsoft charges for tech support. These experts can give a lot more
valuable advice about your database by actually looking at it than they can
from reading short descriptions of what the problem is.

And remember that the data source for a report and a form can be the same,
but the resulting data set for the report can be a little different to
accommodate the formatting. Check to ensure that no formatted record exceeds
2,000 characters in the report (excluding Memo and OLE fields), because this
too will result in the "too many fields defined" error message in the report,
even with far fewer than 255 fields.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are Ripley@xxxxxxxxxxxxxxx and scott@xxxxxxxxxxxxxxxxxx


"Rob Parker" wrote:

> Thanks for the interest. Seems (from responses so far, in both this and the
> reports newsgroup) that no-one knows what the problem is, or if there's an
> alternative to my kludge subreport for totals workaround.
>
> C'est la vie :-)
>
> BTW, have you seen my other question, re copy/paste of a record? I've not
> got a useable answer to that one yet either ;-)
>
> Where can I get a definitive answer, if no-one in the newsgroup(s) can help?
>
> Rob
>
>
> "Sandra Daigle" <Invalid@xxxxxxxxxxxxxxxx> wrote in message
> news:%23tvZiV8VFHA.2796@xxxxxxxxxxxxxxxxxxxxxxx
> > Well it was worth a shot - I'm not really sure what else might be going
> on.
> <snip>
>
>
>
.



Relevant Pages

  • RE: SBSMonitoring.mdf getting big
    ... You can use the SQL Client Utilities to try and shrink the database. ... Open Server Management console, ... Check 'View the usage report in Server Management' option. ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 Server Usage Report
    ... the default layout of Usage Report is a little different ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 Server Usage Report
    ... the default layout of Usage Report is a little different ... Please extend the Monitoring and Reporting in Server Management ... Terence Liu ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: "Support"
    ... world (see Service Pack 3 Installation Problems in the newsgroup). ... "helpful" response I got was to send a service report to Microsoft. ... symptoms to Microsoft one would wonder about whether it ...
    (microsoft.public.windowsupdate)
  • Re: SBS 2003 Server Usage Report
    ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ... | Subject: Re: SBS 2003 Server Usage Report ... Please extend the Monitoring and Reporting in Server Management ...
    (microsoft.public.windows.server.sbs)