Currency Control Won't Show Dollars

Oct 17, 2005

I have a form with various controls that reflect dollar amounts.

One of those controls, despite deleting and replacing it, despite deleting the field whose value it displays, despite changing it to 'general number', saving, then changing back, despite comparing its properties with that of numerous normal-behaving controls, refuses to show a dollar sign, nor zero cents values. I've compressed and repaired in between deleting fields and controls, too, to no avail.

Otherwise it is working correctly in that calculations based on it work fine and it shows the number of dollars it's supposed to. Just no dollar sign and refuses to show zero cents...

Can anyone suggest to me what's up with this thing?

View Replies


ADVERTISEMENT

Forms :: Currency Rounding For Retail Dollars

Dec 14, 2013

I need to create a SIMPLE solution for Retail rounding. Below are is an Example of Detail lines in a DataSheet Form that represents the price for an Item.

QuantityXUnitRate = Quantity * (UnitRate*Pct)
$14.0049 = 1 * $10.53 * 1.33
$14.0049 = 1 * $10.53 * 1.33

I need the price to end with a Currency Decimal of $$$$$.x9 for all prices. The example above rounds to $14.00 for with 2 digit rounding or if I use 3 digit rounding $14.01.

I need it to be rounded with a .x9 either $13.99 or $14.09 or to the nearest .x9.

Subsequently, every Detail line we calculate in the Datasheet needs to end with an .x9 for Retail Pricing.

There are thousands of different UnitRates (costs), and the Pct (Percent of Markup) can also change.

Additionally, I sum the Detail Lines and the Totals need to match. One of the Sum Fields is Calculated as

=Sum(IIf([taxable]=True,Nz([QuantityXUnitRate]),0))

This ends up Totaling to $28.01 which is wrong for 3 Digit rounding of the Detail Line, because $14.01+ $14.01 = $28.02.

I also tried Rounding

=Sum(IIf([Taxable]=False,Nz(Round([QuantityXUnitRate]),0),0))

And after that I still got the wrong amount $28.00.

I tried this with 2 instead of 0 with no difference

=Sum(IIf([Taxable]=False,Nz(Round([QuantityXUnitRate]),2),2)),

I know one of 2 refers to the Nz and the other to Rounding, but I not sure which is which at this point.

If the last significant digit need to be .09 or .19 or .29 or .39 or .49 or.59 or.69 or.79 or.89 or.99 then everything should Sum up correctly or I hope.

Here is another Example
QuantityXUnitRate = Quantity * (UnitRate*Pct)
$14.0049 = 1 * $10.53 * 1.33
$22.2642 = 1 * $16.74 * 1.33

However, I get the correct Detail Line of $14.01 and $22.26
and using =Sum(IIf([taxable]=False,Nz([QuantityXUnitRate]),0)) same as above, I get the correct amount $36.27.

How to make a with a SIMPLE solution where all Decimals end up with a .x9 and then I'll tackle the Sum if necessary.

View 14 Replies View Related

General :: Desktop Services Template Changing Currency To Pounds From Dollars

Nov 13, 2013

How would I go about doing this?

View 6 Replies View Related

How Do I Show A Currency In A Query.

May 12, 2006

A friend has developed a database at college. All seems pretty well but the query she uses to populate a form and reports is incorrectly displaying the curence. Her main tables are just number fields. The query calculates correctly but her lecturer has told her the query needs to show a £ sign with the figures retrieved. Any ideas?

View 2 Replies View Related

Forms :: Unbound Calculated Field - Show Results As Currency

Oct 16, 2014

I have an unbound calculated field [Txt1] that I would like to show the result as currency. The fields in the calculation are:

[CR] number, currency
[Commission1] general number, two decimal places
[Commission2] general number, two decimal places

The calculation is: CR15W * (1 - Commission1) * (1 - Commission2)
If I just set the field to currency it works fine. But I want the field to show the following:
"Some Text" & " " & Format(Calculation, "Currency")

When I tried to include the format it to currency I get type mismatch, run time error 13.

So I thought that perhaps I should try the following just to see where my error starts and I get the same error message when I use:

