Upper Case Wildcard?

May 26, 2006

Just been searching around, found a few posts of uppercase questions, none that quite fit with mine, anyway,

Basically, the data I am working on produces names as such "JoeBloggs" "FredPerry"

Anyway, Im going to use a query to seperate these out into first name and last name, but, I can't seem to find a way to specify a capital letter as a wild card. So far:

CapPos: InStr(2,[calllogs]![CalledNumber],"A")

Then I am going to use the mid function to seperate the two, depending on the position of the first capital letter.

But I just need to replace "A" with something that will find any capital letter.

Cheers

View Replies

General :: Input Data In Lower Case And Automatically Change First Letter Of Word To Upper Case

Mar 16, 2013

Is there any way of making data that is inputted in lower case to automatically change to the first letter of each word being a capital ...

View 4 Replies View Related

Upper Case

May 2, 2007

Any ideas how to Capitalise data in a table.

View 14 Replies View Related

Forcing Upper Case

Feb 23, 2006

Hi

I have a simple database where I wish to force only Upper Case text even if user inputs Lower Case text, how can I do this?

ViRi

View 5 Replies View Related

Filter Upper Case

Aug 2, 2005

Hi,
Is it possible to filter out entries beginning with a capital letter with a query?
Ive tried Like UCase, but that doesn't work, and there is no upper case wild card.
(I am creating a book index and want to have a look only at the entries that are people's names)

many thanks

View 13 Replies View Related

Upper And Lower Case Changing

Jul 10, 2006

I have a field in the table that contains numbers and a mix of upper and lower case words.

I would like to have this to it check for numbers and then makes the first letter in a word upper case and the remainder lower case.

I know you can do it like this >L<????????? but that dow not work if the word lengths are different. Unless I am missing soemthing.

Example of text in field is this:

100 RCSCC MAJOR PAIN

I would like the RCSCC to remain in UPPERCASE and then move to the next work and change the first letter to UPPER CASE and the remaining letters lower case then repeat this on the next word if there is one in the field.

Thanks for all your help.

View 1 Replies View Related

Upper And Lower Case Mixed In Table

Jul 10, 2006

Is there away to change what is in the table field [surname] to the first letter being upper case and the remaining letters lower case.

Thanks

Sorry I found it. Just in a little rush.. Should have looked harder.

View 1 Replies View Related

Changing Fields In Table To Upper Case

Jun 19, 2007

Hi All, A quick question..

Is there a quick way to change about 5000 primary keys fields from lower case to uppercase?

Thanks Anna :)

View 4 Replies View Related

Change Table Entries To Upper Case?

Sep 13, 2004

Hi All,
I want to change existing entries in a table to upper case format. I know that it is possible with a query (update I suppose) using an expression with the "UPPER" function. But I am not quite sure how to implement it in Access. A little help would be welcome...

View 2 Replies View Related

Type Into A Field And First Character Becomes Upper Case Automatically

Oct 6, 2015

what do I do so that when I type into a field the first character becomes an Upper case automatically.

View 1 Replies View Related

Altering User Data Input From Lower To Upper Case?

May 22, 2015

I have a database containing a mixture of upper and lower case input. I can make upper case appear on the screen by using > in the format box in the property section for each field. This works great but the same old uncorrected stuff remains on the database. How can I get the database to store the corrected upper case data after I have entered it in lower case?

View 11 Replies View Related

Queries :: PROPER Function - Transform Names In Upper Case In Capitalized Word

Dec 16, 2013

I have a small issue where I do have names written in UPPER CASE, I would like to transform them in Capitalized (each word), I understand that I cannot use the same function as in excel (PROPER) but something like StrConv, but as I do have a ‘comma’ in between the names I have something like that

Code:
StrConv(Left(Tbl_Telephony_Temp.Agent, InStr(Tbl_Telephony_Temp.Agent, ",")-1), 3)&", "&StrConv(Mid(Tbl_Telephony_Temp.Agent, InStr(Tbl_Telephony_Temp.Agent, ",") + 1), 3) AS CompleteName

Which as you can see is quite a complex statement, how can I simplify it?

Example of a name: VITOR, FONSECA, preferable output, Vitor, Fonseca

View 14 Replies View Related

Forms :: Filter A Form Based On A Field With Wildcard - Make Search Case Insensitive

Jan 9, 2014

Access 2003

Trying to filter a form based on a field with wildcard. My form has a txtCustFilter control where a customer's name can be entered in part or whole. The Customer's name is in PCCustomerName

This code works but, I'd like to make it case insensitive

Dim strFilter As String
strFilter = "[PCCUSTOMERNAME] LIKE ""*" & Me.txtCustFilter & "*"""
Me.Filter = strFilter
Me.FilterOn = True

View 9 Replies View Related

Change Case To Title Case

Aug 24, 2004

hi

help is needed yet again :-)

I know when creating a text field in the format option
you can use the > or < sign so that when text
is entered it automatically changes it to uppercase or
lowercase - but i need it to be Title Case, any one know
how I can do this....

View 11 Replies View Related

General :: Minimize Navigation Pane And Upper Tabs

Jun 25, 2012

Is there a way to minimize the navigation pane and the upper tabs on start up? I have several big forms that don't seem to fit unless these are minimized.

View 5 Replies View Related

Forms :: Upper Limit On Amount Of Time Allowed?

Sep 28, 2014

