account ledger

[Guest]

Hi, i downloaded the acount ledger template from the office website, it's a
nice template, but i live in the UK, and need o change the Dollor($) sign to
the Pount(£) sign.

Template address
---------------------
http://office.microsoft.com/en-gb/templates/TC010175341033.aspx?CategoryID=CT062100761033
-----------------------

I played around with the template and tried to change it but not allot of
luck, i changed the currenty value in the transactions table, but it does not
update everything to the £ sign.

Thanks for your help in advance

Max

 

[Guest]

take i look at a response i got, this might point you in the right direction
many thanks alan

No, there's not a global option like that.

In fact, Access does NOT actually store "Currency" where you see Currency in
the Format property. It actually stores *your* currency setting (i.e. the
one from the development machine) and lies to you about what is really
there. The lie is uncovered if you then change your currency setting to
something else: You get to see the literal currency string you originally
had, instead of "Currency".

You therefore have to identify *every* affected control in your application,
and re-assign "Currency" to its Format property in the Open event of every
form and report.

More info:
Currency format does not respect regional settings
at:
http://allenbrowne.com/ser-44.html

 

[Guest]

Hi Max,

Open the Transactions table in design view. Make the following changes to
the format of the two currency fields: WithdrawalAmount and DepositAmount:

From:
$#,##0.00;($#,##0.00)

To:
£#,##0.00;(£#,##0.00)

Open the various forms and reports in design view. Make similar changes to
the format property for each control, as required, changing the set format
from Currency to £#,##0.00;(£#,##0.00).


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hi, i downloaded the acount ledger template from the office website, it's a
nice template, but i live in the UK, and need o change the Dollor($) sign to
the Pount(£) sign.

Template address
---------------------
http://office.microsoft.com/en-gb/templates/TC010175341033.aspx?CategoryID=CT062100761033
-----------------------

I played around with the template and tried to change it but not allot of
luck, i changed the currenty value in the transactions table, but it does not
update everything to the £ sign.

Thanks for your help in advance

Max

 

[Guest]

Hi TOM

Thanks for you help, it sorted out my problem. Your advice was SPOT ON

 

[Guest]

Hi Tom

I came accross another litle problem and hoped you could give me some help,
when i run the reports for the ledger it does not show the Balance, it only
give me totals of deposit and withdrawel amounts.

I checked out the balance code of the reports in design view and it looks
like:
=Sum([DepositAmount]-[WithdrawalAmount])

But when i run the reports it does not show up.

Thanks for your help in advance
Max

 

[Guest]

Hi Max,

I'm glad I could help. I also learned something new by reading the link that
StuJol provided to Allen Browne's article. While I've read many of Allen's
articles, I hadn't seen that one yet. Thanks StuJol.

I checked out the balance code of the reports in design view and it looks
like:
=Sum([DepositAmount]-[WithdrawalAmount])

But when i run the reports it does not show up.

That's because whoever designed this template wasn't thinking about the
possibility of nulls, and every record includes a null in either the
DepositAmount or the WithdrawalAmount. A null (insert mathematical operation
here: +, -, *, /, etc.) added, subtracted, multiplied, divided, etc. by a
number is still null. Luckily, Access provides us with the built-in Nz
function, which allows us to convert nulls to just about anything we want.
The general usage is:

=Nz([FieldName], ValueIfNull)

where ValueIfNull is the value that we want displayed if [FieldName] is
null. You can use numeric values, such as 0 (zero), or text strings such as
"None" or "N/A". To fix the reports, you need to incorporate the Nz function
into the control source for the Balance textboxes.

Open the Account Summary report in design view. Change the control source
for the Balance textbox to:
=Nz([DepositAmount],0)-Nz([WithdrawalAmount],0)

Change the control source for the Balance Grand Total Sum textbox to:
=Sum(Nz([DepositAmount],0)-Nz([WithdrawalAmount],0))


Make similar changes to the remaining two reports.

Happy New Year!

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hi Tom

I came accross another litle problem and hoped you could give me some help,
when i run the reports for the ledger it does not show the Balance, it only
give me totals of deposit and withdrawel amounts.

I checked out the balance code of the reports in design view and it looks
like:
=Sum([DepositAmount]-[WithdrawalAmount])

But when i run the reports it does not show up.

Thanks for your help in advance
Max

__________________________________________

:

Hi TOM

Thanks for you help, it sorted out my problem. Your advice was SPOT ON

 

[Guest]

Happy new year to you too, and thanks again for your help, i felt like
scratching my pc screen from frustration, and without your help i might have
just done so.

If only i could vote for you more than one's i would, lol

If you have your own website, i would be happy to link to you. Just email
your details to (e-mail address removed) and i'll give you a link at
www.zacsdesign.com

YOUR THE BEST

Max

Hi Max,

I'm glad I could help. I also learned something new by reading the link that
StuJol provided to Allen Browne's article. While I've read many of Allen's
articles, I hadn't seen that one yet. Thanks StuJol.

I checked out the balance code of the reports in design view and it looks
like:
=Sum([DepositAmount]-[WithdrawalAmount])

But when i run the reports it does not show up.

That's because whoever designed this template wasn't thinking about the
possibility of nulls, and every record includes a null in either the
DepositAmount or the WithdrawalAmount. A null (insert mathematical operation
here: +, -, *, /, etc.) added, subtracted, multiplied, divided, etc. by a
number is still null. Luckily, Access provides us with the built-in Nz
function, which allows us to convert nulls to just about anything we want.
The general usage is:

=Nz([FieldName], ValueIfNull)

where ValueIfNull is the value that we want displayed if [FieldName] is
null. You can use numeric values, such as 0 (zero), or text strings such as
"None" or "N/A". To fix the reports, you need to incorporate the Nz function
into the control source for the Balance textboxes.

Open the Account Summary report in design view. Change the control source
for the Balance textbox to:
=Nz([DepositAmount],0)-Nz([WithdrawalAmount],0)

Change the control source for the Balance Grand Total Sum textbox to:
=Sum(Nz([DepositAmount],0)-Nz([WithdrawalAmount],0))


Make similar changes to the remaining two reports.

Happy New Year!

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hi Tom

I came accross another litle problem and hoped you could give me some help,
when i run the reports for the ledger it does not show the Balance, it only
give me totals of deposit and withdrawel amounts.

I checked out the balance code of the reports in design view and it looks
like:
=Sum([DepositAmount]-[WithdrawalAmount])

But when i run the reports it does not show up.

Thanks for your help in advance
Max

__________________________________________

:

Hi TOM

Thanks for you help, it sorted out my problem. Your advice was SPOT ON