Re: Summing it all up

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: grep (grep_at_grep.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 09:56:18 -0400

Allen,

Thanks for your continuing help. Here's what I've done/got:

I had not turned off the AutoCorrect "features", but have now done so.
I'll check out your descriptions later. Also, I compacted the database.

The Immediate Window, as per your suggestions, did come through with a
ControlType of 112, however, the latter attempts turned up one of two
errors, and I'm not sure what either mean in this context:

1. No current record
2. #3011 - The Microsoft Jet database engine could not find the object
". Make sure the object exists and that you spell its name and path name
correctly.

Now, I'm not sure what would cause the former error at all. I don't get
that error when I try to reach other fields on the same subform.

As for the latter, I looked around for an extraneous " somewhere, but
was unable to find one.

grep

Allen Browne wrote:

> No. Set the Format to Currency, of course.
>
> If it still doesn't figure, open the Immediate Window (Ctrl+G), and work
> with it there until you get the reference right. In that context you can't
> use Me, so try:
> Forms("NameOfYourMainFormHere")![NameOfYourSubformControlHere].ControlType
> That should give you 112
>
> From there try going further:
> Forms("NameOfYourMainFormHere")![NameOfYourSubformControlHere].Form![Subtotal]
>
> You should be able to track down which part is the wrong name.
>
> BTW, if you have not done so yet, make sure that you uncheck the boxes
> under:
> Tools | Options | General | Name AutoCorrect
> The compact the database:
> Tools | Database Utilitites | Compact
> Explanation of the problems this "feature" can cause you:
> http://members.iinet.net.au/~allenbrowne/bug-03.html
>

Relevant Pages

  • Re: Form trouble
    ... Make a backup copy of your database while it is not running, ... Then compact the database to get rid of this junk: ... After the compact, open the Immediate Window, and enter ... Test that the form opens normally. ...
    (microsoft.public.access.forms)
  • Re: Summing it all up
    ... Allen Browne - Microsoft MVP. ... Also, I compacted the database. ... and I'm not sure what either mean in this context: ... Tools | Database Utilitites | Compact ...
    (microsoft.public.access.formscoding)
  • RE: Compacting MDB help
    ... The autoexec macro opens a ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ... I'm quite certain that you can't Compact an open database from within itself ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... This will cause the database to grow so Compacting ... not split off the tables from your FrontEnd. ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... not practical to have staffpersons open another database in order to switch ... When the front end opens, it goes directly to the main switchboard. ... the only reason why you would need to Compact the ...
    (microsoft.public.access.modulesdaovba)