If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Script to Update a Excel Database whenever a Access Database is mo
Hello, i am wondering about something fairly complex, i have two databases,
one in the access format (the most utilized one) and another one in excel format, Since we use the Access one the most, but cannot print the informations that it contains, i was forced to create a new one which you can print off of, so here is the issue, whenever we add new information to the access database, we need to manually update the excel one and it's very unconvenient, because since we do not use it very often, it falls in the depths of The Documents. My question to any expert out there is, Is there a script that is made or can be made, that whenever new information is inputed in the access file, automaticaly gets written to the excel database, like a automator. Would that be something possbible to create? Or maybe, in all better cases is already created? Thanks alot, responses are appreciated. |
#2
|
|||
|
|||
Script to Update a Excel Database whenever a Access Database is mo
What do you mean when you say you can't print the information
in your Acess db? Why not? -- _________ Sean Bailey "Finnbar" wrote: Hello, i am wondering about something fairly complex, i have two databases, one in the access format (the most utilized one) and another one in excel format, Since we use the Access one the most, but cannot print the informations that it contains, i was forced to create a new one which you can print off of, so here is the issue, whenever we add new information to the access database, we need to manually update the excel one and it's very unconvenient, because since we do not use it very often, it falls in the depths of The Documents. My question to any expert out there is, Is there a script that is made or can be made, that whenever new information is inputed in the access file, automaticaly gets written to the excel database, like a automator. Would that be something possbible to create? Or maybe, in all better cases is already created? Thanks alot, responses are appreciated. |
#3
|
|||
|
|||
Script to Update a Excel Database whenever a Access Database i
The way it was designed ~7 years ago does not allow printing i believe,
because you type in a customer name and it brings you to a customer page with all the information, but it's individual, it doesnt give you an "overview" of all the customer information like you would see in excel. "Beetle" wrote: What do you mean when you say you can't print the information in your Acess db? Why not? -- _________ Sean Bailey "Finnbar" wrote: Hello, i am wondering about something fairly complex, i have two databases, one in the access format (the most utilized one) and another one in excel format, Since we use the Access one the most, but cannot print the informations that it contains, i was forced to create a new one which you can print off of, so here is the issue, whenever we add new information to the access database, we need to manually update the excel one and it's very unconvenient, because since we do not use it very often, it falls in the depths of The Documents. My question to any expert out there is, Is there a script that is made or can be made, that whenever new information is inputed in the access file, automaticaly gets written to the excel database, like a automator. Would that be something possbible to create? Or maybe, in all better cases is already created? Thanks alot, responses are appreciated. |
#4
|
|||
|
|||
Script to Update a Excel Database whenever a Access Database i
In Access, you use Reports for printing information. What you would
typically do is create a query of the information you want to see, then create a report based on that query. If you are unfamiliar with doing either of the above you can use the built in wizards. Since your original question was about creating a script, I'm assuming that you have access to the design side of the application so that you can do the above. I think you would find this a much easier solution than trying to keep two different applications in synch just so you can print information occasionally. -- _________ Sean Bailey "Finnbar" wrote: The way it was designed ~7 years ago does not allow printing i believe, because you type in a customer name and it brings you to a customer page with all the information, but it's individual, it doesnt give you an "overview" of all the customer information like you would see in excel. "Beetle" wrote: What do you mean when you say you can't print the information in your Acess db? Why not? -- _________ Sean Bailey "Finnbar" wrote: Hello, i am wondering about something fairly complex, i have two databases, one in the access format (the most utilized one) and another one in excel format, Since we use the Access one the most, but cannot print the informations that it contains, i was forced to create a new one which you can print off of, so here is the issue, whenever we add new information to the access database, we need to manually update the excel one and it's very unconvenient, because since we do not use it very often, it falls in the depths of The Documents. My question to any expert out there is, Is there a script that is made or can be made, that whenever new information is inputed in the access file, automaticaly gets written to the excel database, like a automator. Would that be something possbible to create? Or maybe, in all better cases is already created? Thanks alot, responses are appreciated. |
#5
|
|||
|
|||
Script to Update a Excel Database whenever a Access Database is mo
On Fri, 31 Oct 2008 12:06:01 -0700, Finnbar
wrote: Hello, i am wondering about something fairly complex, i have two databases, one in the access format (the most utilized one) and another one in excel format, Since we use the Access one the most, but cannot print the informations that it contains, i was forced to create a new one which you can print off of, so here is the issue, whenever we add new information to the access database, we need to manually update the excel one and it's very unconvenient, because since we do not use it very often, it falls in the depths of The Documents. My question to any expert out there is, Is there a script that is made or can be made, that whenever new information is inputed in the access file, automaticaly gets written to the excel database, like a automator. Would that be something possbible to create? Or maybe, in all better cases is already created? Thanks alot, responses are appreciated. As Beetle says... why on Earth do you feel that you can't print data from Access? The program has a very powerful report generator; anything that you can print from Excel can be printed from Access. If you have some need to manage the data in Excel, be aware that you can use Excel as a frontend to Access. It's neither necessary nor good practice to store the same data in two different places. -- John W. Vinson [MVP] |
#6
|
|||
|
|||
Script to Update a Excel Database whenever a Access Database i
Would linking the Access database to an Excel file which updates whenever i
open it up jeaperdize any of the data on the access database? The thing i want to accomplish really, is to be able to see all the information without having to go trough each individual customer info, rather, just see all the information in a big page with all the info on it. "John W. Vinson" wrote: On Fri, 31 Oct 2008 12:06:01 -0700, Finnbar wrote: Hello, i am wondering about something fairly complex, i have two databases, one in the access format (the most utilized one) and another one in excel format, Since we use the Access one the most, but cannot print the informations that it contains, i was forced to create a new one which you can print off of, so here is the issue, whenever we add new information to the access database, we need to manually update the excel one and it's very unconvenient, because since we do not use it very often, it falls in the depths of The Documents. My question to any expert out there is, Is there a script that is made or can be made, that whenever new information is inputed in the access file, automaticaly gets written to the excel database, like a automator. Would that be something possbible to create? Or maybe, in all better cases is already created? Thanks alot, responses are appreciated. As Beetle says... why on Earth do you feel that you can't print data from Access? The program has a very powerful report generator; anything that you can print from Excel can be printed from Access. If you have some need to manage the data in Excel, be aware that you can use Excel as a frontend to Access. It's neither necessary nor good practice to store the same data in two different places. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|