Load multiple records per form

W

Warman

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
 
J

John W. Vinson

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.
 
K

KARL DEWEY

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.
 
W

Warman

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!!
 
B

Banana

Warman said:
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/micr...45696c98aba27/cdd7b2758899d4ad?hide_quotes=no
 
W

Warman

The table will actually have an eighth column - StateName (most important!).

Hopefully you get the idea.

Thanks
 
J

John W. Vinson

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!
 
W

Warman

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.
 
J

John W. Vinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top