Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 - Why does 1 workbook open as 2 versions | Excel Discussion (Misc queries) | |||
Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Can a workbook be opened w/out Excel on the host machine?? | Excel Discussion (Misc queries) | |||
Why does Excel 2003 freeze when saving a workbook that has importe | Excel Worksheet Functions |