Hi

I have a form that I use to add data to a table of League results.
It does one entry per team in a particular year. Some fields are
linked to other tables for the league name and team name etc.
So, I select a name from a combo box, then the league likewise, then
manually enter games won/lost etc
Then I click submit to add the entry to the table

I would ideally like to enter a whole season on one entry form for an
entire league so that I could enter 20+ entries then submit to the
table

Is it possible?

Thanks
Neil

It is possible if you use unbound forms to enter more than 1 record at a 
time and submit them all to the table. It is easier to use bound forms and 
edit/add the data as you enter it. You can use a datasheet or continuouse 
form if you want to see multiple records at once.
-- 
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"neil40" <neil.grantham@googlemail.com> wrote in message 
news:1f6f4e7d-32d2-41c9-91ec-0b90353ed6f2@q23g2000yqd.googlegroups.com...
> Hi
>
> I have a form that I use to add data to a table of League results.
> It does one entry per team in a particular year. Some fields are
> linked to other tables for the league name and team name etc.
> So, I select a name from a combo box, then the league likewise, then
> manually enter games won/lost etc
> Then I click submit to add the entry to the table
>
> I would ideally like to enter a whole season on one entry form for an
> entire league so that I could enter 20+ entries then submit to the
> table
>
> Is it possible?
>
> Thanks
> Neil 

On Fri, 2 Apr 2010 17:23:09 -0700 (PDT), neil40 <neil.grantham@googlemail.com>
wrote:

>Hi
>
>I have a form that I use to add data to a table of League results.
>It does one entry per team in a particular year. Some fields are
>linked to other tables for the league name and team name etc.
>So, I select a name from a combo box, then the league likewise, then
>manually enter games won/lost etc
>Then I click submit to add the entry to the table
>
>I would ideally like to enter a whole season on one entry form for an
>entire league so that I could enter 20+ entries then submit to the
>table
>
>Is it possible?
>
>Thanks
>Neil

What's the actual structure of your table? It really should be tables!

If you're storing an entire season of games in *ONE FIELD* in one record -
you're not using Access correctly. There should be (at least) a table of
Leagues related one-to-many to a table of Teams, related many-to-many to a
table of Games, with one record per game. This games table can be displayed on
a continuous form so you can see multiple records on the same screen, but each
game should be a separate record in the database.
-- 

             John W. Vinson [MVP]

On 3 Apr, 03:32, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
wrote:
> On Fri, 2 Apr 2010 17:23:09 -0700 (PDT), neil40 <neil.grant...@googlemail=
..com>
> wrote:
>
>
>
>
>
> >Hi
>
> >I have a form that I use to add data to a table of League results.
> >It does one entry per team in a particular year. Some fields are
> >linked to other tables for the league name and team name etc.
> >So, I select a name from a combo box, then the league likewise, then
> >manually enter games won/lost etc
> >Then I click submit to add the entry to the table
>
> >I would ideally like to enter a whole season on one entry form for an
> >entire league so that I could enter 20+ entries then submit to the
> >table
>
> >Is it possible?
>
> >Thanks
> >Neil
>
> What's the actual structure of your table? It really should be tables!
>
> If you're storing an entire season of games in *ONE FIELD* in one record =
-
> you're not using Access correctly. There should be (at least) a table of
> Leagues related one-to-many to a table of Teams, related many-to-many to =
a
> table of Games, with one record per game. This games table can be display=
ed on
> a continuous form so you can see multiple records on the same screen, but=
 each
> game should be a separate record in the database.
> --
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0John W. Vinson [MVP]- Hide quoted text -
>
> - Show quoted text -

Yes, multiple tables - I did mention that in my question!
League names are one table, Team names another table, and results a
3rd table

To explain more, I am not actually recording games, but end of season
tables. It is a historical record of a particular sport, so I want an
easier way of entering an entire league for each season.
IE Team X, won 22, lost 2, drew 1, score for 1200, score against 876,
points 46
So, there are no calculations going on for the League, just pure
recording

Neil

On Sat, 3 Apr 2010 02:24:02 -0700 (PDT), neil40 <neil.grantham@googlemail.com>
wrote:

