Datagrids documentation

[Eddi Rae]

Is there any documentation on how to use the MS Datagrid in Access 2003?
I have never used this here and would like to know more about this.

Thanks!!

 

[Wayne-I-M]

Hi Eddi

You may fine more information in this foru
http://www.access-programmers.co.uk/forums/forumdisplay.php?s=5e9c4786d49dcb59982b7bfb22500945&f=73

Good luck

 

[Albert D. Kallal]

I would suggest that you use the "built-in" display abilities, as they are
easier to use and also don't requite installs....

I give some examples here...

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

 

[Eddi Rae]

That is interesting. My situation is that I am already using continous
forms. What I need to have accomplished is that if my date on a record is
less than the current date, then I need that record to have the background of
the entire row changed and the record cannot be edited.

I am looking into the conditional formatting, but this may not be enough.

Could you help me find examples of what I am wanting?

Thanks!!

 

[Rob Parker]

Hi Eddi,

You can do what you want with a combination of conditional formatting and a
little VBA code.

Use conditional formatting to set the background colour for the row (each
cell in the row). In addition to that, use code similar to this, in the
form's Current event, to prevent edits (change fieldname to real one if it's
not RecordDate):
Me.AllowEdits = (Me.RecordDate = Date)

If you want to allow editing if the RecordDate field is null, use:
Me.AllowEdits = (nz(Me.RecordDate,Date) = Date)

And finally, if your RecordDate field contains a time component as well as a
date component, use:
Me.AllowEdits = (DateValue(Me!DateTimeAdded) = Date)
or
Me.AllowEdits = (DateValue(Nz(Me!RecordDate, Date)) = Date)

HTH,

Rob