[AccessD] 64-but ONLY front end ?

Ryan Wehler wrwehler at gmail.com
Fri Jan 6 17:26:30 CST 2017


John,

  That's more or less what I ended up doing today. :) it probably needs some fine tuning though. 

Sent from my iPad

> On Jan 6, 2017, at 5:17 PM, John Colby <jwcolby at gmail.com> wrote:
> 
> Ryan,
> 
> I did what I referred to as "JIT subforms", i.e. linking the subforms when the tab was clicked on.  I used a class (of course) to manage it.  The event on the tab triggered a method in the loaded class to link the suvbform.  When the user moves off the tab, the subform is unlinked.  Of course you end up with situations where you need specific forms to remain linked once the tab is clicked, typically subforms that are used often and require a long time to load once linked.
> 
> IIRC I used SysVars to store the names of the subforms that would remain loaded.
> 
> It took a bit of dev work but once working it worked quite well.
> 
> jwcolby
> 
>> On 1/6/2017 9:28 AM, Ryan W wrote:
>> More statistics:
>> 
>> ?returnvm
>> 
>> 
>> (Reporting module loaded)
>> 1.391 GB of VM used.
>> 
>> (Prepatory form loaded)
>> 1.194 GB of VM used.
>> 
>> (Analytics form loaded)
>> 1.135 GB of VM used.
>> 
>> (Login Form loaded)
>> 1.06 GB of VM used.
>> 
>> (Switchboard Loaded)
>> 0.803 GB of VM used.
>> 
>> (Nothing open but my Access FE (no forms loaded))
>> 0.645 GB of VM used.
>> 
>> 
>> 
>> With that once I get to the reporting module if I hit "print preview" on
>> all of my selected reports (7) to print and give to the client I get an out
>> of resources error.  Those are the most used forms in the entire FE.  It
>> wouldn't be uncommon for some of our data reviewers to have all of those
>> open bouncing between them (they used to do it before via hotkeys (Ctrl-R
>> for Analytical, Ctrl-M for Main, Ctrl-B for Prep, Ctrl-W for Login etc)..
>> so even though you PREVIOUSLY with Access 2003 you couldn't see a tab, the
>> same forms were loaded then that are loaded now. The key difference is
>> Access 2013. It must simply use more memory.
> 
> -- 
> John W. Colby
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



More information about the AccessD mailing list