Automated File Creation

[Gary H]

At my office we have create databases 3 months that we have to distribute to
25 different departments, each requiring a certain subset of the data for
only their department. I would like to know if I can get it automated where
it can take the file and only have that certain data show up.

I.E. we have a standard report file (section_response_results) and we have
the standard data table (section_response_summary) which is where the report
file is populated from.

What I would like to do is the following:
1. Create a new file with the department appended at the end
2. Copy the section_response_results report
3. Copy the section_response_summary table with only the desired (i.e. dept
data) in it
4. Change the "Application Title" to include the Dept Name

How can this be done.

 

[Gary H]

We need to generate the report file which we provide to each of the
Departments with only their data, each of which is a subset that is pulled
from the main report which has all the data that goes to the Upper Management.

Instead of having to manually create the 25 subfiles that pertain to the
specific departments and other groupings of the data we wanted to have an
automated way to generate the files to save time.

 

[Gary H]

There is no common datashare, we actually will be giving them a CD or sending
them the file via email with their data.

I am new to this part of MS Access.

Thanks for your help

Of course it can be done but I was trying to determine if there was a common
network between the departments where each department could run their own
report.

We need to generate the report file which we provide to each of the
Departments with only their data, each of which is a subset that is pulled
from the main report which has all the data that goes to the Upper Management.

Instead of having to manually create the 25 subfiles that pertain to the
specific departments and other groupings of the data we wanted to have an
automated way to generate the files to save time.

So the only network you have between these departments is a Sneaker Net?

[quoted text clipped - 15 lines]

How can this be done.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[Gary H]

RG,
Thank you for your great assistance so far. Yes all departments have
Microsoft Access on their computers. As they may need to run their own
queries outside of the reports that we give them, we want to provide in the
Access file the Table with the compiled data and our standard reports based
on that data.

Thank you
G

Do all of the departments have Access? If so, do you want to send just a
report of do they have other reasond to have a table with data? You could
just send a snapshot file of a report and everyone could use the free
snapshot reader.

There is no common datashare, we actually will be giving them a CD or sending
them the file via email with their data.

I am new to this part of MS Access.

Thanks for your help

Of course it can be done but I was trying to determine if there was a common
network between the departments where each department could run their own

[quoted text clipped - 13 lines]

How can this be done.

 

[Gary H]

Currenlty every thing is in one main master file (all data and reports)

We wanted to give them a complete mdb file that has: 1 Table and 1 Report

Thank you.
G

Is your application split into FrontEnd and BackEnd files? Were you just
planning to give each department a complete mdb with only their data in the
tables?

RG,
Thank you for your great assistance so far. Yes all departments have
Microsoft Access on their computers. As they may need to run their own
queries outside of the reports that we give them, we want to provide in the
Access file the Table with the compiled data and our standard reports based
on that data.

Thank you
G

Do all of the departments have Access? If so, do you want to send just a
report of do they have other reasond to have a table with data? You could

[quoted text clipped - 13 lines]

How can this be done.

 

[KC2NPU]

Hi RG,

The Department for each record is indicated in the table. We have 23
departments that are currently getting the reports.

There are no forms or anything else, we are just giving them the
compiled data. Yes, the report will be the same for every department,
the only thing that changes is their data.

Thanks
G (using my Google now to post)

No Forms or anything but the one table and the report right?  How many
departments?  Do you have these departments listed in a table somewhere?
Will the report be the same for each department, just with their individual
data?

Currenlty every thing is in one main masterfile(all data and reports)

We wanted to give them a complete mdbfilethat has: 1 Table and 1 Report

Thank you.
G

Is your application split into FrontEnd and BackEnd files?  Were youjust
planning to give each department a complete mdb with only their data in the

[quoted text clipped - 15 lines]

How can this be done.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200807/1

 

[KC2NPU]

Thank you, i will start to research that (this is my first ACCESS
programming attempt)

I would start by using your table with the department names in it and the
CreateDatabase() function to create the 23 different MDB files. If you are
having trouble with this part then post back with the code you have so wecan
help.

Hi RG,

The Department for each record is indicated in the table.  We have 23
departments that are currently getting the reports.

There are no forms or anything else, we are just giving them the
compiled data. Yes, the report will be the same for every department,
the only thing that changes is their data.

Thanks
G (using my Google now to post)

No Forms or anything but the one table and the report right?  How many
departments?  Do you have these departments listed in a table somewhere?

[quoted text clipped - 19 lines]

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200807/1

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200807/1