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
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
Nov 13, 2013
How would I go about doing this?
View 6 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
