Hi,
I am creating a database of private equity funds. I want to have a currency field for an input entitled fund size. However, I need to be able to display whether the size of the fund is in dollars or euros. How can customize a number/currency field to allow me to input the correct currency symbol?
Thanks
Hi,
I have tried to add up fields in a table but am struggling to get it to work. Can anyone help please.
In design view of tables, I have four fields (that I will be using in a a form eventually);
RaffleIncome
AlmsIncome
OtherIncome
TotalIncome
I want to get the TotalIncome field to automatically be the total sum of any or all of the other three.
I have tried putting =[RaffleIncome]+[Almsincome]+OtherIncome} in the control box of the TotalIncome field (a guess) in a form I made, and it gives me the total sum of the others three but does not save when I look at it in the table view. (that is, the TotalIncome column remains £0.00)
I am learning as I go along and am okay figuring some stuff out, but this has got me a bit frustrated, and I guess I cannot see the wood for the trees !
Thanks anyone
Adrian
How do I change all the currency fields (many many of them....)from $ to currency without going in and changing every form and fields manually.
View 3 Replies View RelatedI have a Number field with value as
DSum function where the criteria is
Textfield which works well.
=DSum("[MCRef]","Miracle_Cloth_Main","[Cust_ID]='" & [Cust_ID] & "'")
It doesn't show the SUM when the type of
textBox is CURRENCY
Can anyone suggest IF Ineed to change the syntax ?
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 RelatedHi,
I was trying to customize a toolbar by adding the "size to shortest", "size to narrowest", etc., stuff from the format menu. The first item, "size to tallest", I just clicked and dragged from the format menu onto my toolbar, and that worked fine....except that it disappeared from the format menu. Then, I tried to drag "size to tallest" back to the format menu; Now it has disappeared totally from both my toolbar AND my format menu. How do I get it back???:confused:
BTW, I found out if I ctl-drag items from the format menu to my toolbar, they stay on the format menu but also appear on my toolbar. Wish I had known that before ....
Hello Forum members
Am an ardent access user and have a small problem that am Requesting for help.
I have designed an application software using access and I would like to peddle it to a few prospective clients. I want to package it as a trial software to run for thirty days and after that if the clients is not satisfied,I want it to disable but store the data. How is this possible.
All help is appreciated
I have the following code that does seems to work right:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
<tabs>
<tab id="tabMain" label="CRSTHA Manager">
</tab>
</tabs>
</ribbon>
</customUI>
But when I try to add a button with the following code it doesn't work:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
<tabs>
<tab id="tabMain" label="CRSTHA Manager">
<group id="grpHome" label="Home"/> <button id="cmdHome" label="Home" size="large" onAction="onOpenFormEdit" tag="frmMain"/>
</tab>
</tabs>
</ribbon>
</customUI>
Any ideas?
Hi
I was hoping someone could give me some advice on formatting dates in a text box upon a form.
The date forms part of a serial number that consists of a user selected prefix, from a seperate list box and a 4 digit date in the format of year and week, ie "yyww".
I was intending to use the current system date as the source.
Thanks
Henson
Hi
I wonder if anyone could re-orientate me and put me in the correct direction regarding the above subject. Without wittling on too much what I,ve been basically trying to do is to get a query that I've made, derive its criteria from a form that has 3 combo boxes on it allowing a user to select varying options. I have been using a forum thread which described the process in more detail and whilst I,ve followed it to the letter the end result that I get
an annoying message "The expression On Click event that you entered as the event property setting produced the following error: A problem occured while MS Access was communicating with the OLE server or Active X control. It goes onto say that the expression may not result in the name of a macro, the name of a user defined function, or [Event Procedure].There may have been an error evaluating the function, event or macro". The thread took me to www.fontstuff.com/access/acctut08.htm and it is on this site that I have been trying in vain to come up with a matching result. Am I going mad or is there someting on their tutorial that is mis-leading me! I am desperately trying to adminster some 'self help' and to use the forum threads but I am still at a loss as to what to do next. Could some kind person please help...
Carol:confused:
I am having trouble customizing a database template, i have changed the fields that i needed and got rid of one that i did not but for some reason it will not work.
View 4 Replies View RelatedI am trying to create a form for a query so that I can filter on a chosen record and have the data presented in a more reader friendly format: the idea being that I have the common data show once in the form header and the rest show in the detail section (kind of like a form with subform type)
First I tried using the form wizard to create a Tabular layout form which I could have easily customised, but I am unable to use this because I get an error message telling me the wizard cannot create my form due to me choosing too many fields.
In my next attempt, I elected to use the Multiple Item form option, which seems to work OK but presents the following problems:
1) It has not included all of the data fields in my query... though it looks like I can add these manually
2) I am unable to reorganise the text boxes and labels the way I would like, as they all seem to be locked together Is there a setting somewhere that I can change to stop this from happening?
Hi,
I am looking for a way to customize fields to be hidden or not depending on user in forms or reports.
Any idea ?
I wanted to explore the customisation of each query but there must be an easier way to save personal parameters somehow so that the user would go through the forms and hide the non necessary fields once and we would then save somewhere these settings for each user.
Has anybody already experienced such a request ?
I am currently using the code
Code:
<customUI
xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="True">
[Code]...
To remove the file button from access. however the more commands button in the quick access toolbar renders this method pointless unless i can remove the more commands button. How to remove the "customise quick access" button or failing that how to remove the more commands button?
I don't want my user to type in the parameter value for a query in case of miss spelling. Therefore, I'm using a dialog box form with a combo box field. The row source of the combo field is a table with one field for the list. I've added VB code (Event Procedure) to a buttons on the dialog box which says to run a query after click. I've created the query for the info I need displayed and am using the forms combo field as the criteria.
Private Sub cmdOK_Click()
DoCmd.OpenQuery "qryRequestsbyBranch", acViewNormal, acEdit
DoCmd.Close acForm, "frmDepartmentList"
End Sub
The query runs except I'm not getting any data.
I am trying to change the standard input mask violation error message to a personalised one. I have found this code:
Private Sub Form_Error(DataErr As Integer, Response As Integer)
Const INPUTMASK_VIOLATION = 2279
If DataErr = INPUTMASK_VIOLATION Then
MsgBox "There was an input mask violation in the field no!!"
Response = acDataErrContinue
End If
End Sub
However, i would like to change the message for a number of different text boxes. and i don't know how to isolate each one, and give each one a different message?
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......
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
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!
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.
Hi All.
In my calculation in a query:
Cost: Sum([Cost]/12*(DateDiff("m",[StartDate],Now())))
Cost is Currency;
StartDate is Date.
The result look like Numeric format I would like to have Currency format. Is it possible?
Thanks.
Hello All,
I'm only fairly basic when it comes to Access, and I need some help with a query. Im running Access 2003 on XP Pro, and my current database is in a one to many relationship with Staff and Activities. A part of the Activites field involves the expenses of that particular activity. I have a field in my Activities table saying total expenses. The expense formats are in currency (including total). When I go to make a query, I'm using the following critera for the TotalExpenses field. "FoodExpenses"+"OtherExpenses". However, when I go to run the query, it tells me that there is a data type mismatch in the criteron expression. I changed the field formats to text and it will run. Can access 2003 support currency based querys and if so how? It would be really handy to know.
Hi to everyone. I have this form that my let's say clients should fill in. In one drop down list I need the client to be able to choose different currency i.e. euros or pounds or dollars. But I need the symbol to appear in the list and since the field is currency type I can't use the lookup wizard to decide what values should appear in that list.
How is this possible? Should I make an extra field of text type to choose the currency and on another field of number type to place the value I need or is there another way?
Hope I am cleaar enough...
Kyriakos
Me again. :)
Basic outline: I have a form that lets me select items from drop down boxes, and attached to these items are prices. There's 11 items on the form that need to be selected. Quick diagram.
----
[Item 1]
[Total of 1+2]
[Item 2]
[Item 3]
[Item 4] [Total of 3+4+5]
[Item 5]
[Item 6]
[Item 7] [Total of 6+7+8]
[Item 8]
[Item 9]
[Item 10] [Total of 9+10+11]
[Item 11]
[Total of the 4 Total Boxes above]
----
They've all been set to currency, and what I'm trying to do is to have it so that the final total box there at the very bottom cannot exceed a certain value without giving the user a warning and not allowing it to be accepted.
I guess the problem is that I can't get it to work. Here's the code I'm using to do it:
Private Sub TxtTotal_Change()
If Val(TxtTotal) > 85000000 Then
MsgBox "Total over allowed limit. Change selection."
End If
End Sub
I should note that on this form I had to use 'Val' infront of the boxes names, as when I was adding up the totals it was putting the prices side by side and not totalling them. For example if I added 2+2, it would give me 22 in the box instead of 4.
Any suggestions?
Thanks in advance.
Hi all!
I have an unbound text box (txtInstAmt) that needs to be displayed from a table (tblLoan.fldInstAmt). Both the fields in the table as well as the text box have been set to Currency.
However, my code doesn't seem to work.
I get an error msg saying that the value isn't valid for the field when I set the decimal places to 2 in both the table and the form. When the decimal places are set to Auto, I get a Data Type Mismatch.
Can someone please tell me what's wrong with this code?
Code:Private Sub cboLoanSN_AfterUpdate()Dim DAOdb As DatabaseDim DAOrs As DAO.RecordsetSet DAOdb = CurrentDb()Set DAOrs = DAOdb.OpenRecordset("Select * from tblLoan where fldLoanSN='" & Me.cboLoanSN & "'")With DAOrsMe.txtInstAmt = .Fields("fldInstAmt")End WithMe.cboDateRepay.RequeryEnd Sub
Thanks a lot!
Hi everyone,
My query concerns Currency in that i have declared some variables as Currency but when i try to output them they appear only as if they are formatted as numbers i.e. £0.50 as a currency variable when displayed in a MSgbox displays as 0.5 not a big problem you might think but i am trying to output these numbers to a retail printer as part of an Epos application. i can add a £ sign to the beginnning but adding missing zero's to the end is proving a little more tricky. I have cheked that the international settings on the PC are set to English, £, 2 decimal places ETC
Thanx