Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 11th 06, 02:38 PM posted to microsoft.public.excel.misc
jrchappell75
 
Posts: n/a
Default 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?

  #2   Report Post  
Old January 11th 06, 03:32 PM posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
  #3   Report Post  
Old January 11th 06, 03:41 PM posted to microsoft.public.excel.misc
jrchappell75
 
Posts: n/a
Default 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

  #4   Report Post  
Old January 11th 06, 03:55 PM posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
  #5   Report Post  
Old January 11th 06, 04:36 PM posted to microsoft.public.excel.misc
jrchappell75
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 - Why does 1 workbook open as 2 versions B. Levien Excel Discussion (Misc queries) 2 September 30th 05 02:34 PM
Display form from an VB application in Excel kuhni Excel Discussion (Misc queries) 0 August 10th 05 06:04 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Can a workbook be opened w/out Excel on the host machine?? MIchelleDuquette Excel Discussion (Misc queries) 2 May 5th 05 08:18 PM
Why does Excel 2003 freeze when saving a workbook that has importe NeedToKnow Excel Worksheet Functions 0 February 18th 05 11:07 PM


All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017