Re: Lock / Unlock VBA project

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

Hi,

The application has many tables , very many reports and and forms so Access
won't complete the MDE conversion telling me there is too many table
reference IDs for it too handle.

Do you know of any patch for this limitation ?

Tks

"Alex Dybenko" wrote:

Hi,
suggest that you make mde and put a time check routine there, it is much
better solution that deleting reports

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com




"FreeWheel" <FreeWheel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:131BA243-33F1-47E9-9CFF-222CEC01663A@xxxxxxxxxxxxxxxx
HHHHHEEEELLLLLLPPPPPP anyone !

How do I Lock / Unlock my VBA project for viewing from a module within ?

I got this code in a Module which behaves properly only when the VBA
project
lock for viewing is OFF.

If dbs.AllReports.Count > 0 Then
For num = dbs.AllReports.Count To 1 Step -1
itemnum = num - 1
Set obj = dbs.AllReports(itemnum)
If obj.IsLoaded = False Then
DoCmd.DeleteObject acReport, obj.Name
Else
End If 'obj.IsLoaded
Next num
Else
End If 'AllReportsCount

I need to set the lock OFF ahead of this piece of code and back ON right
after it.
After spending too many evenings on the WEB searching....., I can only
find
PASSWORD RECOVERY utilities which work but I do not need.... I need what's
inside !

What do I need to set / reset ?



.

Relevant Pages

  • Re: Lock / Unlock VBA project
    ... "Alex Dybenko" wrote: ... and have separate mdb with tables? ... very many reports and and forms so ... How do I Lock / Unlock my VBA project for viewing from a module within ...
    (microsoft.public.access.modulesdaovba)
  • Re: Locking upon printer.BeginDoc
    ... >>Why would the following work in a little test program but lock up on ... I just finished with about 36 reports, ... I'm using Delphi 6 pro, update 2, Windows XP home. ... Both, kbmmemtable and freereport, are free or very low cost ...
    (comp.lang.pascal.delphi.misc)
  • Re: Help me save my report from the reviewers!
    ... Is there a type of "lock" that can be ... the paragraph and type, it formats in the Style of that paragraph. ... from various other reports and drop them into my report, ... Word MVP FAQ site: http://word.mvps.org ...
    (microsoft.public.word.docmanagement)
  • Re: 2.6.24-rc8: possible circular locking dependency detected
    ... rsync/23295 is trying to acquire lock: ... memory reclaim can occur when an inode lock is held, ... positive from being reported because we are getting reports at ...
    (Linux-Kernel)