Access Template "Accounts Ledger database"

  • Thread starter Thread starter Solly
  • Start date Start date
S

Solly

in Access template "Accounts Ledger database", if you go to report "Filter
Options", the "Bigining Date" format entery is MM/DD/YY while the Ending Date
format entry is DD/MM/YY.

how to change both to DD/MM/YY
 
Hi Solly,

You must have a different version of this template than I have, because both
of the dates on the form named "View Reports" are unformatted on my copy. I
downloaded my copy some time ago (Sep. 27, 2005 to be exact), so it's
entirely possible that you have a different copy. In any case, try entering a
format for each text box as: dd/mm/yy (although I recommend using 4-digit
years).


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
hi Tom
yes; the date are unformatted on the "view report" the bigging date need to
be input in mm/dd/yy and the end date does not matter. you need to create a
report with date to see that is you do not enter the begging date in mm/dd/yy
filter will not work.

i have tried to force date format in properties but did not work.
 
Hi Solly,

Are you talking about the text box named "Rpt Date Range", found in the
Account Summary report? This text box has a Control Source as follows (all on
one line--I inserted the breaks for readability in this reply):

="For Transactions Between: " &
Forms![View Reports]![Beginning Trans Date] &
" and " & Forms![View Reports]![Ending Trans Date]

If so, try the following modification to this Control Source (again, all on
one line):

="For Transactions Between: " &
Format(Forms![View Reports]![Beginning Trans Date],"dd/mm/yy") &
" and " & Format(Forms![View Reports]![Ending Trans Date],"dd/mm/yy")


Note:
"bigging" / "begging" should be spelled "beginning".


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
thanks again Tom
tried your suggestion but still did not work. i,ll send you email with the
data base attached to see for your self
--
Solly


Tom Wickerath said:
Hi Solly,

Are you talking about the text box named "Rpt Date Range", found in the
Account Summary report? This text box has a Control Source as follows (all on
one line--I inserted the breaks for readability in this reply):

="For Transactions Between: " &
Forms![View Reports]![Beginning Trans Date] &
" and " & Forms![View Reports]![Ending Trans Date]

If so, try the following modification to this Control Source (again, all on
one line):

="For Transactions Between: " &
Format(Forms![View Reports]![Beginning Trans Date],"dd/mm/yy") &
" and " & Format(Forms![View Reports]![Ending Trans Date],"dd/mm/yy")


Note:
"bigging" / "begging" should be spelled "beginning".


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

Solly said:
hi Tom
yes; the date are unformatted on the "view report" the bigging date need to
be input in mm/dd/yy and the end date does not matter. you need to create a
report with date to see that is you do not enter the begging date in mm/dd/yy
filter will not work.

i have tried to force date format in properties but did not work.
Click to expand...
Click to expand...
 
Hi Solly,

I received your database and we exchanged a few replies, however, I have not
heard back from you after my last reply made on Sep. 16th. I think I found a
solution for you and I requested your confirmation, but that's when you
seemed to stop replying for whatever reason.

In the interest of helping other people who may want to use the Accounts
Ledger template, and who are not using the English (US) settings, I wanted to
share what I *believe* is a solution:

I changed the Control Source shown in a hidden text box named
"txtReportFilter", on the form named "View Reports":

From this:

=Choose([grpFilterOptions],"[TransactionDate] Between #"
& Forms![View Reports].[txtBeginningTransDate]
& "# AND #"
& Forms![View Reports].[txtEndingTransDate] & "#","")


To this:

=Choose([grpFilterOptions],"[TransactionDate] Between "
& Format([Forms]![View Reports].[txtBeginningTransDate],"\#mm\/dd\/yyyy\#")
& " AND "
& Format([Forms]![View Reports].[txtEndingTransDate],"\#mm\/dd\/yyyy\#"),"")


I had based the above modification on Access MVP Allen Browne's article here:

International Dates in Access
http://allenbrowne.com/ser-36.html

Note: I had previously renamed the two text boxes, from "Beginning Trans
Date" and "Ending Trans Date]" to "txtBeginningTransDate" and
"txtEndingTransDate", respectively. I am a proponent of using naming
conventions, and avoiding the use of special characters, including spaces, or
reserved words, in anything that I assign a name to in Access.

I also added a date format of the two unbound text boxes used to enter dates:

Format: dd/mm/yyyy

In the Account Summary report, I changed the Control Source for the text box
named: "Rpt Date Range" to this:

="For Transactions Between: " & Format([Forms]![View
Reports]![txtBeginningTransDate],"dd/mm/yyyy") & " and " &
Format([Forms]![View Reports]![txtEndingTransDate],"dd/mm/yyyy")

I also set a similar format for the text box on this report named
"Transaction Date" to: dd/mm/yyyy


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
Back
Top