PC Review


Reply
Thread Tools Rate Thread

automated entry of parameters?

 
 
JR
Guest
Posts: n/a
 
      22nd Sep 2004
I gather and disseminate data for several different
customers whose requirements for the same data elements
varies with the model they are feeding.

One table is set up as follows:

Org ID | Location | POSTURE | PHASE | Rate

Posture and Phase are variables with 5 and 4 possible
variables respectively which give 20 possible combinations.

I must periodically rebuild the table data. I use an
append query to do that BUT the query design is such that
Posture and Phase are expressions (1 and 2 respectively).
Each time I update the table I am prompted to enter
parameters for the two expressions (Posture and Phase).
There has GOT to be a better way (such as using a form
that allows me to select the combinations of Posture and
Phase from a list).

Any help will be greatly appreciated.

 
Reply With Quote
 
 
 
 
Mark Hyland
Guest
Posts: n/a
 
      23rd Sep 2004
Hi,

You could create two combo boxes on a form, which show the values for the
two fields (Posture and Pasture), and then in the query, refer to the
fields on the form, for the criteria.

Your criteria would be something like

forms![formname]![fieldname]

This way, when the form is opened, the value you select will pass to the
query and act as a filter.

Hope this helps

Mark

This information is provided "as is" and expresses no warranties or confers
no rights.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
I have value list for a combo - the source is "Level 2";"Level 1";"Entry 3";"Entry 2";"Entry 1"..... Chris K Microsoft Access Form Coding 2 25th Jul 2010 05:15 PM
"What-if" formula for either a manual entry and automated entry MZ Microsoft Excel Misc 3 3rd Feb 2010 11:29 PM
Online Data Entry, Offline Data Entry with Data Entry Services James Roy Microsoft Access Forms 1 3rd Feb 2009 01:45 PM
Automated signature updates w/o using Windows Automated Updates =?Utf-8?B?Q3VydEI=?= Security Signatures 3 15th May 2006 01:31 AM
Automated filter? Automated replace? =?Utf-8?B?Y3Jja3JqY2s=?= Microsoft Excel Crashes 2 13th Jan 2005 12:09 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:57 PM.