A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Is there any way to make global update on forms and report



 
 
Thread Tools Display Modes
  #1  
Old July 31st, 2008, 03:24 AM posted to microsoft.public.access.forms
Frank Situmorang[_2_]
external usenet poster
 
Posts: 340
Default 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  
Old July 31st, 2008, 05:09 AM posted to microsoft.public.access.forms
Larry Linson
external usenet poster
 
Posts: 3,112
Default 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  
Old July 31st, 2008, 05:52 AM posted to microsoft.public.access.forms
Frank Situmorang[_2_]
external usenet poster
 
Posts: 340
Default 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  
Old July 31st, 2008, 06:28 AM posted to microsoft.public.access.forms
Frank Situmorang[_2_]
external usenet poster
 
Posts: 340
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:15 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.