[AccessD] JIT Forms

Capital idea!

Rocky
 




 	
	

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

What you might want to do Rocky is set the form's recordsource to something
wich returns no records, eg WHERE Keyfield=-1. Then you can manipulate the
Recordsource when you want to select  record or move back and forth, knowing
that initially you'll get no records.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky 
> Smolin at Beach Access Software
> Sent: 09 November 2007 18:36
> 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

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