 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / July 2008Automated File Creation
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. So the only network you have between these departments is a Sneaker Net? >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 [quoted text clipped - 13 lines] > >How can this be done.  SignatureRuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. 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. 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 [quoted text clipped - 9 lines] >> > >> >How can this be done. SignatureRuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. 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. 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. [quoted text clipped - 8 lines] >> >> > >> >> >How can this be done. SignatureRuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. 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. 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 [quoted text clipped - 11 lines] >> >> >> > >> >> >> >How can this be done. SignatureRuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. 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 [quoted text clipped - 15 lines] > >> >> >> > > >> >> >> >How can this be done. 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 master file (all data and reports) > [quoted text clipped - 8 lines] >> >> >> >> > >> >> >> >> >How can this be done. SignatureRuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. 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) On Jul 16, 5:01 pm, "ruralguy via AccessMonster.com" <u12102@uwe> wrote: > 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 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 we can help. >Hi RG, > [quoted text clipped - 15 lines] >> >> Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200807/1 SignatureRuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Thank you, i will start to research that (this is my first ACCESS programming attempt) On Jul 17, 7:09 pm, "ruralguy via AccessMonster.com" <u12102@uwe> wrote: > 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 [quoted text clipped - 27 lines] > > Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200807/1 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.