Form_Date does not work

John,

The reference to a month and year is the only thing that ties many of my
tables together, I think. I'll try to use the IncDate as the Master/Child
link fields for my Cash and InKind Donations and see if that will work.

Did as instructed with the u/c txt box; just got 8/1/07

Format: Medium Date
Control Source =Forms!frmDates!txtStart

Until I hear from you again, I'll keep working. Incidently do you know
anything about calculating an ending balance in a main report with two sub
reports? I hope so,

God bless you.

k

"John W. Vinson" wrote:

On Tue, 4 Sep 2007 19:24:01 -0700, znibk
wrote:

John,

I corrected the unbound text boxes. I had the control sources as txtStart;
txtEnd, not the Name field.

I corrected that, entered my dates, left the form open, made sure the filter
was entered to frmDates and yes it was on. I opened the Query Builder, redid
Parameters. Kept getting bracketing error. I have no idea what happened
except a miracle as I just closed, looked, ran, and there it was (God has
pitty on me so many times)

It's often going to work right when you get all the errors fixed... g

Question, I would like to have the date, formated in the report header to
medium date, how do I do that?

Put a textbox in the report header. Set its Format property to

Medium Date

and its Control Source to

=Forms!frmRefDate!txtStart

Question, I would like to have frm_RefDate where I choose a month and year.
I tried the same rules as the frmdates, but sometimes I get more than one
month or a mixture. I'm still working.

A month and a year IS NOT A DATE. A Date/Time value in Access is a precise
point in time (accurate to a few microseconds); if it is just a date, then
it's midnight on that date. If you need to store non-specific date data then
you may want to have two or three fields - the year, month, and perhaps day.
Don't use the reserved fieldnames Year, Month, or Day though. Your queries
will be more complex because you'll be matching an imprecise date with an
imprecise criterion.

John W. Vinson [MVP]

John,

I have a table which has the month and year as that is the only common link
I could find for my information. the table consists, currently, of 12 months
Oct 2006, Nov 2006 . . . Sep 2007. You asked for the query SQL view of it.
Here it is:

SELECT tblMONTHYEAR.MONTH_YEAR, tblMONTHYEAR.MonthYear
FROM tblMONTHYEAR;

The frm_RefDate I created, has an unbound text box, which is blank. However,
I clicked on the properties of the unbound ext box and on Row Source Type:
table/query, I clicked on the three dots beside it . . . (I think it is
called query builder. On Row source, I have:
SELECT tblMONTHYEAR.MONTH_YEAR, tblMONTHYEAR.MonthYear FROM tblMONTHYEAR

I just put the label name as Reference Month.

I am, however, concerned about using this as you made the staement earlier
that it is not a Date/Time as in Access that is a very specific time period.

I chose the MonthYear for the table. In each of the other tables, I have the
field named [RefDate]

As I said earlier, when I group my information by the MonthYear, it seems to
total them in a SumQuery whereas it does not when I use a date/time field.
Perhaps because I have and IncomeDate [IncDate]; for the expenses, the check
date, [ACkDate] for bank A; for bank l, I have [LCkDate]. I was not making
any progress in linking anything so I thought, what is common in all of them,
the month and year of whatever it is. Now you tell me month year and date are
specific to Access and I need to change those names.

After reviewing the information above, please tell me if I need to and
please suggest a better field name.

Christ's blessings,
k




"John W. Vinson" wrote:

On Tue, 4 Sep 2007 19:30:01 -0700, znibk
wrote:


I forgot to tell you that on the frm_RefDate, I forced the Query Builder on
the Row Source and chose the table MonthYear as I want the person entering
the reference month to be able to use the name not the ID#

I'm sorry, I have NO idea what you mean by this.

Could you post the SQL view of the RowSource of your query? and perhaps a
description of the structure of your MonthYear table? Also describe what you
mean by "the reference month" - that's not a term I know.

John W. Vinson [MVP]