Photo Directory Template
in [Getting Started]
|
Prev: DCount with one single condition works, but several ones, joined t
Next: Storig data from website to database
From: Cheryl on 14 Feb 2010 20:11 In the Field List it is called Wedding Anniversary. When looking at the properties of the label it says Label9. Thank you so much! "Gina Whipp" wrote: > Cheryl, > > Yes it does and you can't use a label to do that without VBA BUT you can use > a text box. What is the name of the field that has the Wedding Anniversary > date in in it and I will type instructions for you. > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message > news:CD385E0E-A091-4B26-904E-5CFE4E386D4C(a)microsoft.com... > That would be great! :) > > When I insert a field into the report (which is how I plan to print the > directory), how can I tell it to not label the field in the print if there > is > no entry in the field? For instance, if I insert the Wedding Anniversary > field, I would like it only to print "Wedding Anniversary" if there is a > date > in that field, otherwise I would like it to just be blank. Hope this makes > sense! > > Thank you for the help! > Cheryl > > "Gina Whipp" wrote: > > > Cheryl, > > > > Sorry I couldn't find one closer but perhaps if you tell us where you got > > stuck we can get you unstuck. > > > > -- > > Gina Whipp > > 2010 Microsoft MVP (Access) > > > > "I feel I have been denied critical, need to know, information!" - Tremors > > II > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message > > news:53E65200-9337-4587-89D7-3132C8B4FA4B(a)microsoft.com... > > Thank you. The Contact Management Database is the one that I started with > > originally, but it is not working out well for what I am trying to do. I > > probably am just not knowledgeable enough to use this program...was just > > hoping there might be a template out there that might be more of what I am > > looking for. Thanks again. > > > > "Gina Whipp" wrote: > > > > > Cheryl, > > > > > > Sorry your initial response was a request for monies. That is not the > > > purpose of this newsgroup. > > > > > > It sounds like you are looking for more of a member database??? Below > > > are > > > a > > > few FREE templates available from Microsoft that might get you > > > started... > > > > > > http://office.microsoft.com/en-us/templates/TC012253431033.aspx?CategoryID=CT101428241033 > > > > > > http://office.microsoft.com/en-us/templates/TC012253451033.aspx?CategoryID=CT101428241033 > > > > > > http://office.microsoft.com/en-us/templates/TC300076981033.aspx?CategoryID=CT101428241033 > > > > > > Here's the complete list... > > > http://office.microsoft.com/en-us/templates/CT101428241033.aspx > > > > > > -- > > > Gina Whipp > > > 2010 Microsoft MVP (Access) > > > > > > "I feel I have been denied critical, need to know, information!" - > > > Tremors > > > II > > > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > > > "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message > > > news:EF3DA7B4-53DF-478F-B508-9DEDDF445430(a)microsoft.com... > > > I am looking for an Access 2007 Photo Directory template. I am trying > > > to > > > make a members database that will print a photo directory for our > > > church, > > > but > > > I am having a hard time because I don't know Access well enough to make > > > the > > > form and report work right together. Any help is appreciated! Thank > > > you! > > > > > > > > > . > > > > > > > > > . > > > > > . >
From: Gina Whipp on 15 Feb 2010 08:31 Cheryl, Try this... 1. Delete Label9 2. Put a Text Box in it's place 3. In the Control Source of the Text Box place... =IIf(IsNull([Wedding Anniversary]),"","Wedding Anniversary") 4. Set the Text for Enabled = No, Locked = Yes and Tab Stop = No -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message news:AAA42738-DF9F-4F94-8C95-787D1B90B03A(a)microsoft.com... In the Field List it is called Wedding Anniversary. When looking at the properties of the label it says Label9. Thank you so much! "Gina Whipp" wrote: > Cheryl, > > Yes it does and you can't use a label to do that without VBA BUT you can > use > a text box. What is the name of the field that has the Wedding > Anniversary > date in in it and I will type instructions for you. > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message > news:CD385E0E-A091-4B26-904E-5CFE4E386D4C(a)microsoft.com... > That would be great! :) > > When I insert a field into the report (which is how I plan to print the > directory), how can I tell it to not label the field in the print if there > is > no entry in the field? For instance, if I insert the Wedding Anniversary > field, I would like it only to print "Wedding Anniversary" if there is a > date > in that field, otherwise I would like it to just be blank. Hope this > makes > sense! > > Thank you for the help! > Cheryl > > "Gina Whipp" wrote: > > > Cheryl, > > > > Sorry I couldn't find one closer but perhaps if you tell us where you > > got > > stuck we can get you unstuck. > > > > -- > > Gina Whipp > > 2010 Microsoft MVP (Access) > > > > "I feel I have been denied critical, need to know, information!" - > > Tremors > > II > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message > > news:53E65200-9337-4587-89D7-3132C8B4FA4B(a)microsoft.com... > > Thank you. The Contact Management Database is the one that I started > > with > > originally, but it is not working out well for what I am trying to do. > > I > > probably am just not knowledgeable enough to use this program...was just > > hoping there might be a template out there that might be more of what I > > am > > looking for. Thanks again. > > > > "Gina Whipp" wrote: > > > > > Cheryl, > > > > > > Sorry your initial response was a request for monies. That is not the > > > purpose of this newsgroup. > > > > > > It sounds like you are looking for more of a member database??? Below > > > are > > > a > > > few FREE templates available from Microsoft that might get you > > > started... > > > > > > http://office.microsoft.com/en-us/templates/TC012253431033.aspx?CategoryID=CT101428241033 > > > > > > http://office.microsoft.com/en-us/templates/TC012253451033.aspx?CategoryID=CT101428241033 > > > > > > http://office.microsoft.com/en-us/templates/TC300076981033.aspx?CategoryID=CT101428241033 > > > > > > Here's the complete list... > > > http://office.microsoft.com/en-us/templates/CT101428241033.aspx > > > > > > -- > > > Gina Whipp > > > 2010 Microsoft MVP (Access) > > > > > > "I feel I have been denied critical, need to know, information!" - > > > Tremors > > > II > > > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > > > "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message > > > news:EF3DA7B4-53DF-478F-B508-9DEDDF445430(a)microsoft.com... > > > I am looking for an Access 2007 Photo Directory template. I am trying > > > to > > > make a members database that will print a photo directory for our > > > church, > > > but > > > I am having a hard time because I don't know Access well enough to > > > make > > > the > > > form and report work right together. Any help is appreciated! Thank > > > you! > > > > > > > > > . > > > > > > > > > . > > > > > . >
From: Cheryl on 15 Feb 2010 17:07 Exactly what I needed! Thank you so much, it is perfect now! :) "Gina Whipp" wrote: > Cheryl, > > Try this... > > 1. Delete Label9 > 2. Put a Text Box in it's place > 3. In the Control Source of the Text Box place... > > =IIf(IsNull([Wedding Anniversary]),"","Wedding Anniversary") > > 4. Set the Text for Enabled = No, Locked = Yes and Tab Stop = No > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message > news:AAA42738-DF9F-4F94-8C95-787D1B90B03A(a)microsoft.com... > In the Field List it is called Wedding Anniversary. When looking at the > properties of the label it says Label9. > > Thank you so much! > > > "Gina Whipp" wrote: > > > Cheryl, > > > > Yes it does and you can't use a label to do that without VBA BUT you can > > use > > a text box. What is the name of the field that has the Wedding > > Anniversary > > date in in it and I will type instructions for you. > > > > -- > > Gina Whipp > > 2010 Microsoft MVP (Access) > > > > "I feel I have been denied critical, need to know, information!" - Tremors > > II > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message > > news:CD385E0E-A091-4B26-904E-5CFE4E386D4C(a)microsoft.com... > > That would be great! :) > > > > When I insert a field into the report (which is how I plan to print the > > directory), how can I tell it to not label the field in the print if there > > is > > no entry in the field? For instance, if I insert the Wedding Anniversary > > field, I would like it only to print "Wedding Anniversary" if there is a > > date > > in that field, otherwise I would like it to just be blank. Hope this > > makes > > sense! > > > > Thank you for the help! > > Cheryl > > > > "Gina Whipp" wrote: > > > > > Cheryl, > > > > > > Sorry I couldn't find one closer but perhaps if you tell us where you > > > got > > > stuck we can get you unstuck. > > > > > > -- > > > Gina Whipp > > > 2010 Microsoft MVP (Access) > > > > > > "I feel I have been denied critical, need to know, information!" - > > > Tremors > > > II > > > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > > > "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message > > > news:53E65200-9337-4587-89D7-3132C8B4FA4B(a)microsoft.com... > > > Thank you. The Contact Management Database is the one that I started > > > with > > > originally, but it is not working out well for what I am trying to do. > > > I > > > probably am just not knowledgeable enough to use this program...was just > > > hoping there might be a template out there that might be more of what I > > > am > > > looking for. Thanks again. > > > > > > "Gina Whipp" wrote: > > > > > > > Cheryl, > > > > > > > > Sorry your initial response was a request for monies. That is not the > > > > purpose of this newsgroup. > > > > > > > > It sounds like you are looking for more of a member database??? Below > > > > are > > > > a > > > > few FREE templates available from Microsoft that might get you > > > > started... > > > > > > > > http://office.microsoft.com/en-us/templates/TC012253431033.aspx?CategoryID=CT101428241033 > > > > > > > > http://office.microsoft.com/en-us/templates/TC012253451033.aspx?CategoryID=CT101428241033 > > > > > > > > http://office.microsoft.com/en-us/templates/TC300076981033.aspx?CategoryID=CT101428241033 > > > > > > > > Here's the complete list... > > > > http://office.microsoft.com/en-us/templates/CT101428241033.aspx > > > > > > > > -- > > > > Gina Whipp > > > > 2010 Microsoft MVP (Access) > > > > > > > > "I feel I have been denied critical, need to know, information!" - > > > > Tremors > > > > II > > > > > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > > > > > "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message > > > > news:EF3DA7B4-53DF-478F-B508-9DEDDF445430(a)microsoft.com... > > > > I am looking for an Access 2007 Photo Directory template. I am trying > > > > to > > > > make a members database that will print a photo directory for our > > > > church, > > > > but > > > > I am having a hard time because I don't know Access well enough to > > > > make > > > > the > > > > form and report work right together. Any help is appreciated! Thank > > > > you! > > > > > > > > > > > > . > > > > > > > > > > > > > . > > > > > > > > > . > > > > > . >
From: Gina Whipp on 21 Feb 2010 10:28 Cheryl, You're welcome! -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message news:4FE96F91-7DBB-442C-B51F-AE9229C1B75A(a)microsoft.com... Exactly what I needed! Thank you so much, it is perfect now! :) "Gina Whipp" wrote: > Cheryl, > > Try this... > > 1. Delete Label9 > 2. Put a Text Box in it's place > 3. In the Control Source of the Text Box place... > > =IIf(IsNull([Wedding Anniversary]),"","Wedding Anniversary") > > 4. Set the Text for Enabled = No, Locked = Yes and Tab Stop = No > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message > news:AAA42738-DF9F-4F94-8C95-787D1B90B03A(a)microsoft.com... > In the Field List it is called Wedding Anniversary. When looking at the > properties of the label it says Label9. > > Thank you so much! > > > "Gina Whipp" wrote: > > > Cheryl, > > > > Yes it does and you can't use a label to do that without VBA BUT you can > > use > > a text box. What is the name of the field that has the Wedding > > Anniversary > > date in in it and I will type instructions for you. > > > > -- > > Gina Whipp > > 2010 Microsoft MVP (Access) > > > > "I feel I have been denied critical, need to know, information!" - > > Tremors > > II > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message > > news:CD385E0E-A091-4B26-904E-5CFE4E386D4C(a)microsoft.com... > > That would be great! :) > > > > When I insert a field into the report (which is how I plan to print the > > directory), how can I tell it to not label the field in the print if > > there > > is > > no entry in the field? For instance, if I insert the Wedding > > Anniversary > > field, I would like it only to print "Wedding Anniversary" if there is a > > date > > in that field, otherwise I would like it to just be blank. Hope this > > makes > > sense! > > > > Thank you for the help! > > Cheryl > > > > "Gina Whipp" wrote: > > > > > Cheryl, > > > > > > Sorry I couldn't find one closer but perhaps if you tell us where you > > > got > > > stuck we can get you unstuck. > > > > > > -- > > > Gina Whipp > > > 2010 Microsoft MVP (Access) > > > > > > "I feel I have been denied critical, need to know, information!" - > > > Tremors > > > II > > > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > > > "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message > > > news:53E65200-9337-4587-89D7-3132C8B4FA4B(a)microsoft.com... > > > Thank you. The Contact Management Database is the one that I started > > > with > > > originally, but it is not working out well for what I am trying to do. > > > I > > > probably am just not knowledgeable enough to use this program...was > > > just > > > hoping there might be a template out there that might be more of what > > > I > > > am > > > looking for. Thanks again. > > > > > > "Gina Whipp" wrote: > > > > > > > Cheryl, > > > > > > > > Sorry your initial response was a request for monies. That is not > > > > the > > > > purpose of this newsgroup. > > > > > > > > It sounds like you are looking for more of a member database??? > > > > Below > > > > are > > > > a > > > > few FREE templates available from Microsoft that might get you > > > > started... > > > > > > > > http://office.microsoft.com/en-us/templates/TC012253431033.aspx?CategoryID=CT101428241033 > > > > > > > > http://office.microsoft.com/en-us/templates/TC012253451033.aspx?CategoryID=CT101428241033 > > > > > > > > http://office.microsoft.com/en-us/templates/TC300076981033.aspx?CategoryID=CT101428241033 > > > > > > > > Here's the complete list... > > > > http://office.microsoft.com/en-us/templates/CT101428241033.aspx > > > > > > > > -- > > > > Gina Whipp > > > > 2010 Microsoft MVP (Access) > > > > > > > > "I feel I have been denied critical, need to know, information!" - > > > > Tremors > > > > II > > > > > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > > > > > "Cheryl" <Cheryl(a)discussions.microsoft.com> wrote in message > > > > news:EF3DA7B4-53DF-478F-B508-9DEDDF445430(a)microsoft.com... > > > > I am looking for an Access 2007 Photo Directory template. I am > > > > trying > > > > to > > > > make a members database that will print a photo directory for our > > > > church, > > > > but > > > > I am having a hard time because I don't know Access well enough to > > > > make > > > > the > > > > form and report work right together. Any help is appreciated! > > > > Thank > > > > you! > > > > > > > > > > > > . > > > > > > > > > > > > > . > > > > > > > > > . > > > > > . >
From: djtentman on 6 Mar 2010 10:11 Hi Cheryl, I would be interested if you could post the template that you made. I am making something similar. Also, there's another problem that I ran into: Can I add additional lines for children only if there are children? Thanks in advance.
First
|
Prev
|
Pages: 1 2 3 Prev: DCount with one single condition works, but several ones, joined t Next: Storig data from website to database |