Dim Val1 As String
Val1 = CR15W * (1 - Commission1) * (1 - Commission2)
Txt1 = Format(Val1, "Currency")

Everything I have read says the formula is:

Format([Calculation], "Currency")

Is correct. So why won't it work for me?

View 8 Replies View Related

New Field Does Not Show In Control Source For Form Control

May 28, 2015

I have table that I had to add a new field to which we update with a form. I tried to add a control for the new field but the field does not show up in the list for the control source. I am trying to add a list box to the form with a blank and 5 options.

I have attached screen shots of the table design and the form. The table has the field in datasheet view and I have manually entered a few entries in it but it still will not show in the control source for the form control. The top section of the form is where we enter and select the data for the new records. The bottom section (circled in red) autofills the matching record, from separate tables, for updating with the new entries.

I have added form controls for modified fields in the past so I am confused about why this is happening.

View 2 Replies View Related

Tables :: How To Change Default Currency In Access 2013 To A Foreign Currency

Dec 20, 2012

how to change default currency in Access 2013 to a "foreign currency" (i.e. to Indonesia Rupiahs) without changing control panel (Region/Language>currency) - now setup as USA ($US)?

View 3 Replies View Related

Summing By Name With Dollars Amounts

Jan 10, 2005

Heelo all:

I have a form based on a query. This form has a combobox with 4 names in it. When a person is selected form the combo box, other fields automatically populate IE: room number, address, etc. Another field is a currency box which also populates automatically.

This is what I wish to happen: When I select a person from the combo box, can it show the TOTAL amount received for THAT PERSON in a separate text box?

Any help is most welcome.

Regrds,

Dee

View 7 Replies View Related

Show/not Show Control

Mar 14, 2006

how can i control a field to show/not show at the query level?
let's say i have a query (from a table) like this

[regularPrice] [isOnSale] [onSalePrice]

where [isOnSale] is checkbox. if it's checked, [onSalePrice] will show [price]*0.9; if it's not checked, [onSalePrice] show nothing.

i've tried to put "[isOnSale]=Yes" in the Criteria, the query will filter out only those records that's on sale, which i don't want...

please help :confused:

View 2 Replies View Related

Forms :: Using Web Browser Control To Show PDF

Apr 2, 2013

I'm trying to use the Access 2010 web browser control to dynamically show a PDF.

The base file path is a constant (R:MS_ACCESS_PROJECTSSAFETYIMAGESMSDS SHEETS)

and the dynamic part is two fields from the selected record:

me.txtMsdsID & "." & me.txtVersion

what is the simplest way to "bind" this so that when a record changes it automatically refreshes this control? I've tried setting it with VBA, but it's not working consistently.

I know the issues isn't the file path, as it works fine if I paste it in windows explorer.

View 1 Replies View Related

How To Get Header Of A List Box Show Value Of Another Control

Aug 23, 2013

Is it possible to have the header of a list box show the value of another control?

View 2 Replies View Related

Making Control Boxes Show 0 If No Records

Aug 17, 2006

I have a form where the records are propulated by ane xpression, which checks and sums database values.

Sometimes, the control boxes are empty as there is no data to sum for a particular record. Is there a way to get the control box to show the value 0 ?

I've tried default's, etc. but that doesn't seem to work...probably because the expression returns a NULL value.

I know it can be done using IIf but that will complicate the formulas even further.
Is there perhaps a way to do it using code instead ?

View 1 Replies View Related

Tab Control Is Set To Transparent But Background Doesn't Show Through

Aug 31, 2006

I have some tab controls, which for some reason show up white.
I have set their back style to transparent but it doesn't seem to show the grey Windows colour of the background form.
Any ideas why ?

AT the moment I'm having to put grey rectangles in various places to cover this up, which is obviously not ideal.

View 4 Replies View Related

Forms :: Show Image Based On Another Control Value?

Nov 5, 2014

I have a text box [txtTrafficValue] that is a calculated field of two short times. I want an image to be visible if the value is >= 0.0104 (15 minutes). I have in the after update of the field:

if me.txtTrafficValue >= 0.0104 Then
Me.imgWarning.visible = true
Else
Me.imgWarning.visible = false
End if

