Re: Modules(index) and Modules("name") return different modules?

From: Brendan Reynolds (brenreyn)
Date: 09/03/04 

Date: Fri, 3 Sep 2004 12:31:11 +0100

That's correct. You can edit the code in a referenced MDB, but your edits
are discarded *without warning* when you close. I just checked, and I'm
afraid this behaviour hasn't changed in Access 2003. (I hadn't expected to
be able to save the changes, but I had rather hoped for a warning that they
would not be saved). 

-- 
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:eoFaeGUkEHA.2340@TK2MSFTNGP11.phx.gbl...
> I seem to remember that in A97, I could edit loaded
> library modules, but in A2K I can't ??? Is that correct ???
> (because library modules are loaded in shared mode ????)
>
> (david)
>
> "Derek Boutang" <anonymous@discussions.microsoft.com> wrote in message
> news:4e1101c490fd$c0b26960$a601280a@phx.gbl...
> > I'm converting some dev utilities from 97 to 2003 and
> > struggling with the new coding environment. Is the
> > following behaviour a bug, or am I not coding this
> > correctly?
> >
> > According to the help, the following code is supposed to
> > load the names of open modules into an array:
> >
> > intCount = Modules.Count - 1
> > For intCounter = 0 To intCount
> >  aObjects(intCounter) = Modules(intCounter).Name
> >  Debug.Print aObjects(intCounter)
> > Next intCounter
> >
> > Instead, it loads every module in my database PLUS every
> > module in every library database reference.
> >
> > But, when I attempt to reference a module in one of the
> > libraries using the following syntax, Access produces
> > Error 9: Subscript out of range:
> >
> > ?Modules("name").Name
> >
> > To me, this looks like Modules(index) and Modules("name")
> > return different lists. Further, it looks like
> > Modules.Count is now a meaningless construct because it
> > doesn't really tell you how many modules are open, just
> > how many are available to be referenced within the
> > database.
> >
> > Thoughts? Comments?
>
>

Relevant Pages

  • Variety of XML questions;
    ... parents affect the reference? ... (Does parsing create the node instances, or just parses the XML into ... Bearing encapsulation and concurrency in mind, ... changes to a node copy the node, edit, then replace the node in the original ...
    (microsoft.public.dotnet.xml)
  • Re: Update a table using a form
    ... I have the properties set as you advised. ... when you open the form the "reference number" ... Access will give you a Sub and End Sub line; edit it to ...
    (microsoft.public.access.formscoding)
  • Re: change excel document into word document
    ... ' requires a reference to the Word Object library: ... Set wdApp = New Word.Application ... Set wdDoc = Nothing ... Edit> Copy ...
    (microsoft.public.excel.misc)
  • Question for Paul and other AppleScripters
    ... I'm new to AppleScript and have been enjoying the learning experience, ... convenient way to edit these values for many, ... contact objects or use a reference to to loop through the list of selected ... My first strategy was to try to access the properties of the ...
    (microsoft.public.mac.office.entourage)
  • Re: Linux 2.6.26-rc9
    ... annotate uv_system_init with a matching annotation. ... WARNING: vmlinux.o: Section mismatch in reference from the ...
    (Linux-Kernel)