form with established data and data entry

  • Thread starter Thread starter kniedens via AccessMonster.com
  • Start date Start date
K

kniedens via AccessMonster.com

Hello, I'm still really new to this, and appreciate any help...hopefully
there is a way I can do this with forms/subforms?

I have a form (based on a table) that sets the criteria for a query:
[Forms]![sbItem:Data Entry: Actual Qty by Resource]![Plant]
[Forms]![sbItem:Data Entry: Actual Qty by Resource]![FinishedGood]
[Forms]![sbItem:Data Entry: Actual Qty by Resource]![LineNr]

The form also has an area for the user to enter Name, ID, Date, Time that is
not related to the query.

The "OK" button on the form opens a query...This query shows the "Resources"
based on the above criteria, and it also includes a "standard quantity"
(which varies by "resource" followed by a few other columns, and some
calculations based on "standard quantity."

What I need to add is a way for the user to enter their own "Actual Quantity"
to the right of each "resource" after the query is run. All of the
information the user entered (Name, Plant, Finished Good, Actual Quantity....
etc.) needs to be saved.

Resources: Actual Qty: Calculation 1 [Actual Qty*1000]
Calculation 2 [Actual Qty/...]
A123
B456
C789


Thanks for your help...I hope this question is clear...
Kari
 
If all of the information needs to be saved, it sounds like you need another
table, maybe more. Instead of having the "OK" button open a select query,
have it run a procedure that puts the data in a form. The form would have a
control that allows the user to save the data to a table. The table would be
structured just like the existing query with the necessary additional fields.
In addition, you may want to create another table to hold the header
information such as Name, ID, Date, and Time. These two tables would be
linked together with some autoID.

Here's what the process might look like:
Click OK

Clear temporary table(s) of data (delete query) and run append query
OR
Make table(s) query

Form opens and is filled out
Click Save
Append data to permanent table(s)

Hello, I'm still really new to this, and appreciate any help...hopefully
there is a way I can do this with forms/subforms?

I have a form (based on a table) that sets the criteria for a query:
[Forms]![sbItem:Data Entry: Actual Qty by Resource]![Plant]
[Forms]![sbItem:Data Entry: Actual Qty by Resource]![FinishedGood]
[Forms]![sbItem:Data Entry: Actual Qty by Resource]![LineNr]

The form also has an area for the user to enter Name, ID, Date, Time that is
not related to the query.

The "OK" button on the form opens a query...This query shows the "Resources"
based on the above criteria, and it also includes a "standard quantity"
(which varies by "resource" followed by a few other columns, and some
calculations based on "standard quantity."

What I need to add is a way for the user to enter their own "Actual Quantity"
to the right of each "resource" after the query is run. All of the
information the user entered (Name, Plant, Finished Good, Actual Quantity....
etc.) needs to be saved.

Resources: Actual Qty: Calculation 1 [Actual Qty*1000]
Calculation 2 [Actual Qty/...]
A123
B456
C789

Thanks for your help...I hope this question is clear...
Kari
Click to expand...
 
Back
Top