Re: Access Size Problem

From: Albert D. Kallal (PleaseNOOOsPAMMkallal_at_msn.com)
Date: 03/22/05 

Date: Tue, 22 Mar 2005 14:41:44 -0700

"Roy Goldhammer" <roygoldh@hotmail.com> wrote in message
news:%23CkcLyrLFHA.1176@TK2MSFTNGP15.phx.gbl...
> Thankes Andreas
>
> So the split is the reference i'm talking about.

As I mentioned in the other post, using references to "mde" code libraries
ONLY works well for code that you have in standard modules. The code in a
form cannot be shared this way. If you could/can move code out of a form
into a standard module, then of course, you could share the code more
effectively. On the other hand, likely if the code could have been put in a
standard module..it was...

I would actually NOT go to any trouble to pull code out of forms. (better to
keep code that belongs to a form in the form). This way, you can more easy
pull out, and put similar parts of the application (forms + or reports) into
a separate pieces of the application. So, for example, the code to prompt
users, and do most of the or could be made separate from the data entry
screens Further, as your application designs improve, then to add new
reports, and even add more parameter prompts, you will find that NO new
forms need to be built in theses cases (your report prompt screens will use
tables to "list" what report,a nd what options..and thus over time you don't
have to modify your menus systems every time a new report is added). You can
see some great examples of this concept here:

http://www.members.shaw.ca/AlbertKallal/ridesrpt/ridesrpt.html 

-- 
Albert D. Kallal   (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

Relevant Pages

  • Re: Strange problems with HP 340 with XP home OS
    ... This it does and 99.9 percent of the time it reports zero ... It has "repaired" the disk. ... at prompt enter: fsutil dirty query C: ... no you did not enter it correctly did you open command prompt ...
    (uk.comp.homebuilt)
  • Re: Printer
    ... You can't add a network printer for a compter that doesn't exist. ... Then again reset the reports to use the default printer. ... "Lieven Van de Velde" wrote in message ... > Access does not prompt for the default printer. ...
    (microsoft.public.access.reports)
  • Re: too many modules
    ... Hard to imagine and true, we have enough forms and reports with code behind ... the parent app has to be the first ... How about just combining bunches of your standard modules? ...
    (microsoft.public.access.modulesdaovba)
  • Re: autochk.exe not found during boot - tried various things already!
    ... Try this fix courtesy of MS-MVP Rick Rogers: ... eliminate the autochk prompt. ... after getting into windows, i turn on the usb drive, it works fine. ... chkdsk/f on the volume reports no errors or bad sectors. ...
    (microsoft.public.windowsxp.general)
  • ParameterFields Prompts
    ... I'm doing the VB 6 and someone else is doing the reports. ... I understand the "true" is supposed to remove the prompt. ... The customer is not anxious to upgrade if there are major changes. ... Remember there are thousands of .rpts and thousands of .rpt calls from VB. ...
    (microsoft.public.vb.crystal)