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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
form with established data and data entry
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]![sbItemata Entry: Actual Qty by Resource]![Plant] [Forms]![sbItemata Entry: Actual Qty by Resource]![FinishedGood] [Forms]![sbItemata 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#2
|
|||
|
|||
form with established data and data entry
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) kniedens wrote: 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]![sbItemata Entry: Actual Qty by Resource]![Plant] [Forms]![sbItemata Entry: Actual Qty by Resource]![FinishedGood] [Forms]![sbItemata 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
Thread Tools | |
Display Modes | |
|
|