[AccessD] JIT Forms

Dan Waters dwaters at usinternet.com
Fri Nov 9 14:47:37 CST 2007


John - I've been briefly following this thread.  Is this being done with an
Access BE or with a SQL Server BE?

If Access, how much improvement did you see?

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Friday, November 09, 2007 2:09 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] JIT Forms

Nope, the code that opens the form sets the filter, then opens the form.  In
this kind of situation you will always be selecting some item (claim, person
etc) so the code that selects that person then sets the filter and opens the
form.


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Friday, November 09, 2007 1:36 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] JIT Forms

So then you can't be opening the form with the record source set, yes?
Because it's likely to execute before you put the filter in the filter in
the ClientID field. So are you setting the Record Source after putting the
filter into ClientID?

And, if so, what's the advantage of just modifying the Record Source in the
open (or maybe load?) event and adding the WHERE clause based on the record
ID that you want to fetch?

Rocky



 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Friday, November 09, 2007 10:16 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] JIT Forms

I think so.  What I do is set one of my 

fltr "ClientID", someClientID

and then place fltr("ClientID") in the ClientID field (where) of the source
query for the form to cause the form to filter down to a single record.


John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Friday, November 09, 2007 12:56 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] JIT Forms

Unfortunately, in my case.  MOST of the bound fields are not in subforms but
scattered throughout the multiple tabs.

I think we're going for the one record or very few records  approach by
modifying the Record Source on the fly rather than using form filters as it
is now.  Hopefully that reduces what's coming over the wire.

Brings up another question - if a filter is set on Open, do all the records
come over anyway and access just makes the filtered subset available to the
form?

Rocky

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.503 / Virus Database: 269.15.26/1119 - Release Date: 11/8/2007
5:55 PM
 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
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