Hello,
I've got a small form with one field called 'Price', this is set as a Currency type in the table design. How would I go about ensuring that the field (in form view) always starts with the '£' symbol...would this be an input mask or would it be something on the form?
Thank you for any advice :-)
This may sound I guess you could say stupid but...... Is there a way to add a less than symbol in a colum and still keep the value a number rather then text?
View 6 Replies View RelatedI need to have a textbox formatted to have 2 decimals. If I take general number and set the decimal to 2 it will display numbers like 89.1. I would need it to be 89.10. I would like not to use the currency format as it puts the $ symbol in the textbox as well. So basically same formatting as currency (because it's a currency I am working with) but without the symbol.
View 1 Replies View RelatedHello,
I have been trying to find the symbol or text to force a new line on a command button in a Access Form and have not had any luck. I have the command button pretty large and want 2 lines in the button. If anyone knows how to do this that would be great. Thank you very much !!!
I need to have the pound sterling symbol ( £ ) in a field, but only have two options 1- Dollars ( $ ) and 2 - Euros .
I have done a search but cant seem to find out.
How can I get pounds or change one of the others.
I am tying to query the Symbol table to see if a recod exists with symbol code.
I am querying the tblSymbol table from Excelk vba and the Access DB is on my machine.
The code I am using is:
Set rs = New ADODB.Recordset
rs.Open "tblSymbol", cn, adOpenKeyset, adLockOptimistic, adCmdTable
Set rs2 = New ADODB.Recordset
sql = "SELECT * FROM [tblSymbol] WHERE [SymbolCode] = """ & someSymbol & """"
rs2.Open sql, cn, adOpenDynamic, adLockOptimistic
[Code] ....
MsgBox Exists always returns -1 but i know the code exists in the table.
I have several reports where the currency was always reported in dollars so for the fields in question I had a format of $#,###.00 which printed the dollar sign in front of the amount.
As the system has now become more sophisticated I need to print out a currency symbol depending upon the client. I have a currency table that links into the client so my query 'behind' the report holds the right symbol but how do I get it ito the report. I Know I can define a second field that will hold the symbol but to me this is a clumsy way of doing it. Is there anyway I can put the symbol in the control source for the data or into the format of the field or some other way?
I previously created 2 tables:
One lists all the stock symbols and company names = SYMBOL
The second table lists the purchase information for each stock = PURCHASE
I then created many queries, etc. using this data. Symbol is the key link between the various tables, queries, etc.
NOW that I understand the lookup wizard in the data type, I would like to change the symbol field in the purchase table to a Lookup field. I, of course, receive a message. I am told to delete the relationship with the other tables. If I remove the relationships and change the data type, can I then replace the relationship with out damaging all the queries and forms?
Hey guys I'm developing a DB to input satisfaction surveys and compute satisfaction levels expressed as a percentage. I am setting up the DB with 1 record=1 satisfaction survey. The record would contain the fields:Survey Quarter and questions 1,2,3, etc. The responses to the questions are in pulldown menu form with Yes, No and N/A. I've already set Yes to be read as 1 and No as 0. Now I want to add across the row (Questions 1-11) so I can complete the math and get a percentage for each survey. So far I have had zero luck accomplishing this. Any suggestions?
View 4 Replies View RelatedThis seems really silly but I cannot get this query to work.
In one table I have the agents name, id,Category, No of held emails and the time it took to put these emails on hold. In the other query I have the same agent details,category, No of reassigned emails and the total time it took to reassign these.
What I want the query to do is add the total time spent holding and email to the total time spent reasssigning by category.
What my query keeps doing, as I thought it would be as simple as adding them together is instead of ie:
130+1 = 131 it gives me 1301?????
The query is joined using Agent id and Category.
Help Please:
I've made a button on my form which adds a booking ID into the listbox, but it doesn't seem to work. This is my code:
Private Sub Command18_Click()
Dim BoI As String
MsgBox "Booking successfully added!", vbInformation, "Booking"
If Month(Me.Date_1) = 1 Then
ListJ.AddItem Me.BoI
ElseIf Month(Me.Date_1) = 2 Then
ListF.AddItem Me.BoI
End If
End Sub
If someone could tell me the problem, I'd appreciate it. Thank you. :)
Another simple question
I have 2 fields income and expenditure
i have a 3rd field disposable income
how do I get disposable income to automatically change when I input income and expenditure in a form
many thanks
ive got a database for tickets for a school play. how can i create a query that adds up prices from multiple records? would the total be displayed in a form?
View 1 Replies View RelatedI Have a field that I need to manipulate the data in.
sample data follows [Field9]:
1 to 1 (cover page)
1 to 3 (no cover page)
etc..
this field identifies number of fax pages sent, eg
“1 to 1 (cover page)” is actually 2 pages, an attachment plus cover page
“1 to 3 (no cover page)” is actually 3 pages, 3 page attachment without cover page
What I want is just the total number of pages in this field.
I have written two expression that dissects the field in two, left hand side gives me a numeric number of attachments and right hand side a numeric value for the existence of a cover page or not.
Expr1: Mid([Field9],6,1)
Expr2: IIf(Right([Field9],15)="(no cover page)","0","1")
Each individual expression seems to do the right thing, but I have been unable to figure out how to add Expr1 and Expr2 to give me total pages.
Any help would be appreciated
J/
Is there a simple way to add 6 month to an unbount field based on a date that is already entered on a form? I have a field called Last PM and a field called Next PM - The [Next PM] value will be [Last PM] + 6 Months ????
Jon
It is my first try at a access blank database. I have been ok so far but ran into this problem. All I want to do is add a sortcut on my desktop to open it to the database to the form I made BUT it opens up but i have to push on the name of the form to open up that form. I know there is a way to do it BUT can not figure it out . I do not need a switch board as the is only one form and that is not in my knowedge base It is like a custom
made directory
Thxs Steve
I have a field where a user has to input numbers. This number at most will have 8 digits. Something like 00000001 or 00001234. I want access to show those zero's before the number but I can't do it. Any suggestions.
Thanks,
Yusuf
This is probably an age old question but after a search I could not find the answer.
I have a table with 3 fields..... last, first, ssn
I have a form with 3 text boxes. I want users to input data into those text boxes and that data inserted into the table. The code I have figured out, the problem is access tells me I cannot add to the table because the controls do not have focus. Well, I can set focus to one control at a time but then that adds three separate entrees. Am I doing this the real hard way? Im sure there is an easier way to add records to a table with multiple fields.
Thanks
I have am building a program that requires a staff person to enter a daily activity report on employee activity. It's initiated by adding a new record
that will allow the selection of an employees name and ID number from a drop box into respective first name, last name and ID fields. The staff person would then go on to complete the daily report by adding information in several other fields.
My form is based on a relational query built from two tables; tblClient and tbldailyreport.
Any help would be appreciated.
Regards
Timber
Hi,
I've a quick question. In Access, I have a form that allows user to add new record into a table. Is there anyway of finding whether the new record has successfully been inserted or added?
So i think it may be wise to have a message to notify us of whether it's inserted successfully or not.
Hope this explain clear
Thank you very much in advance for your help
Hi, is it possible on the database window to add subdirectories? Such as in 'User Queries' under the 'Queries' tab, etc. If not, is it possible to add anything else to that ojbect window? I know you can add groups, but I need a way to split up queries and tables for individual users. Any help would be appreciated. Thanks!
Paul
Can someone give me an easy way to put a hyphen between two numbers, such as with wins and losses of teams? I want it to come out 5-3, not 5 3.
I tried entering a text box with no success.
Hi guys, ive been developing a database for someone. As some coding has been involved, I have added some references etc as I went along.
I'll be soon handing it over to them to use - will they have to add the references for the database to run on their comp? If so, is there more user friendly way of doing it than going into the VB bit etc?
Cheers...
Hi there,
I am trying to add a new column to my table say name2 with data type Text.
as soon as i hit save it gives me error
"Unknown function Date in validation expression or default value on Contcts.LastUpdated. (Error 3388)"
Any clue?
One more thing what is the maximum number of columns permitted in a table?
Thanks
hello,
I have 10 combo boxes on a form looking up at the same table (fileld A). I want the user to be able to enter a new value (that's not in the table and therefore neither it is in the combo box) to the 1st combo Box (let's say) and that same value to be automatically added to the table, so when I use the next (2nd one) combo Box, that same value is already in the table.
How can I do this??
Thank you very much
Hi,
I have an SDK that I normally use with VS.NET. I cannot seem to add the .dll as a Reference in my MS Access 2003 database. Is there something I am doing wrong, or a workaround to get it to work? I have .NET 3.0 installed on the PC.
Thanks,