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
|
|||
|
|||
Is there any way to make global update on forms and report
Hello,
I have finished developping the church membership database for our denomination SDA church. From the one I made I have to adapt to each individual church the name of the church manually. My question is instead of goid to each report to edit the caption and label of the reports and forms, is there any quick way to revise the name of the church on the capiton and heder label of the reports and Forms?. Do you think we need a table for this and can direct it to any forms & reports for it;s caption and header? Thanks in advance for any help. Frank, Jakarta, Indonesia -- H. Frank Situmorang |
#2
|
|||
|
|||
Is there any way to make global update on forms and report
It is common for people who are using the same application, or the same
front end Database, for multiple organizations, to include a Table with "customization" information. The information from that Table can be read and either saved in Public Variables, as Properties of a Class, or in a Form that has its Visible property set to No. Or, the data can be retrieved where needed using the DLookup domain aggregate function. Or, you could obtain one of the third-party Find and Replace applicatons which will make a global change... you essentially tell it "wherever you find 'Nazareth Church' replace it with 'Abundant Life Church'" and it (giving you the option to skip the replace in each instance, unless you direct otherwise) will change every occurrence. One that I have used and been pleased with for Access 2003 is "Find & Replace" shareware from http://www.rickworld.com; another I've used and liked in the past, but that won't work with Access 2003 (you have to have an earlier version of Access installe) is "Speed Ferret" commercial software from http://www.moshannon.com. As you can guess, those can be very useful for other purposes, too, when you are developing. Larry Linson Microsoft Office Access MVP "Frank Situmorang" wrote in message ... Hello, I have finished developping the church membership database for our denomination SDA church. From the one I made I have to adapt to each individual church the name of the church manually. My question is instead of goid to each report to edit the caption and label of the reports and forms, is there any quick way to revise the name of the church on the capiton and heder label of the reports and Forms?. Do you think we need a table for this and can direct it to any forms & reports for it;s caption and header? Thanks in advance for any help. Frank, Jakarta, Indonesia -- H. Frank Situmorang |
#3
|
|||
|
|||
Is there any way to make global update on forms and report
Thanks Larry, this is good info for me.
Rgrds, -- H. Frank Situmorang "Larry Linson" wrote: It is common for people who are using the same application, or the same front end Database, for multiple organizations, to include a Table with "customization" information. The information from that Table can be read and either saved in Public Variables, as Properties of a Class, or in a Form that has its Visible property set to No. Or, the data can be retrieved where needed using the DLookup domain aggregate function. Or, you could obtain one of the third-party Find and Replace applicatons which will make a global change... you essentially tell it "wherever you find 'Nazareth Church' replace it with 'Abundant Life Church'" and it (giving you the option to skip the replace in each instance, unless you direct otherwise) will change every occurrence. One that I have used and been pleased with for Access 2003 is "Find & Replace" shareware from http://www.rickworld.com; another I've used and liked in the past, but that won't work with Access 2003 (you have to have an earlier version of Access installe) is "Speed Ferret" commercial software from http://www.moshannon.com. As you can guess, those can be very useful for other purposes, too, when you are developing. Larry Linson Microsoft Office Access MVP "Frank Situmorang" wrote in message ... Hello, I have finished developping the church membership database for our denomination SDA church. From the one I made I have to adapt to each individual church the name of the church manually. My question is instead of goid to each report to edit the caption and label of the reports and forms, is there any quick way to revise the name of the church on the capiton and heder label of the reports and Forms?. Do you think we need a table for this and can direct it to any forms & reports for it;s caption and header? Thanks in advance for any help. Frank, Jakarta, Indonesia -- H. Frank Situmorang |
#4
|
|||
|
|||
Is there any way to make global update on forms and report
Larry:
Can we use it if we will only replace the caption and label/header in Form and report?. I am affraid that it will replace the words in VBA will jeopardize everything. Thanks for your further help. -- H. Frank Situmorang "Larry Linson" wrote: It is common for people who are using the same application, or the same front end Database, for multiple organizations, to include a Table with "customization" information. The information from that Table can be read and either saved in Public Variables, as Properties of a Class, or in a Form that has its Visible property set to No. Or, the data can be retrieved where needed using the DLookup domain aggregate function. Or, you could obtain one of the third-party Find and Replace applicatons which will make a global change... you essentially tell it "wherever you find 'Nazareth Church' replace it with 'Abundant Life Church'" and it (giving you the option to skip the replace in each instance, unless you direct otherwise) will change every occurrence. One that I have used and been pleased with for Access 2003 is "Find & Replace" shareware from http://www.rickworld.com; another I've used and liked in the past, but that won't work with Access 2003 (you have to have an earlier version of Access installe) is "Speed Ferret" commercial software from http://www.moshannon.com. As you can guess, those can be very useful for other purposes, too, when you are developing. Larry Linson Microsoft Office Access MVP "Frank Situmorang" wrote in message ... Hello, I have finished developping the church membership database for our denomination SDA church. From the one I made I have to adapt to each individual church the name of the church manually. My question is instead of goid to each report to edit the caption and label of the reports and forms, is there any quick way to revise the name of the church on the capiton and heder label of the reports and Forms?. Do you think we need a table for this and can direct it to any forms & reports for it;s caption and header? Thanks in advance for any help. Frank, Jakarta, Indonesia -- H. Frank Situmorang |
Thread Tools | |
Display Modes | |
|
|