>To explain more, I am not actually recording games, but end of season
>tables. It is a historical record of a particular sport, so I want an
>easier way of entering an entire league for each season.
>IE Team X, won 22, lost 2, drew 1, score for 1200, score against 876,
>points 46

A Continuous form with one row per "end of season" record should give you what
you want.
-- 

             John W. Vinson [MVP]

On 3 Apr, 18:34, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
wrote:
> On Sat, 3 Apr 2010 02:24:02 -0700 (PDT), neil40 <neil.grant...@googlemail=
..com>
> wrote:
>
> >To explain more, I am not actually recording games, but end of season
> >tables. It is a historical record of a particular sport, so I want an
> >easier way of entering an entire league for each season.
> >IE Team X, won 22, lost 2, drew 1, score for 1200, score against 876,
> >points 46
>
> A Continuous form with one row per "end of season" record should give you=
 what
> you want.
> --
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0John W. Vinson [MVP]

I can create a 'continuous' (or Multi-line) Form, but all the fields
are populated with table entries.
How do I create this with blank lines so that I can submit the records
when finished entering my end-of-season data
On my single line form I can do this, I have a 'Submit' button to
commit the data.
Is there some way I could copy the single line entry form and create
more lines for my input.
I've google this to see if I can find an example without much luck

Neil

On Wed, 7 Apr 2010 17:11:46 -0700 (PDT), neil40 <neil.grantham@googlemail.com>
wrote:

>I can create a 'continuous' (or Multi-line) Form, but all the fields
>are populated with table entries.
>How do I create this with blank lines so that I can submit the records
>when finished entering my end-of-season data
>On my single line form I can do this, I have a 'Submit' button to
>commit the data.
>Is there some way I could copy the single line entry form and create
>more lines for my input.
>I've google this to see if I can find an example without much luck

I'm not sure I understand. A continuous form (based on a table or on an
updateable query) automatically has a blank, new record line at the bottom of
the list. You can type data into that line, save it (just by pressing the
enter key, no code is needed) and a new blank row will appear for the next new
entry. This is native Access functionality; no button, no code, nothing extra
needed.

Could you explain what you're seeing? Perhaps post the Recordsource of the
continuous form in SQL view?
-- 

             John W. Vinson [MVP]

On 8 Apr, 01:26, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
wrote:
> On Wed, 7 Apr 2010 17:11:46 -0700 (PDT), neil40 <neil.grant...@googlemail=
..com>
> wrote:
>
> >I can create a 'continuous' (or Multi-line) Form, but all the fields
> >are populated with table entries.
> >How do I create this with blank lines so that I can submit the records
> >when finished entering my end-of-season data
> >On my single line form I can do this, I have a 'Submit' button to
> >commit the data.
> >Is there some way I could copy the single line entry form and create
> >more lines for my input.
> >I've google this to see if I can find an example without much luck
>
> I'm not sure I understand. A continuous form (based on a table or on an
> updateable query) automatically has a blank, new record line at the botto=
m of
> the list. You can type data into that line, save it (just by pressing the
> enter key, no code is needed) and a new blank row will appear for the nex=
t new
> entry. This is native Access functionality; no button, no code, nothing e=
xtra
> needed.
>
> Could you explain what you're seeing? Perhaps post the Recordsource of th=
e
> continuous form in SQL view?
> --
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0John W. Vinson [MVP]

