Re: IF Statements... Where to Begin?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 10:53:15 +0800

Assuming Access 2000 or later, conditional formatting would be the easiest
approach.

Open the report in design view.
Add a text box the size of the detail section, and Send To Back (Format
menu).
Choose Conditional Formatting on the Format menu, and set it to:
    Expression Is... [SomeDateTimeField] < Now()
or some such expression that meets the condition you have in mind. 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Brett Patterson" <BrettPatterson@discussions.microsoft.com> wrote in 
message
news:3D7D02EE-5E05-43E4-83C8-62539B8B8DFE@microsoft.com...
> Hello all.
>
> I am currently working on a project and am stuck.  I know how to do it in
> Excel, but now wish to do it in access, and there's trouble.
>
> I want to continually (once per day at XX:XX time) check our records for
> those that match certain criteria, those being that the date is older than 
> 14
> days AND that a field value is "Awaiting Pickup".  Now, in Excel I can 
> turn
> the row red, make it stand out.  I wish to do the same in Access on 
> Reports,
> and print notices.
>
> I don't know the best way of attacking this, but IF() statements seem to 
> be
> it.  So here's my questions:
>
>  What's the best way to attack this?  IF() statements, Switch() 
> statements,
> Macros what?
>  Where would I code such functions?
>  Is it possible to create one function to check for criteria, generate a
> report, print notices, and print the report?
>
> Thanks for the help.  I know it's not good to post multiple questions in 
> the
> same post, but they're all along the same line.
>
> ~Brett Patterson

Relevant Pages

  • Re: Printing labels with subtotals - fixing size
    ... I modified the report using ... Normally, when printing labels such as this, you would go across then down, ... > Have discovered conditional formatting - thank you - and got it to work. ... I can see that I would have to do something more> complicated than conditional formatting to get all those text boxes to> return white formatting when the condition was met. ...
    (microsoft.public.access.reports)
  • Re: Conditional format disaster in 2007
    ... also filed a bug report to MS later the same day. ... If the place you copy the cells to already has conditional formatting, ... If you repeat the pasting of those ...
    (microsoft.public.excel.programming)
  • Re: Conditional Formatting with more then 3 conditions
    ... the report section that contains the name text ... [Event Procedure] ... query that I'd like to embed as a sub rpt in the rpt header. ... except for the conditional formatting limitation. ...
    (microsoft.public.access.reports)
  • Re: referencing subreport items
    ... report should work okay. ... use the Conditional Formatting option in the subreport. ... it runs to format the subreport. ...
    (microsoft.public.access.reports)
  • Re: IF Statements... Where to Begin?
    ... Presumably you only want to open the report if there is something to ... thanks for the help with the formatting. ... >> Assuming Access 2000 or later, conditional formatting would be the ... >>> report, print notices, and print the report? ...
    (microsoft.public.access.modulesdaovba)