[AccessD] How to update form source?

Kaup, Chester Chester_Kaup at kindermorgan.com
Wed Nov 7 16:42:10 CST 2007


This is my experience using the filter property in code. It works great.
Thanks.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan,
Lambert
Sent: Wednesday, November 07, 2007 3:03 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] How to update form source?

Chester,

Instead of copying the data from the source table to another table, just
use
the source table itself and apply a filter to the form so only the
selected
time period is displayed.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Wednesday, November 07, 2007 3:32 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] How to update form source?


I have a form on which the user clicks a button to see 90 days worth of
data
from a source table. When the button is clicked a query runs that puts
90
days worth of data in a table. Another form then opens and displays this
data. On the top of the form are two text boxes. One text box contains
the
start date of the data and the other the end date of the data. These
boxes
can be edited allowing the user to see some time interval of data other
than
90 days. When the date is changed in the text box code attempts to run a
query to update the table the displayed data is based on. The query will
not
run though because the table is open. I could use some ideas on how to
do
this. Thanks.

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number
of electrons were terribly inconvenienced.

 

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