Global Name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was asked to design a database for my school, but I am sure that other schools in the district are going to want their own copies as well.

How can I design my 30+ reports, which all include the name of the school, so I don't have to change the titles of them all each time I move the database to a new school?

I would like to have the school name stored somewhere that I can change once and it would change all my reports.

Any help?
 
Create a table with one record. Put the name of the school in that table's
record.

Then either use DLookup in the control source for the reports' textboxes
that are the titles in your reports to get the name of the school from the
table, or join that table into all queries that are the recordsources for
the reports and use the school name field as the control source for the
reports' textboxes that are the titles in your reports.

--

Ken Snell
<MS ACCESS MVP>

Ripper said:
I was asked to design a database for my school, but I am sure that other
Click to expand...
schools in the district are going to want their own copies as well.
How can I design my 30+ reports, which all include the name of the school,
Click to expand...
so I don't have to change the titles of them all each time I move the
database to a new school?
I would like to have the school name stored somewhere that I can change
Click to expand...
once and it would change all my reports.
 
I useally build a table, and in that table I put in a bunch of default stuff
that aI can change.

Stuf like:

Default City
DefaultState
DefaultAreaCode
SchoolName

I then simply build a nice form, and of course this table as only ONE
record. Note that this table goes in the front end part (you are running a
split database ....especially if you plan to distribute this..right?).

You can then in your startup routines open the form, and then make it
invisible.

Now, any time you need the company name, you simply place a control on a
form, or report to show the school name like:go:

=(forms!frmDefaults!SchoolName)

You can also just ref the table name direclty, and not even bother opening a
form. So, make the text box:

=dlookup("SchoolName","tblDefaults")

-
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.attcanada.net/~kallal.msn
 
Sure, we can do that.

Create a table say tblSchoolInfo with all the fields that
would identify that school. This table will only have one
record at all times. For simplicity at the moment have
crate just one field (text) called SchoolName.

Take one of the reports and add in a text box. Name it
txtSchoolName and use this as a Control Source:

=DLookUp("[SchoolName]","tblSchoolInfo")

Make any formatting changes you wish until it is just
perfect. Now just copy/paste this text box onto each
report's header. Each report will display the school's
name at the top.

Then all you need to do is create a simple form to
display/add/edit information to this one record in the
table.
 
You guys ROCK!
--
Thanks As Always
Rip


Jeff Conrad said:
Sure, we can do that.

Create a table say tblSchoolInfo with all the fields that
would identify that school. This table will only have one
record at all times. For simplicity at the moment have
crate just one field (text) called SchoolName.

Take one of the reports and add in a text box. Name it
txtSchoolName and use this as a Control Source:

=DLookUp("[SchoolName]","tblSchoolInfo")

Make any formatting changes you wish until it is just
perfect. Now just copy/paste this text box onto each
report's header. Each report will display the school's
name at the top.

Then all you need to do is create a simple form to
display/add/edit information to this one record in the
table.
Click to expand...
 
Actually Ken and Albert "Rock", I just collect moss.

You're welcome, glad to help.

--
Jeff Conrad
Access Junkie
Bend, Oregon
-----Original Message-----
You guys ROCK!
--
Thanks As Always
Rip


Jeff Conrad said:
Sure, we can do that.

Create a table say tblSchoolInfo with all the fields that
would identify that school. This table will only have one
record at all times. For simplicity at the moment have
crate just one field (text) called SchoolName.

Take one of the reports and add in a text box. Name it
txtSchoolName and use this as a Control Source:

=DLookUp("[SchoolName]","tblSchoolInfo")

Make any formatting changes you wish until it is just
perfect. Now just copy/paste this text box onto each
report's header. Each report will display the school's
name at the top.

Then all you need to do is create a simple form to
display/add/edit information to this one record in the
table.

--
Jeff Conrad
Access Junkie
Bend, Oregon
-----Original Message-----
I was asked to design a database for my school, but I am
sure that other schools in the district are going to want
their own copies as well.

How can I design my 30+ reports, which all include the
name of the school, so I don't have to change the titles
of them all each time I move the database to a new school?

I would like to have the school name stored somewhere
that I can change once and it would change all my reports.

Any help?
Click to expand...
.
Click to expand...
Click to expand...
 
LOL!
:-)

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Jeff Conrad said:
Actually Ken and Albert "Rock", I just collect moss.

You're welcome, glad to help.

--
Jeff Conrad
Access Junkie
Bend, Oregon
-----Original Message-----
You guys ROCK!
--
Thanks As Always
Rip


Jeff Conrad said:
Sure, we can do that.

Create a table say tblSchoolInfo with all the fields that
would identify that school. This table will only have one
record at all times. For simplicity at the moment have
crate just one field (text) called SchoolName.

Take one of the reports and add in a text box. Name it
txtSchoolName and use this as a Control Source:

