I am attempting to manipulate the Format Property of a Textbox. As an example, entering in &" lbs" causes your text to end with " lbs".... only I am trying to add a " mark, for example saying something is 6" away...
How do you tell the format property to add this?
I am trying to add a quotation mark on the end of my textbox value using this code : =[BuildResolution] & " " "
It will not work because it thinks I am adding a string. Is there any way to do this? The value displayed in the textbox would look like 0.01" ....
Is it possible to format a textbox such that a negative value doesn't show numerically but in some other form (like a cross or exclamation mark from the Wingdings font, for example?)
I have a couple of textboxes which take their values from a function. The function is designed to return a long integer value which should always be greater than or equal to zero (the function counts the number of outstanding e-mails in a given Outlook folder, hence it should always be zero or higher)
However, as part of my error handling, if the function can't connect to the Outlook folder for whatever reason (for example, if the user does not have the appropriate permissions, or they do not have it mapped etc.), then it returns -1 (so I have some sort of value to identify a fail)
So currently, if such an error occurs, my textbox(es) will show -1 (and I can use conditional formatting to highlight this)
But it would be nice if it showed an "X" or "!" instead, and only showed the numerical value for 0 or positive. Is this possible?
How do I put " " into a form text box?
View 8 Replies View RelatedI have a main form with about six text boxs, these are too small to display the complete data so I created a form with a larger text box. When I dbbl-click in any of the various text boxs on the main form it would open the new popup form displaying the data. I need to be able to access the control source property of the popup form's textbox to change the control source to match the selected text box on the main form. This would allow me to use only one popup form instead of six.
The code I use to access the actual popup form itself is:
Forms![Notes].Form.Caption = " Notes "
Now I need to know what the code is to access the forms textbox control source data.
Hope I have explained this correctly
Hi
I have a field on a Form that displays values in Sterling (The Default on the machine) ie with the pound sign before the numbers.
I need to change the sign before the numbers to Dollar at a click of a button. I'm not interested in actually converting the values from Sterling to Dollar but only to change the sign. So I attached the code below to a Button's On Click Event, but I get an error = Expected.
Format([ControlName] , "$#,##.00")
ViRi
How can I do this? There doesn't seem to be an member of Field called format. Why is this? I want to make the display on a Boolean field, in a Table made from a Make Table Query, to Yes/No, rather than default 0/-1.
View 7 Replies View RelatedI have a split database with a frontend that I semi-regularly update (when one of my users finds a bug I never would have thought for looking for). On my menu screen i have a text box that says: "Last Updated: ##/##/####".
At the moment I manually update the date every time I update the frontend.
Is there a way I can use the DateModifed property of the .mdb file for the frontend as the date in my textbox using VBA?
I have a date/time field. I would like to:
Enter time this way and have it show in the form as:
Enter 5 - show 5 PM
Enter 515 - show 5:15 PM
etc.
I would like it to default to PM and not have to select or enter the PM. How do I enter this format in the table?
I have a form that will only show the data of a table.
All the fields are string.
With a combobox I select the record to show.
What I want is that when I select a record, one of the fields, that in fact is a number but storred as string, is shown formatted like 12.123.123,00.
This textbox is not to be edited and is blocked. It will only show the data.
How can I do this?
Thanks.
Hi,
I have a query with 3 fields - PaymentAmount and PaymentTotal. The third field is a percentage of the two e.g:
PaymentAmount = 10000
PaymentTotal = 12000
PaymentPercentage = 83.333333333333
In my form I would like a text box to display the two combined i.e. £10.000.00 (83.33%).
At the moment it displays 10000 83.3333333333333. I can use £#,##0.00 to format the current half, but how can I then format the percentage to display 83.33%?
Thanks
How do I apply this - can't seem to get it right - just want to control user into putting whatever and two deciimals for pence.
99.99 input mask is halfway there - except I don't want to limit the pounds amount. putting 99999.99 makes entering 12.31 etc a little awkward.
Cheers
I have a form orders with a subform orderdetails where we can order more than one product. When the order is finished you save it with a save button where it will also automathically mark the products ordered as not available.
Now, this code works, the problem is that it only marks one product. how do you make it mark all the products that where ordered (in orderdetails - the subform)? :
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
'set values here!
'loop?
Dim stAvai As String
Dim strSetProd As String
stAvai = "= " & Me.OrderDSubform.Form!ProductIdctrl.Value & " "
strSetProd = "UPDATE Products " & _
"SET Products.[Avail]= True " & _
"WHERE Products.[ProductId]" & stAvai & " ;"
DoEvents
DoCmd.RunSQL strSetProd
Hi folks,
I've searched through the forums and found a little on tab controls, but haven't been able to figure out what I am trying to do.
I have a form with mutliple tabs, each of which contains a subform related to the form on the first tab.
When I am scrolling through the records, I might select the fourth or fifth tab to view that subform, and then, when I scroll to the next record (using the nav bar) I want to stay on that tab... but so far, my form always defaults back to the first tab.
Any suggestions on how I can keep the form open on the tab that has the focus would be a great help. Thanking all readers in advance....
Don
I've got a bit of a problem with # mark when I want to search a number containing "#". The number is as follows: 33.#5hy4-1234When I insert a part of this number to a textbox eg. #5hy to search records containg it, it gives me no results (despite there are such in a database) I know that it is to do with this # mark. I have an sql query: (...) where sachnummer like '*" & variable & "*'
View 3 Replies View RelatedHi,
In SQL in MS Access a '?' '*' '%' are all used as a wildcards.
I need to be able to retrieve all messsages which contain a '?' within the message.
i.e. If a message contains the following characters : why?
I want to retrieve the message as a '?' is part of the message.
When I write the code :
SELECT User.User, Message.Message
FROM Message INNER JOIN [User] ON Message.[Message ID]=User.[Message ID]
WHERE Message Like '*?*';
Access takes the '?' as a wildcard and retrieves all the messages in the database. Is it possible to get round this and use '?' as a specific character.. not a wildcard?
Please help
I have a form with an image embedded in it. I want to be able to click on the image and leave a "dot" or "mark" where i have clicked, allowing me to click in multiple places on the image and leave multiple "dots"
I am assuming i need to crate a new shape each time i click, how is this done?
Hi,
This is probably real easy to do, but ........ I have a field in Access that looks like this:
"12:12:01 PM 12/5/2005, 5:00:01 AM 12/6/2005, 7:00:25 AM 12/6/2005"
From this string, all I want is the last Date entry (mm/dd/yyyy). Thus in this result, it would be 12/6/2005. I know how to use the Right(), Left() and Mid() functions, but I do not want quotation marks included in my result.
Any help would be great ......
I have a statement which is driving me nuts...i'm a beginner with using SQL:
Private Sub Command45_Click()
Me.Graph0.RowSource = "SELECT (Format([Date],""" """mmm""" ''yy')) AS Expr1 FROM Chart_Unsafe_Daily GROUP BY (Format([Date],'mmm'' '''yy")), (Year([Date])*12+Month([Date])-1);
End Sub
The statement is RED for an error, i'm sure it is because the quotation marks within the statement are incorrect.
Can anybody help me out?
I have started a type of CRM database in which all my customer information and product info is stored.
In order to create quotations for each customer, I want to be able to search and select products by product ID, adding quantities if necessary, to be printed as a report.
Any ideas?
Many thanks
Hello I am trying to design a CD label 'report', it's going well except that the title field of our productions has to print with quotation marks around it'. The name of the field is, yes you guessed it, TITLE. I know it must be a simple solution but I'm at a loss to find it or understand it. I'm just a dumbo. Thanks for your time and expertise.
View 2 Replies View RelatedThe current database has the following tables (fields):-
1. Salesman List (Salesman, Supervisor)
2. Customer List (Customer No, Customer Name, Salesman)
3. Product List (Product Name, Product No, Price)
4. Quotation list (Quotation No, Salesman, Customer No, Customer Name, Product Name, Product No, Price) - The data of this table is input by a quotation form.
I'm trying to create a quotation form (by using the quotation list) for others to input. My questions are:-
1. In the quotation form, there's a Supervisor field (which is not in the quotation list table). I want the value in the Supervisor field to show up according to the Salesman selected in the form. So, I'm using the sub-form method (Main form:Quotation form; Subform: Salesman List form). Am I doing correct?
2. While inputing data into the form, one should select Salesman first and then Customer Name (by doing so, only the customers of which the Salesman is responsible are shown in the list for selection - this will need to link up the customer list table). How can I do this?
3. For Product No and Product Name in the form, we assume one customer may ask for quotations of many items. When I just copy and paste the Product No and Product Name several times in order to create several fields, I find that when I input one field (let's say Product No), all other Product No fields will show up the same product no as well. They are not treated separately. How should I fix this problem?
4. For the product price, I want the price in the Product List will show up according to the product I choose in the form. But then, it will allow me to amend as needed.
5. Finally, I want to place the save and submission buttons at the end of the form. Once it's done, the form will be sent to the Supervisor. The supervior will review and approve if correct. The Salesman can look up the database and be able to see the status of the quotation as:new/ waiting for approval/ approved by.... by opening the submitted quotation form (the status will be shown on the top of the form).
I have a Dell keyboard at work and I am trying to find the keycode to the apostrophe/quotation key. I want to disable this when pushed with the ctrl key. I've searched online but could not find anything that shows that specific key. I only see apostrophe keys or quotation keys but not the combination of both which is what I have.
View 4 Replies View RelatedIn the highlighted line of code attached I am comparing two strings one from a snapshot recordset and one from an array.
The logic fails, you can see in the watches window both values equal "DESIGN and the elseif statement should execute but it does not.
The only reason I can see for this is that the values are equal to "DESIGN and not DESIGN. Where this single quotation mark comes from I do not know. It is not visible in the tables and it does not appear when the values are printed into excel.
I am using an access program with a form with detail section. I would like to create auto sr.No when i am creating a new quotation. Using Autonumber didn't work because it start numbering from last quotation.
Snap shot is also attached.
My Main Table in my Database is "Quotation", what do i need to do in order to create a new Main Table called "Quotation Tracker" and "Quotation" would now be under "Quotation Tracker"
View 8 Replies View Related