How do I put an upper limit on the amount of time allowed in a date/time field?

For example - during a heart procedure a person is exposed to radiation, it will never be more than a total time of 10 minutes. I want to know how much, but I want data integrity so I don't want them to be able to enter more than 10 minutes.

View 5 Replies View Related

Forms :: Close Database If Click On Cross In The Upper Right Top Corner

Aug 26, 2013

How can I close database if I click on the small close cross in the upper right top corner on my logon form?

View 1 Replies View Related

How To Use Wildcard?

May 15, 2006

i've try and no luck... using Like "* *"

i'm tryin to create one that if i search for like let say "brisbane" it would show the results of the complete spelling, but let say if i was to just type "b" or "bris" it would show u a list of "B" towns or matching words of "bris".

any assit would be great

View 1 Replies View Related

Pop-Up WildCard

Jan 31, 2005

I have a field in a table that has the following data in it:

W-01-2005
W-02-2005
W-03-2005
W-04-2005
etc..

I created a query against this table and put a pop-up on this field so they can enter the search criteria needed, or leave blank for all.

I'd like to modify this pop-up code to ignore the W- and -2005. When the pop-up appears and asks them what week they want, I'd like for them just to enter 01 or 02 or 03 etc... not W-01, W-02 etc..

This is the code I have currently in this field.

Code: Like [Enter Two Digit Week] & "*"

Thanks, Leap!

View 6 Replies View Related

Forms :: Calculate Subtotal On Subform And Display On Upper Subform

Jun 20, 2013

im having problems getting a subform to calculate another subform's total and display it as it keeps coming up with the #NAME?.Basically my database is like this

tblCustomer
- tblOrders
- tblItems

and this is displayed on a form. so you can flick through clients, then flick through the orders and its broken down into the items inside each order.i have seen many answers that are only about calculating something on a subform and displaying on a form but this does not work when displaying on a 'parent' subform. the form structure looks like this

frmCustomers
- sFrmCustomerItems
- sFrmCustomerOrders

i have a calculated control textbox in the footer of sFrmCustomerOrders with sums up all the prices using =sum([Price])and in my sFrmCustomerItems, i have a field called Amount (the total amount of all the items) and the Control Source formula i was using was =[Forms]![sFrmCustomerOrders]![sFrmCustomerItems]![txtTotalPrice] but i get a #NAME? error.

View 5 Replies View Related

Wildcard Using Mid Statement

Jul 4, 2005

Can anyone say what the syntax would be for the "incorrect" statement below?

Like *Mid([checking]![COMPANY NAME],1,InStr([checking]![COMPANY NAME]," "))*

As the statement above doesnt work, just returns errors.

Thanks in advance

View 1 Replies View Related

Wildcard Entry

Aug 17, 2005

Hi,

Im having a little problem with the following code in one of my queries

Expr1: IIf(IsNull([Forms]![editLookForm]![Company_Name]),True,[Company Name]=[Forms]![editLookForm]![Company_Name])

What this does is, it take an typed entry from the form (editlookform) and seaches for that entry in the query

i want to add wildcard entrys to this so that the person operating doesnt have to know the complete company name - i just dont know where to put them

Help please

View 2 Replies View Related

Wildcard Queries

Aug 17, 2005

I am running a query that links to a "wildcard" form so that the user can basically run a query filtered on any field they want.

For some reason when I try to use wildcards along with Criteria in my query the query will not return any results. I know the link to the textbox is right because if I take out the wildcard and put an exact word from the table I get a result.

I have tried using many different combinations inclusive of the following:

Like [Forms]![Refurb-WildcardReport]![RefurbWildcard-Name]
Like "[Forms]![Refurb-WildcardReport]![RefurbWildcard-Name]"
"[Forms]![Refurb-WildcardReport]![RefurbWildcard-Name]"
[Forms]![Refurb-WildcardReport]![RefurbWildcard-Name]

Any help would be appreciated, as always thank you ahead of time.

View 14 Replies View Related

Using Wildcard Characters

Oct 6, 2005

I have several queries looking up products from a table. I use a simple form to access the query and in the criteria of the field I use [Forms]![EnterCroft]![ProductName] to filter by name. (EnterCroft is the name of the form).

It works fine but doesn't like the asterisk (*) for all products.

I also want to use wildcard before and after key words in the product names, eg *cup* for anything with CUP in it's name.

How can I do this?

Thank you very much.

View 2 Replies View Related

Problem With WildCard

Dec 13, 2005

ok in access 2003 i have tried everything to get the Like "*oak*" to work but to all fail it replaces "Like" with "ALike" i have tried to find some info on this but have not it seams like something easy i wanted to do.

SELECT MainData.ModelName
FROM MainData
WHERE (((MainData.ModelName) ALike "*oak*"));

some reason it wont find all data with "oak" in it just returns empty

this is like query 101 but for some reason it has stumped me, along with one other problem but i am still researching that one.

View 6 Replies View Related

Wildcard Problems.

Dec 14, 2005

This is making me mad now :mad: i want a query to search for what a user inputs into the query. but for example if i seach in a field wheres there is one or more words in it. eg. I want to search my table for a address (60 donnington road etc) so in the user input box i type "donnington" but i get no results even though it should find "60 Donnington Road"

code i used. [Please enter address] now where does the wild card go?!?!

hope that makes sense :cool:
thanks

View 3 Replies View Related