=DLookUp("[SchoolName]","tblSchoolInfo")

Make any formatting changes you wish until it is just
perfect. Now just copy/paste this text box onto each
report's header. Each report will display the school's
name at the top.

Then all you need to do is create a simple form to
display/add/edit information to this one record in the
table.

--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
I was asked to design a database for my school, but I am
sure that other schools in the district are going to want
their own copies as well.

How can I design my 30+ reports, which all include the
name of the school, so I don't have to change the titles
of them all each time I move the database to a new school?

I would like to have the school name stored somewhere
that I can change once and it would change all my reports.

Any help?
Click to expand...
.
Click to expand...
Click to expand...
 
"Patience, grasshopper...."

< G >


--

Ken Snell
<MS ACCESS MVP>

Jeff Conrad said:
Actually Ken and Albert "Rock", I just collect moss.

You're welcome, glad to help.

--
Jeff Conrad
Access Junkie
Bend, Oregon
-----Original Message-----
You guys ROCK!
--
Thanks As Always
Rip


Jeff Conrad said:
Sure, we can do that.

Create a table say tblSchoolInfo with all the fields that
would identify that school. This table will only have one
record at all times. For simplicity at the moment have
crate just one field (text) called SchoolName.

Take one of the reports and add in a text box. Name it
txtSchoolName and use this as a Control Source:

=DLookUp("[SchoolName]","tblSchoolInfo")

Make any formatting changes you wish until it is just
perfect. Now just copy/paste this text box onto each
report's header. Each report will display the school's
name at the top.

Then all you need to do is create a simple form to
display/add/edit information to this one record in the
table.

--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
I was asked to design a database for my school, but I am
sure that other schools in the district are going to want
their own copies as well.

How can I design my 30+ reports, which all include the
name of the school, so I don't have to change the titles
of them all each time I move the database to a new school?

I would like to have the school name stored somewhere
that I can change once and it would change all my reports.

Any help?
Click to expand...
.
Click to expand...
Click to expand...
 
Don't laugh too hard Sensei!
Rest up from your dental work.

--
Jeff Conrad
Access Junkie
Bend, Oregon
-----Original Message-----
LOL!
:-)

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Jeff Conrad said:
Actually Ken and Albert "Rock", I just collect moss.

You're welcome, glad to help.

--
Jeff Conrad
Access Junkie
Bend, Oregon
-----Original Message-----
You guys ROCK!
--
Thanks As Always
Rip


:

Sure, we can do that.

Create a table say tblSchoolInfo with all the fields that
would identify that school. This table will only have one
record at all times. For simplicity at the moment have
crate just one field (text) called SchoolName.

Take one of the reports and add in a text box. Name it
txtSchoolName and use this as a Control Source:

=DLookUp("[SchoolName]","tblSchoolInfo")

Make any formatting changes you wish until it is just
perfect. Now just copy/paste this text box onto each
report's header. Each report will display the school's
name at the top.

Then all you need to do is create a simple form to
display/add/edit information to this one record in the
table.

--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
I was asked to design a database for my school, but
Click to expand...
I
am
sure that other schools in the district are going to want
their own copies as well.

How can I design my 30+ reports, which all include the
name of the school, so I don't have to change the titles
of them all each time I move the database to a new school?

I would like to have the school name stored somewhere
that I can change once and it would change all my reports.

Any help?
Click to expand...
Click to expand...
Click to expand...
 
Yes, Master!
Must learn patience!

--
Jeff Conrad
Access Junkie
Bend, Oregon
-----Original Message-----
"Patience, grasshopper...."

< G >


--

Ken Snell
<MS ACCESS MVP>

Jeff Conrad said:
Actually Ken and Albert "Rock", I just collect moss.

You're welcome, glad to help.

--
Jeff Conrad
Access Junkie
Bend, Oregon
-----Original Message-----
You guys ROCK!
--
Thanks As Always
Rip


:

Sure, we can do that.

Create a table say tblSchoolInfo with all the fields that
would identify that school. This table will only have one
record at all times. For simplicity at the moment have
crate just one field (text) called SchoolName.

Take one of the reports and add in a text box. Name it
txtSchoolName and use this as a Control Source:

=DLookUp("[SchoolName]","tblSchoolInfo")

Make any formatting changes you wish until it is just
perfect. Now just copy/paste this text box onto each
report's header. Each report will display the school's
name at the top.

Then all you need to do is create a simple form to
display/add/edit information to this one record in the
table.

--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
I was asked to design a database for my school, but
Click to expand...
I
am
sure that other schools in the district are going to want
their own copies as well.

How can I design my 30+ reports, which all include the
name of the school, so I don't have to change the titles
of them all each time I move the database to a new school?

I would like to have the school name stored somewhere
that I can change once and it would change all my reports.

Any help?
--
Thanks As Always
Rip

.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top