quick query question

[pat67]

Does anyone know if there is a way in Access to create a schedule
based on criteria that i would set up? I would think there is, but I
am not sure.

 

[John W. Vinson]

Does anyone know if there is a way in Access to create a schedule
based on criteria that i would set up? I would think there is, but I
am not sure.

Ummm... that's awfully vague. What kind of schedule? What kind of criteria?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Bob Barrows]

Does anyone know if there is a way in Access to create a schedule
based on criteria that i would set up? I would think there is, but I
am not sure.

Yes

 

[pat67]

Yes

This is for a pool league that we play on Tuesday nights. So I want to
set up 32 weeks every Tuesday starting on a specific date. Some teams
play out of the same location so those teams cannot play at home the
same night. What I have is List of Team 1-10. A list of locations 1-6.
And that's where I am stuck.

 

[John W. Vinson]

This is for a pool league that we play on Tuesday nights. So I want to
set up 32 weeks every Tuesday starting on a specific date. Some teams
play out of the same location so those teams cannot play at home the
same night. What I have is List of Team 1-10. A list of locations 1-6.
And that's where I am stuck.

The next step is a Schedule table with a field for the Team, a field for the
Location, and a field for the date (don't name it Date, that's a reserved
word). Each record in this table would be one scheduled game.

You would need a Form to enter data into this table, and probably some code on
the form or in the criteria upon which the form is based to prevent anomalies
like one team playing in two locations on the same date, or play against
themselves, or the like. The details will vary depending on your table
structure.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[pat67]

The next step is a Schedule table with a field for the Team, a field for the
Location, and a field for the date (don't name it Date, that's a reserved
word). Each record in this table would be one scheduled game.

You would need a Form to enter data into this table, and probably some code on
the form or in the criteria upon which the form is based to prevent anomalies
like one team playing in two locations on the same date, or play against
themselves, or the like. The details will vary depending on your table
structure.
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

I guess I am explaining it wrong. I am looking for Access to generate
the schedule. I don't want to enter the details through a form. There
is software available that does this, but I was thinking of using
Access since I already have that and would not need to buy any new
software. If Access does not have the capability, that's fine. I was
not sure so that's why I was asking.

 

[John W. Vinson]

I guess I am explaining it wrong. I am looking for Access to generate
the schedule. I don't want to enter the details through a form. There
is software available that does this, but I was thinking of using
Access since I already have that and would not need to buy any new
software. If Access does not have the capability, that's fine. I was
not sure so that's why I was asking.

You should think of Access as a good, well equipped tool chest.

If you have a good, well equipped tool chest, you'll be able to build a
doghouse or a computer desk. But it won't come with a doghouse or computer
desk included. Same with Access; you could certainly use it to create an
application to generate a pool league schedule, but it doesn't contain one
"out of the box".
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[pat67]

You should think of Access as a good, well equipped tool chest.

If you have a good, well equipped tool chest, you'll be able to build a
doghouse or a computer desk. But it won't come with a doghouse or computer
desk included. Same with Access; you could certainly use it to create an
application to generate a pool league schedule, but it doesn't contain one
"out of the box".
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

So for someone who is like me say an intermediate user, this would be
very difficult?

 

[John W. Vinson]

So for someone who is like me say an intermediate user, this would be
very difficult?

It's a pretty good toolbox, but you will need to do some learning, and the
learning curve can be pretty steep. Here are some resources that might help
(not with pool league scoring but with Access in general):

Utter Access discussion forum and resources:
http://www.utteraccess.com

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[pat67]

It's a pretty good toolbox, but you will need to do some learning, and the
learning curve can be pretty steep. Here are some resources that might help
(not with pool league scoring but with Access in general):

Utter Access discussion forum and resources:http://www.utteraccess.com

Jeff Conrad's resources page:http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:http://allenbrowne.com/links.html#Tutorials

--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com- Hide quoted text -

- Show quoted text -

Thanks