Using an Excel workbook
 

I have an Excel worbook containing worksheets of all our baseball
participants from last year. I would like to use it to facilitate our
registration this year.

Here's my idea.

I would like to setup several laptops with access to a hub and server. I
would like to be able to register players for the season by first searching
for a current record for the player. If one is found, I would like to open a
form containing the registration information and confirm or change and save
the updated information.

If one is not found, i would like to open a registration form that can be
completed and saved and save as a record on a specific worksheet based on the
age of the player.

2 questions:

Is it possible?

and

How difficult is it to setup?

Using an Excel workbook
 

If you're gonna have multiple people accessing that database simultaneously,
excel might not be the best solution. You may want to consider a real database
application (Access???).



jrchappell75 wrote:

I have an Excel worbook containing worksheets of all our baseball
participants from last year. I would like to use it to facilitate our
registration this year.

Here's my idea.

I would like to setup several laptops with access to a hub and server. I
would like to be able to register players for the season by first searching
for a current record for the player. If one is found, I would like to open a
form containing the registration information and confirm or change and save
the updated information.

If one is not found, i would like to open a registration form that can be
completed and saved and save as a record on a specific worksheet based on the
age of the player.

2 questions:

Is it possible?

and

How difficult is it to setup?

--

Dave Peterson

Using an Excel workbook
 

Okay.. What if we placed a copy on each laptop and let them run independantly?

Can it be done?

Is it difficult?

"Dave Peterson" wrote:

If you're gonna have multiple people accessing that database simultaneously,
excel might not be the best solution. You may want to consider a real database
application (Access???).



jrchappell75 wrote:

I have an Excel worbook containing worksheets of all our baseball
participants from last year. I would like to use it to facilitate our
registration this year.

Here's my idea.

I would like to setup several laptops with access to a hub and server. I
would like to be able to register players for the season by first searching
for a current record for the player. If one is found, I would like to open a
form containing the registration information and confirm or change and save
the updated information.

If one is not found, i would like to open a registration form that can be
completed and saved and save as a record on a specific worksheet based on the
age of the player.

2 questions:

Is it possible?

and

How difficult is it to setup?

--

Dave Peterson

Using an Excel workbook
 

Have you ever designed a form? Are you knowledgeable in excel/VBA? How do you
expect to merge the data?

It sounds non-trivial to me.

An alternative (that I'd use--simply because it would be simple).

Copy last year's workbook and name it to 2006.

Clean up any field that refers to last year (keeping all the other fields in
tact).

Add an indicator field to show if the record should be kept in 2006.

Then apply Data|filter|autofilter to the data.

Use those filters (or just Edit|Find) to search for that existing record. If
found, update it. If not found, add it.

Then when you're done, you could take all the workbooks, merge them into one
giant worksheet. Filter on that indicator record and show the players who
didn't register for 2006. Then delete all those visible rows.



jrchappell75 wrote:

Okay.. What if we placed a copy on each laptop and let them run independantly?

Can it be done?

Is it difficult?

"Dave Peterson" wrote:

If you're gonna have multiple people accessing that database simultaneously,
excel might not be the best solution. You may want to consider a real database
application (Access???).



jrchappell75 wrote:

I have an Excel worbook containing worksheets of all our baseball
participants from last year. I would like to use it to facilitate our
registration this year.

Here's my idea.

I would like to setup several laptops with access to a hub and server. I
would like to be able to register players for the season by first searching
for a current record for the player. If one is found, I would like to open a
form containing the registration information and confirm or change and save
the updated information.

If one is not found, i would like to open a registration form that can be
completed and saved and save as a record on a specific worksheet based on the
age of the player.

2 questions:

Is it possible?

and

How difficult is it to setup?

--

Dave Peterson


--

Dave Peterson

Using an Excel workbook
 

I don't have much experience. I am currently updates last years records and
wanted a method that would take all the papershuffling out of it. It doesnt
need to be impressive, just easier to keep and update. I like your idea.

Thank you very much for your help.


"Dave Peterson" wrote:

Have you ever designed a form? Are you knowledgeable in excel/VBA? How do you
expect to merge the data?

It sounds non-trivial to me.

An alternative (that I'd use--simply because it would be simple).

Copy last year's workbook and name it to 2006.

Clean up any field that refers to last year (keeping all the other fields in
tact).

Add an indicator field to show if the record should be kept in 2006.

Then apply Data|filter|autofilter to the data.

Use those filters (or just Edit|Find) to search for that existing record. If
found, update it. If not found, add it.

Then when you're done, you could take all the workbooks, merge them into one
giant worksheet. Filter on that indicator record and show the players who
didn't register for 2006. Then delete all those visible rows.



jrchappell75 wrote:

Okay.. What if we placed a copy on each laptop and let them run independantly?

Can it be done?

Is it difficult?

"Dave Peterson" wrote:

If you're gonna have multiple people accessing that database simultaneously,
excel might not be the best solution. You may want to consider a real database
application (Access???).



jrchappell75 wrote:

I have an Excel worbook containing worksheets of all our baseball
participants from last year. I would like to use it to facilitate our
registration this year.

Here's my idea.

I would like to setup several laptops with access to a hub and server. I
would like to be able to register players for the season by first searching
for a current record for the player. If one is found, I would like to open a
form containing the registration information and confirm or change and save
the updated information.

If one is not found, i would like to open a registration form that can be
completed and saved and save as a record on a specific worksheet based on the
age of the player.

2 questions:

Is it possible?

and

How difficult is it to setup?

--

Dave Peterson


--

Dave Peterson