If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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] |
#12
|
|||
|
|||
Form_Date does not work
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] |
|
Thread Tools | |
Display Modes | |
|
|