Yes, that is what I see, a form with a blank last entry.
This isn't what I'm hoping for though (or even know if it's possible),
as I can achieve data entry like this with my single entry form.
What I would like is a form like my single entry form, with maybe
20-25 blank entries to add the entire league before submitting it to
the table
As I say, I don't know if it's possible to do it.
The only advantage with the multi over the single I can see is that I
will be able to see where I got to, whereas on the single, if I get
distracted, then I have to open the table (or a report) to see what
I've done.

Neil

I don't understand the need to update the table with 20-25 records all at
once.  What is the objection to entering records one at a time?  It may be
possible to contrive an unbound form with dozens of text boxes, then loop
through the text boxes to update the table with multiple records at once, but
that would be a lot of work to bypass the built-in functionality, even if it
is possible.

neil40 wrote:
>On 8 Apr, 01:26, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
>wrote:
>
>> >I can create a 'continuous' (or Multi-line) Form, but all the fields
>> >are populated with table entries.
>[quoted text clipped - 18 lines]
>>
>>              John W. Vinson [MVP]
>
>Yes, that is what I see, a form with a blank last entry.
>This isn't what I'm hoping for though (or even know if it's possible),
>as I can achieve data entry like this with my single entry form.
>What I would like is a form like my single entry form, with maybe
>20-25 blank entries to add the entire league before submitting it to
>the table
>As I say, I don't know if it's possible to do it.
>The only advantage with the multi over the single I can see is that I
>will be able to see where I got to, whereas on the single, if I get
>distracted, then I have to open the table (or a report) to see what
>I've done.
>
>Neil

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201004/1

On Thu, 8 Apr 2010 00:41:12 -0700 (PDT), neil40 <neil.grantham@googlemail.com>
wrote:

>Yes, that is what I see, a form with a blank last entry.
>This isn't what I'm hoping for though (or even know if it's possible),
>as I can achieve data entry like this with my single entry form.
>What I would like is a form like my single entry form, with maybe
>20-25 blank entries to add the entire league before submitting it to
>the table
>As I say, I don't know if it's possible to do it.

Possible? Probably. You could run an Append query from VBA to load the table
with 25 rows with blank fields; you'ld then need to separately update each of
those. Or you could use a very code-heavy unbound form with 25 rows of
textboxes, and some complicated and tricky VBA code to move that data into the
table (or from the table back onto the form for editing).

Desirable? Almost certainly NOT. If you have trouble keeping track of entries
now, they'll be much more complicated problems if you have a mix of "real
data" and blank "placeholder" records cluttering up your tables.

>The only advantage with the multi over the single I can see is that I
>will be able to see where I got to, whereas on the single, if I get
>distracted, then I have to open the table (or a report) to see what
>I've done.

The continuous form can certainly display as many prior records as will fit on
your screen. You can see what's there without separately opening a table or a
report.

-- 

             John W. Vinson [MVP]

On 8 Apr, 12:28, "BruceM via AccessMonster.com" <u54429@uwe> wrote:
> I don't understand the need to update the table with 20-25 records all at
> once. =A0What is the objection to entering records one at a time? =A0It m=
ay be
> possible to contrive an unbound form with dozens of text boxes, then loop
> through the text boxes to update the table with multiple records at once,=
 but
> that would be a lot of work to bypass the built-in functionality, even if=
 it
> is possible.
>
>
>
>
>
> neil40 wrote:
> >On 8 Apr, 01:26, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
> >wrote:
>
> >> >I can create a 'continuous' (or Multi-line) Form, but all the fields
> >> >are populated with table entries.
> >[quoted text clipped - 18 lines]
>
> >> =A0 =A0 =A0 =A0 =A0 =A0 =A0John W. Vinson [MVP]
>
> >Yes, that is what I see, a form with a blank last entry.
> >This isn't what I'm hoping for though (or even know if it's possible),
> >as I can achieve data entry like this with my single entry form.
> >What I would like is a form like my single entry form, with maybe
> >20-25 blank entries to add the entire league before submitting it to
> >the table
> >As I say, I don't know if it's possible to do it.
> >The only advantage with the multi over the single I can see is that I
> >will be able to see where I got to, whereas on the single, if I get
> >distracted, then I have to open the table (or a report) to see what
> >I've done.
>
> >Neil
>
> --
> Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Foru=
ms.aspx/access-forms/201004/1- Hide quoted text -
>
> - Show quoted text -

Thanks Bruce and John

I just thought it would be nice to have a form where I fill in the
League with nothing else on the form. it's not essential

It sounds like a lot of trouble and effort would be needed to create
such a thing, so I will stick with the standard continuous form.
On reflection, it is probably going to be better than my single entry
form, as I will see just where I got to.
Thanks again for your advice

Neil