but when the field does the calculation and updates the image is not appearing.

View 5 Replies View Related

Modifying Control To Show Print Dialog?

Jul 21, 2015

My 'print' icon prints whatever is on the page as soon as it is clicked.

I'd like it to show the print dialog detailing which page / how many copies / which printer and so on.

how to do this?

I tried to customize the toolbar by adding the print icon from the File toolbar , but this is the same 'straight-to-print' as I already have.

View 3 Replies View Related

How To Format A Control In An ACCESS Form To Show Zeros

May 28, 2007

Hello,

I have a text box in an ACCESS form that is blank. How should I format it so that zeros are visible until a digit is entered into that field? This column is for ovetime figures (e.g. 1.35 hours) that will be entered later.

I would greatly appreciate any suggestions and help.

Regards,
Ligaya

View 2 Replies View Related

Modules & VBA :: Control Tip To Show Related Record From Another Table

May 18, 2015

Is it possible to have the control tip show related records from another table?

I've been looking around the internet, and I've seen many examples for showing concatenated fields on current record, but had no luck with what I'm trying to do.

For example.

I have a continuous form, and on it shows top line data. Where a record in this form shows as "Split" it means I have more data related to this record on another table.

Is it possible to show however many fields are related to this record, when I control tip, or mouseover?

I've been playing with

Code:
Me.textbox.ControlTipText = Me.textbox

but was wondering, if this is possible, how I'd reference the other table,

If said column of continuous form is "split"...
lookup related table by ID number
show however many columns of data..

View 2 Replies View Related

Reports :: How To Show Picture On Report If Control Is True

May 28, 2014

I have a report called "orders" and on this is records for orders of the day inputted.

On this report I have a control called "urgent" and a picture called "UrgentPicture" with the picture set to visible.false?

If any of the controls for Urgent is True then this will show my image, but this is not happening?

I am using this in the current event on the report

If Me.Urgent = True Then
Me.UrgentPicture.Visible = True
Else
Me.UrgentPicture.Visible = False
End If

View 3 Replies View Related

Forms :: Form Control With Iif Statement To Show Specific Records?

Jul 13, 2015

I have a form based on a query in datasheet view. What i would like is to show only those records that fulfill the truepart of iif statment, and do not show the ones that fulfill the false part.

I have the following fileds in the query

month
currency 1 checkbox
currency 2 checkbox
sum

In the form, the control named month contains the following code:

control source: =IIf([checkbox1]=no;[month];0)

So this gives the appropriate months, but also shows the all other records with a 0 in the month field. I would like to get only the records shown that are correct with the truepart of the statement.

View 6 Replies View Related

Forms :: Cascading Combo Boxes Don't Show Control Source Value Until Requery

Dec 31, 2013

I have a set of cascading combo boxes. When a value is selected in Cat 1 ID, it narrows down the selections in Cat 2 ID which narrows down the selections in Cat 3 ID.

However, the values don't show up for columns Cat 2 ID or Cat 3 ID until I enter the row. Then I have it set to requery the fields because the underlying data isn't populated. But then when I leave the row, the values go away.

Why doesn't it show the underlying value from the table? Each column is bound to a field in a table - I would assume that the recorded value would show up. Did I miss something easy?

I've attached a picture of exactly what I mean.

View 2 Replies View Related

Forms :: Requerying Subreport On Tabbed Control - Show Related Data

Jul 4, 2014

I have a form with a tabbed control on it. The tabbed control has 4 tabs that each have a report on them. When I select a company name on the main form, I requery these 4 reports to show data related to that company.

For some strange reason, 2 of my reports requery with no problem, and 2 of them give me a message that the report can't be found. Here is the code:

Code:
Private Sub cboCompanyName_AfterUpdate()
On Error GoTo cboCompanyName_AfterUpdate_Err
' DoCmd.SearchForRecord , "", acFirst, "[CompanyID] = " & str(Nz(Screen.ActiveControl, 0))

' After selecting a company, requery the subreports to display the appropriate data

' These 2 work

