Datasheet View

#1 (**permalink**) 28-Jul-2006, 08:29 AM

Wanted to know if there would be a way to pull off having a datasheet view
but right above the columns having another field that the user can select.

For example:
Date: (Row) Data ---> ( Over each of the Column Headings)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12514-datasheet-view.html
Medications Change1 Change2 Change3 (Column Heading)
Data Data Data Data
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12514
| | | |
V V V V

Does anyone know how I can pull this off in one datasheet?

Thanks for your help, Happy 4th of July!
--
Ryan W

#2 (**permalink**) 28-Jul-2006, 08:29 AM

Not in a datasheet itself. You can try putting the datasheet on a main form
and putting the selectable fields on the main form positioned above the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12514
columns of the datasheet. This will be hard to get to look right plus you
have to make sure that the datasheet columns don't resize since that would
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12514
throw everything off.

"Ryan W" wrote in message
news:2CF29636-3347-479D-874C-07784269FC34@microsoft.com...
> Wanted to know if there would be a way to pull off having a datasheet view
> but right above the columns having another field that the user can select.
>
> For example:
> Date: (Row) Data ---> ( Over each of the Column Headings)
> Medications Change1 Change2 Change3 (Column Heading)
> Data Data Data Data
> | | | |
> V V V V
>
> Does anyone know how I can pull this off in one datasheet?
>
> Thanks for your help, Happy 4th of July!
> --
> Ryan W

#3 (**permalink**) 28-Jul-2006, 08:29 AM

Besides positioning above the element, can you think of anything else that I
can do to achieve this?

Thanks, Ryan
--
Ryan W

"Pat Hartman(MVP)" wrote:

> Not in a datasheet itself. You can try putting the datasheet on a main form
> and putting the selectable fields on the main form positioned above the
> columns of the datasheet. This will be hard to get to look right plus you
> have to make sure that the datasheet columns don't resize since that would
> throw everything off.
>
> "Ryan W" wrote in message
> news:2CF29636-3347-479D-874C-07784269FC34@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12514
> > Wanted to know if there would be a way to pull off having a datasheet view
> > but right above the columns having another field that the user can select.
> >
> > For example:
> > Date: (Row) Data ---> ( Over each of the Column Headings)
> > Medications Change1 Change2 Change3 (Column Heading)
> > Data Data Data Data
> > | | | |
> > V V V V
> >
> > Does anyone know how I can pull this off in one datasheet?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12514
> >
> > Thanks for your help, Happy 4th of July!
> > --
> > Ryan W
>
>
>

#4 (**permalink**) 28-Jul-2006, 08:30 AM

If your table record was defined as

medication
Chng1 data
chng1 flag
chng2 data
chng2 flag
etc.

have the datasheet show
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12514

medication change1 chnge2 chng3

With instructions to the chng value that you want to modify
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12514

On the dbl-click event toggle the assocated change flag

On the datasheet form put in conditional formating to change the color
of any of the items that have chngn = true.

Ron