K
Kim
I'm working on a Form, and am using Access97.
I have a little knowledge of SQL and some VERY BASIC vb
skills.
I have an idea as to what I want and don't know how to
explain it. So I will try by showing an example of a bad
layout. Please
don't question the lack of logic here, it's only to hopefully
get across
what I WOULD like to do.
I have a textbox that grabs the Month & year from a query
that grabs it's
information from two tables.
eg: SELECT (Format(tblMonths.month,"mmmm"+" ")) &
(Format(tblYear.year,"yyyy")) AS monthYear, .......
FROM blah, blah, blah.......
and several other textboxes that have the =Day() value to
show the week.
eg. of setup:
bound textbox:
|monthYear|
unbound textboxes:
|=Day(1)| |=Day(7)| |=Day(8)| |=Day(14)|, etc.....
Eg. of result:
March 2004
31-6 7-13 14-20, etc.....
Obviously, this only grabs the days for the present month.
Now, what I would like to achieve IF it is possible, is to have
it set up to show the actual days of the actual month and
Year from Sunday to
Saturday. In other words:
March 2004
1 - 6 , 7 - 13 , 14 - 20 , 21 - 27, 28 - 31.
but I would also like to take it one step further, by having
the days show up as the corresponding month and year that
are in the [monthYear] textbox.
In case you need to know, I have full dates in the month
and year tables.
One is formatted to show only the month and one is
formatted to show only the year eg:
Month: Year:
Actual | formatted Actual | formatted
-------|---------- -------|----------
1/1/00 | January 1/1/04 | 2004
2/1/00 | February 1/1/05 | 2005
3/1/00 | March 1/1/06 | 2006
all the way to December. all the way to 2025.
Am I over my head? Should I rethink my layout? Can anyone
help me?
Please reply, even if it is to tell me that this can not be
achieved or understood, or if I've posted in the wrong
Newsgroup.
Thanks in advance for all your efforts.
I have a little knowledge of SQL and some VERY BASIC vb
skills.
I have an idea as to what I want and don't know how to
explain it. So I will try by showing an example of a bad
layout. Please
don't question the lack of logic here, it's only to hopefully
get across
what I WOULD like to do.
I have a textbox that grabs the Month & year from a query
that grabs it's
information from two tables.
eg: SELECT (Format(tblMonths.month,"mmmm"+" ")) &
(Format(tblYear.year,"yyyy")) AS monthYear, .......
FROM blah, blah, blah.......
and several other textboxes that have the =Day() value to
show the week.
eg. of setup:
bound textbox:
|monthYear|
unbound textboxes:
|=Day(1)| |=Day(7)| |=Day(8)| |=Day(14)|, etc.....
Eg. of result:
March 2004
31-6 7-13 14-20, etc.....
Obviously, this only grabs the days for the present month.
Now, what I would like to achieve IF it is possible, is to have
it set up to show the actual days of the actual month and
Year from Sunday to
Saturday. In other words:
March 2004
1 - 6 , 7 - 13 , 14 - 20 , 21 - 27, 28 - 31.
but I would also like to take it one step further, by having
the days show up as the corresponding month and year that
are in the [monthYear] textbox.
In case you need to know, I have full dates in the month
and year tables.
One is formatted to show only the month and one is
formatted to show only the year eg:
Month: Year:
Actual | formatted Actual | formatted
-------|---------- -------|----------
1/1/00 | January 1/1/04 | 2004
2/1/00 | February 1/1/05 | 2005
3/1/00 | March 1/1/06 | 2006
all the way to December. all the way to 2025.
Am I over my head? Should I rethink my layout? Can anyone
help me?
Please reply, even if it is to tell me that this can not be
achieved or understood, or if I've posted in the wrong
Newsgroup.
Thanks in advance for all your efforts.