Multiple databases, 1 form

[echorley]

Can a database be set up so that a few forms can be used to create multiple databases?

For example, I have made a database that holds football (American) statistics. I have created the forms I need to input all of the information, queries and reports to view the information and VB code to automate many of the processes.

Now, I want to be able to save the information from different games and eventually compile it into season statistics. When I open this database, I want to start with empty tables and have the option of looking at data from any other game or starting a new game. Any help or direction would be helpful. Thanks!

 

[echorley]

Great question!!

I guess I envision it working like Excel where you can have 1 file (or application), but multiple worksheets with tabs at the bottom. Right now I analyze the information from each game with Excel, but I was just wondering if it could all be done in Access.

 

[echorley]

Thanks!!

I get your thinking! It is amazing how one sits and agonizes over something that has such a simple solution. I was stuck thinking that I needed multiple tables or even other databases (one for each game, just like spreadsheets). Thanks for helping this coach out.