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
|
|||
|
|||
Load multiple records per form
Can you load more than one record from one form.
I have small entries for multiple states. I would like to list each state on one form, enter the information for each and load 30-50 records. It would save much time doing it this way versus loading one at a time. Thanks |
#2
|
|||
|
|||
Load multiple records per form
On Tue, 20 Oct 2009 10:57:10 -0700, Warman
wrote: Can you load more than one record from one form. I have small entries for multiple states. I would like to list each state on one form, enter the information for each and load 30-50 records. It would save much time doing it this way versus loading one at a time. Thanks You're not entering data into a Form. You're using a Form as a tool to enter data into a Table. What are the structures of your Tables? How are they related? What are these "records"? You can certainly use a Form with a continuous Subform to display a single parent record (for a state, say) and multiple child records, using the Subform's Master/Child Link Field properties to synchronize the subform with the mainform, but without a clearer understanding of your data it's hard to be sure what to answer. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Load multiple records per form
One way would be to have a table of states with Yes/No field displayed in a
subform. You check the states to add records for. Have text boxes for the data for other fields. Have command button to append records for all states checked with data from text boxes. Use another command button to uncheck all states. -- Disclaimer: This author may have received products and services, free, at or below market price, mentioned in this post at or below cost equal to that of consumer. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Warman" wrote: Can you load more than one record from one form. I have small entries for multiple states. I would like to list each state on one form, enter the information for each and load 30-50 records. It would save much time doing it this way versus loading one at a time. Thanks |
#4
|
|||
|
|||
Load multiple records per form
I have one table called Tax Payments.
The table has 7 columns - Date Posted; Due Date; Year; Month; Payment Amount; Tax Due; Discount. On the form I have listed all 50 states with Payment; Tax Due; Discount. I enter all 50 entries on one page (form). I want to post 50 records to the table that will fill in the 7 columns listed above. It is much easier to input all 50 at once than to fill in a form 50 different times. The form looks like a spreadsheet but after filling in the fields, and pressing enter (actually a command button that says "Post These Records") I want to create the 50 different records in the table. Probably not possible!! "John W. Vinson" wrote: On Tue, 20 Oct 2009 10:57:10 -0700, Warman wrote: Can you load more than one record from one form. I have small entries for multiple states. I would like to list each state on one form, enter the information for each and load 30-50 records. It would save much time doing it this way versus loading one at a time. Thanks You're not entering data into a Form. You're using a Form as a tool to enter data into a Table. What are the structures of your Tables? How are they related? What are these "records"? You can certainly use a Form with a continuous Subform to display a single parent record (for a state, say) and multiple child records, using the Subform's Master/Child Link Field properties to synchronize the subform with the mainform, but without a clearer understanding of your data it's hard to be sure what to answer. -- John W. Vinson [MVP] . |
#5
|
|||
|
|||
Load multiple records per form
Warman wrote:
I have one table called Tax Payments. The table has 7 columns - Date Posted; Due Date; Year; Month; Payment Amount; Tax Due; Discount. On the form I have listed all 50 states with Payment; Tax Due; Discount. I enter all 50 entries on one page (form). I want to post 50 records to the table that will fill in the 7 columns listed above. It is much easier to input all 50 at once than to fill in a form 50 different times. The form looks like a spreadsheet but after filling in the fields, and pressing enter (actually a command button that says "Post These Records") I want to create the 50 different records in the table. Probably not possible!! Are you looking for a "spreadsheet-like entry form"? If so, someone asked similar question not too long ago and got several answers: http://groups.google.com/group/micro...hide_quotes=no |
#6
|
|||
|
|||
Load multiple records per form
The table will actually have an eighth column - StateName (most important!).
Hopefully you get the idea. Thanks "Warman" wrote: I have one table called Tax Payments. The table has 7 columns - Date Posted; Due Date; Year; Month; Payment Amount; Tax Due; Discount. On the form I have listed all 50 states with Payment; Tax Due; Discount. I enter all 50 entries on one page (form). I want to post 50 records to the table that will fill in the 7 columns listed above. It is much easier to input all 50 at once than to fill in a form 50 different times. The form looks like a spreadsheet but after filling in the fields, and pressing enter (actually a command button that says "Post These Records") I want to create the 50 different records in the table. Probably not possible!! "John W. Vinson" wrote: On Tue, 20 Oct 2009 10:57:10 -0700, Warman wrote: Can you load more than one record from one form. I have small entries for multiple states. I would like to list each state on one form, enter the information for each and load 30-50 records. It would save much time doing it this way versus loading one at a time. Thanks You're not entering data into a Form. You're using a Form as a tool to enter data into a Table. What are the structures of your Tables? How are they related? What are these "records"? You can certainly use a Form with a continuous Subform to display a single parent record (for a state, say) and multiple child records, using the Subform's Master/Child Link Field properties to synchronize the subform with the mainform, but without a clearer understanding of your data it's hard to be sure what to answer. -- John W. Vinson [MVP] . |
#7
|
|||
|
|||
Load multiple records per form
On Wed, 21 Oct 2009 11:47:03 -0700, Warman
wrote: The form looks like a spreadsheet but after filling in the fields, and pressing enter (actually a command button that says "Post These Records") I want to create the 50 different records in the table. Probably not possible!! Certainly it's possible. Whether it's desirable is quite a different question! How do these fifty records differ? Only by the state code, or state name? It appears (and I'm still not clear on your structure!!!) that you're thinking that everything needs to all be in one Table. That is almost certainly not true; you're using a relational database, and you can use it relationally. For instance you can have a single (fifty, or 60 if you count the District of Columbia and the territories, or 72 if you include Canadian provinces) table of States, with a two-letter state code as a primary key and the state name as a separate text field; if each state has its own distinct (characteristic of the state, for all records) due date or rate, you'ld put this field in the table as well. Please explain what real-life problem (what kind of data) you're trying to store. Having each record repeated fifty times is quite certainly NOT the best solution - but there may be a much better one than you're visualizing! -- John W. Vinson [MVP] |
#8
|
|||
|
|||
Load multiple records per form
I may try to go in another direction but here is what I am trying to do now:
State PayAmount TaxAmount DiscountAmt Entered DueDate Month Year AL 500.00 505.00 -5.00 10/15/09 19 10 2009 AK 50.00 51.00 -1.00 10/15/09 19 10 2009 AR 650.00 650.00 0.00 10/15/09 19 10 2009 CA 9925.25 9960.00 -34.75 10/15/09 19 10 2009 This goes on for however many states that the company pays sales tax to. I do this for several companies. I get this information in spreadsheets but the spreadsheets are not consistent from month-to-month. I would like to set up one form to enter the information (faster input using one page) but would like the form to load the individual records into the table with one push of the "Command Button". Note: the last 4 columns will usually be the same and could be a "common" field on the form. I am setting this up to eventually turn over to our tax dept to use - that is why I am trying to simply the input. I do appreciate the help. If this is not feasible, I will try a new approach. But, this is where I am at currently. "John W. Vinson" wrote: On Wed, 21 Oct 2009 11:47:03 -0700, Warman wrote: The form looks like a spreadsheet but after filling in the fields, and pressing enter (actually a command button that says "Post These Records") I want to create the 50 different records in the table. Probably not possible!! Certainly it's possible. Whether it's desirable is quite a different question! How do these fifty records differ? Only by the state code, or state name? It appears (and I'm still not clear on your structure!!!) that you're thinking that everything needs to all be in one Table. That is almost certainly not true; you're using a relational database, and you can use it relationally. For instance you can have a single (fifty, or 60 if you count the District of Columbia and the territories, or 72 if you include Canadian provinces) table of States, with a two-letter state code as a primary key and the state name as a separate text field; if each state has its own distinct (characteristic of the state, for all records) due date or rate, you'ld put this field in the table as well. Please explain what real-life problem (what kind of data) you're trying to store. Having each record repeated fifty times is quite certainly NOT the best solution - but there may be a much better one than you're visualizing! -- John W. Vinson [MVP] . |
#9
|
|||
|
|||
Load multiple records per form
On Thu, 22 Oct 2009 08:41:02 -0700, Warman
wrote: This goes on for however many states that the company pays sales tax to. I do this for several companies. I get this information in spreadsheets but the spreadsheets are not consistent from month-to-month. I would like to set up one form to enter the information (faster input using one page) but would like the form to load the individual records into the table with one push of the "Command Button". Note: the last 4 columns will usually be the same and could be a "common" field on the form. I'm still not understanding. You apparently have no consistant or predictable source of information. You want to push a button and have that inconsistant, unpredictable information loaded in a consistant, predictable structure. Sounds laudable, but it is also apparently impossible! If the last four columns are the same, then I'd REALLY suggest that you have two tables in a one-to-many relationship: the constant information related one-to-many to a second table with the state-variable information. A Form with a Subform would make it easier to see the data all on one screen. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|