A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Using a form to Search



 
 
Thread Tools Display Modes
  #1  
Old March 25th, 2010, 04:09 PM posted to microsoft.public.access.forms
daisy
external usenet poster
 
Posts: 94
Default Using a form to Search

We are trying to setup a db where a couple of the fields will need to be
manually updated each month for the new records coming into the db. The
problem is that we need to be able to view all of the records attached to
that customer to be able to fill those in. Is there a way to have the form
show a filter and only pull in the data attached to the new monthly load to
make edits?
--
Thank you in advance!!!!
  #2  
Old March 25th, 2010, 05:39 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Using a form to Search

On Thu, 25 Mar 2010 08:09:01 -0700, daisy
wrote:

We are trying to setup a db where a couple of the fields will need to be
manually updated each month for the new records coming into the db. The
problem is that we need to be able to view all of the records attached to
that customer to be able to fill those in. Is there a way to have the form
show a filter and only pull in the data attached to the new monthly load to
make edits?


Yes; by setting the form's Filter property or by basing the form on a query
selecting the appropriate data.

For a more detailed answer please post a more detailed question, with a
description of the table upon which the form is based.
--

John W. Vinson [MVP]
  #3  
Old March 25th, 2010, 07:24 PM posted to microsoft.public.access.forms
daisy
external usenet poster
 
Posts: 94
Default Using a form to Search

Hi John,

I've been trying to take different approaches to this and I'm wondering if
the form is the best way. There is a data table that has new monthly data
appended to it. the newly appended data could have history associated with it

for example
EffQtr Event CustomerID CustomerName InvoicedAmt
2008-1 New 123456 Customer A $25
2009-1 Renewal 123456 Customer A $50
New Data that gets appended
EffQtr Event CustomerID CustomerName InvoicedAmt
2010-1 123456 Customer A $25

I would like to create a form that would have a filter to choose the
Customers that have newly appended data and any of their historical data yo
update the event and a few other fields. We have to be able to see the
historical at the same time to be able to update the fields.

Does that help? sorry I was unclear earlier -- thank you!




Thank you in advance!!!!


"John W. Vinson" wrote:

On Thu, 25 Mar 2010 08:09:01 -0700, daisy
wrote:

We are trying to setup a db where a couple of the fields will need to be
manually updated each month for the new records coming into the db. The
problem is that we need to be able to view all of the records attached to
that customer to be able to fill those in. Is there a way to have the form
show a filter and only pull in the data attached to the new monthly load to
make edits?


Yes; by setting the form's Filter property or by basing the form on a query
selecting the appropriate data.

For a more detailed answer please post a more detailed question, with a
description of the table upon which the form is based.
--

John W. Vinson [MVP]
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:34 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.