Forms!frmCompanyHistory!RptCompany_Projects_Brief.Requery
Forms!frmCompanyHistory!RptEmployeesSpecificCompany.Requery
'These 2 Fail
Forms!frmCompanyHistory!SubRptCompany_Payback.Requery
Forms!frmCompanyHistory!SubRptCompany_Revenue.Requery

'Other things I've tried

'Forms!frmCompanyHistory!TabCtl66!SubRptCompany_Payback.Requery
'Me.TabCtl66!SubRptCompany_Revenue.Requery

As a side note, if I chose the company, say "ok" to the error, and then go run the queries that these reports are based on, I get the correct records. Also, if I chose the company and run the 2 failing reports standalone, they work fine, so I know the problem isn't the reports or the queries themselves.

I have also checked and rechecked for any spelling mistakes and have found none. I should mention that the error message is "Programs cannot find the field 'SubrptCompany_Payback' referred to in your expression".

View 8 Replies View Related

Reports :: Getting Entire Reports To Show On A Tab Control

Apr 24, 2015

I have tab controls, each of which holds a report. If the report is longer than the tab control the report is stuck there. no slide bars, no overflow. I have set scroll bars but they dont seem to take or work. I need to find a way to add verticle scroll bars to the reports within the tab controls so that you can view the entire report. I have included a screen print of what I mean.

View 1 Replies View Related

Currency

Jun 13, 2006

I have set up a number field to enter in the amount of money we have spent on a particular project, and when I enter, say £645.18, once I press TAB to move to the next field, it reverts to £645....

I have the decimal places thing set at 2, and the format on currency......

View 3 Replies View Related

Currency For The Games

Aug 21, 2006

Hi ,dear friend, which games have you ever played? Here are some good news about games for you, You can focus on this website. and this website can give you a hand in time, when you are in trouble. I think if you want to play the game well, you must have good weapons, right ? so if you want to buy the gold, it is one way you can buy the gold to buy the weapons. we deliever gold vvvvvery fast and provide excellent service
the website is [url=http://www.gneedg.com]
you can come to have a try!!!!!!
and wish can make friends with you in games or out of games.

network games:
US WOW , Maple Story
EURO WOW, Matrix Online
FFXI , EVE Online
DAoC ; Rose online
Guild Wars ; Rune scape 2
EQ2 Ragnarok Online
Dungeons and Dragons Silk Road online
and so on or Power Leveling.

you also can contact them via:
AIM:gilssales
ICQ:108239029
Yahoo: sellgilstoyou 5051360 8379263 13107942609
Msn:gils_sales@hotmail.com
http://www.gneedg.com

View 1 Replies View Related

Rounding Currency

Jan 19, 2005

Hoping someone can help. I have looked for an answer and can't quite grasp what I need to do. I am using Access 2000.

Basically, I have a quote form that adds together all job related services and totals them using a currency field. Sales would like to have the option of quoting the job two decimal places or going out to three. So, I need to round to the two different cost options. I can't figure out how to do this. So, my question is:

1) Am I using the correct data type?
2) If currency is most appropriate, how do I show results such as:
$12.327 and $12.33.

If I only change decimal property (therefore, the display) for the fields, the form shows: 12.33 and 12.330. Have tried using the Round function different data types and not having any luck.

Hope this makes some sense. Thanks!

View 1 Replies View Related

Currency Format

Mar 24, 2005

This is probably the easiest question to answer if you know where to look but I don't.

Working in the UK with Access 2000 I need to set the field in a table to show Dollar $ USD however the only values I have are £ GBP and € as defaults.

Now I thought that I could get this to change if I changed my regional settings but then it occurred to me that if I do that and it changes then surely it would mean that who ever used this database in our global organisation would end up with a currency shown in their own local currency. Whilst this may not seem like a problem it is if you don't realise and quote a figure to someone in your local currency.

i.e. at present the UK £ = nearly $2 USD

So if someone in the UK read the figures and it dispalyed £400,000 and quoted this to a person in the USA when in theory the figure was meant to show $400,000 it could cause all sorts of issues.

Can someone tell me the correct way of choosing $ without it affecting anything else.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved