Any Access 2007 Guru's Help Needed

[jpskiller]

I am trying to put a conditional format on Outstanding to change colour if overdue

tried following expressions:

[Invoicedate]+31 < date() AND [Outstanding] > 0
([Invoicedate]+31 < date()) AND ([Outstanding] > 0)

dosent work but if do them seperate ie :

[Invoicedate]+31 < date() - this highlights ok
[Outstanding] > 0 - this highlights ok

just cant get the 2 combined to work

any ideas please

 

[davidjpowell]

Hi - Can I piggyback please

I have a database which is used for Property Management. I use a netbook and enter data live on an inspection. I would then like to be able to press a button on the form, to email a report, based on that record only.

At the moment I have a button, This prodcues a printout of what I need, in the right format. Is there a way to get it to email instead?

Button code is:

DoCmd.OpenReport "InspectionMaster", acViewNormal, , "[InspectID] = " & Me![InspectID], acWindowNormal


Cheers

David

 

[Rayny]

JPSKiller,

I don't have Access loaded at the moment.
Excel does not allow multiple conditional formatting,
but in Access you may be able to use

IF [Invoicedate]+31 < date() AND [Outstanding] > 0

If the above does not work and you get no other replies I will try to find, and load, Accees97 over the weekend.

 

[Noodle-Pulp]

Hi - Can I piggyback please

I have a database which is used for Property Management. I use a netbook and enter data live on an inspection. I would then like to be able to press a button on the form, to email a report, based on that record only.

At the moment I have a button, This prodcues a printout of what I need, in the right format. Is there a way to get it to email instead?

Button code is:

DoCmd.OpenReport "InspectionMaster", acViewNormal, , "[InspectID] = " & Me![InspectID], acWindowNormal


Cheers

David

You could try this:
SendObject report with a filter in Access Reports