Re: Where do I decalre vaiables who's scope will be global ?

Isis wrote:

Thanks for the reply Rick - I eas actually wondering what makes a
module attached to a form and one that is NOT attached to a form ?
Whats the difference when you are making them ?

When you create a Form/Report the first time any code is attached to an
event the Module is automatically created. *You* never actually create a
Module on a Report or Form. Modules that you see as separate objects in the
db window are there because you created (or imported) them. Form and Report
Modules are "part of" the Form/Report itself.

In other words, if you see a Module in the db window then by definition it
is NOT a Form/Report Module.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Where do I decalre vaiables whos scope will be global ?
    ... Whats the difference when you are making them? ... Form and Report Modules are "part of" the Form/Report itself. ... if you see a Module in the db window then by ...
    (microsoft.public.access.gettingstarted)
  • Re: On Error - Query to Report - no records
    ... Avoid #Error in form/report with no records ... under each column for report. ... How do I hide the data ..ie #error and show only the label - or better ...
    (microsoft.public.access.queries)
  • RE: Trouble adding records
    ... entering the data and the rest of the database because everything else worked. ... Start by making a backup of your mdb. ... Set the form/report Has Module property to No. ... No matter when I run the report, only the old info is included. ...
    (microsoft.public.access.forms)
  • Re: Coditional formatting
    ... Russ Kroeger wrote: ... >report 2 times the number of records etc. ... form/report, they only operate on fields in the record ... long as all the terms are record source fields. ...
    (microsoft.public.access.reports)
  • Re: Return vs. Tab
    ... > Sorry for being so dense today. ... When using the a form or report, ... > can view the properties behind the form/report and use the event ... You cannot make the query open the form. ...
    (microsoft.public.access.forms)