In a form I have fields name, first name in which I would if necessary want to put the first letter of the name and/or the first name in uppercase. I created for it a buttonUPLOW How to synchronize this action.
Code:
Function MiseEnMajuscule(Chaine As String) As StringDim
nCar As Integer
'Compteur (position dans la chaine traiter)
Chaine = Trim$(Chaine)
I want to change text in txt boxes. when a new customer is being created we are too lazy to put uppercase in. so i want to change the text so the first letter is uppercase. i have used this on every event and it doesn't change a thing.
I'm designing a database in which the primary key is a combination of the first letter of first name, the first letter of last name and the date of birth.
ok here is what i want.. imagine a search box, just an empty text box that allows the user to type things into it...
there will be a simple table from the database behind it, here is the typical structure of a record
<Country>Poland <Price1>60 <Price2>85 <Price3>95
in this table there will be say a 1000 of these records... my user is going to have to quickly search through these records while on the phone to a customer, and quote one of the relevant prices associated with that country
what i would like is this most convenient system.. as the user types in the letter 'P' just below all the records with countries that begin with 'P' are displayed (with a scroll down arrow if needed)..as well as the 3 relevant prices with that record
if they then type an 'O' into the box (which will now hold 'Po') all the records with countries beginin with 'Po' will be displayed (eg Poland)
if they delete the 'o'. once again the displayed records below the box will return to just the countries begginin with 'p'
all that is needed is for the records to be displayed, thats it.. but the adding and deleting of the letters within the text search box will need to instantly manipulate this list..
i have posted on other forums, and have been told this can be acheived in access, is it hard?
I'm looking for a simple routine, preferably in the On Key Down or or On Key Press event of a form to quickly navigate to a record based on the key pressed.
I have a form with names in a table layout (continuous form).If the user is on the name field, I'd like it to navigate to the first record that contains first letter of the key pressed. So if a user presses "K", the form will go to the first record that starts with a K.Yes, the names in the form are alphabetical, but in a list with over 100 names, this could speed things up just a bit and save a lot of scrolling and looking.I was thinking of using KeyCode and I already have an event to navigate by the arrow keys so I'm considering building on that.
Code: If KeyCode = 40 Then ' Down arrow DoCmd.GoToRecord acForm, Me.Name, acNext ElseIf KeyCode = 38 Then ' Up arrow DoCmd.GoToRecord acForm, Me.Name, acPrevious End If
I am thinking to use a Select Case and add the key codes for all the letters.
I have to add an Input Mask or force the user to enter in a specified format in a text field. The condition is, text should start with "A" or "T". The complete format is A-12345-67890 or T-12345-67890.
I have a Main form with a sub form.The main form is a customer record (form view), and the sub form is all other customers (same fields) datasheet view.I have a navigation bar to filter (using different queries) the results in the sub form
same postcode Same company (different location) everyone except Main form customer
I cannot get a different filter (Query) to show only customers whose name begins with the same letter as the customer in the main form?I have been trying Like but think I am referencing it wrong, as it prompts me to enter a value rather than using the value in the field in the main form.This is what I have in the query (of the subform)
Customer ID: <>[Forms]![NewAllCustomerListF]![CustomerID] Customer Name: Like "[Forms]![NewAllCustomerListF]![CustomerName]" & "*"
in an initials field... i want it so that it could automatically increment the 3 letters to uppercase... how? if it can't be done in a table where can it be made (i.e. in a form, query etc)
How can I report on records which have uppercase values in a record. The data I have in the table is a mixture of Titlecase and UPPERCASE. I need to report on the uppercase values.
I would like all of the text in my database to appear in upper case. I used the > symbol in the format of all controls and in my tables also. However, on my form's lookup combos it doesn't work. When I click the dropdown it shows all selections in upper case, but after I select it turns into lower case again.
I then tried using Ucase and strConv but those don't seem to work with my combos either.
I have searched and these are all the suggestions I could find on how to do this, does anyone know another or possibly what I am doing wrong?
I am as new to MS Access as you can possibly get so please forgive such a simple question. I created a table in Design View. On one of the fields in the table I want to restrict the values that the user is allowed to enter to either a capital Y or a capital N so I created the following validation rule in design view:
=UCase("Y") Or UCase("N")
No matter what I do, the data sheet view allows me to enter a lower case Y or a lower case n. How can I make sure that this field only accepts a capital y or a capital N.
I have a project of migrating our Access data to Oracle. One of the pre-reqs the boss wants is to uppercase all of the column names (Field name) for all of the tables. I want to avoid manually going in all the tables and changing the case of the columns because there is like 300 tables where dealing with. I was wondering if in Access..is there an efficient way of converting my column names to upper case via script? VBA or Macro?
I have a textbox called "name", what i am trying to do is have lowercase on first/second names in the textbox except the last word (surname)this i want in uppercase.
Im linking to sql across ms access and I have all records uppercase.I need to set StrConv with first character uppercase and every other lowercase which is not problem.
I have the following code of my holiday calendar however I would like to convert the month into uppercase. I know about the 'Ucase' function but I am fairly new to this and have tried to place this within the code but with no success:-
With theReport .Controls("labelMONTH").Caption = Format(StartDate, "mmmm")
hi, Im creating a letter. It is based on a query. I have some details that I'd like to display , one on it's own line. I cant print them out now, but they dont all fall on their own separate lines. How should I do that? If I put a carriage control at the end of each detail line, will it know to print each of the fields on its own line? I need advice . I tried doing a subreport -type letter, but it looks weird!
having database full of names and info, how to create a letter which feeds from specific database records with one click, so it can be printed and post it?
Hi All:given a table with, let's say, Job Numbers that start with a letter (such as RES2345) or just plain numbers (such as 253180001 or 9817) how can I set the criteria in the query to just give me jobs that start with a number?I first trimmed the field to eliminate blank characters and then I used the Not Like "A - Z" but it still gives me jobs with letters at the beginning of the name.thanks for all your help in advance. :D
Technical Information (for support personnel) Error Type: Server object, ASP 0177 (0x800401F3) Invalid class string /newslettercreate.asp, line 22So, the letter can not be sent.
What is the ERROR of “Server object, ASP 0177 (0x800401F3) Invalid class string” ?
My OS is winXP pro, email program is Outlook Express. Who could help l me solve this problem? Thanks!