First, Middle And Last Name

Feb 13, 2008

I have a list if names, some with a middle initial and some without, that are all in one field. eg George P Wingrove or Ada Wingrove. Can I run a query that will seperate the name into two or three fields? I have tried the following in a query, but not being very successful. FirstName:Left([Name],InStr(1,[Name]," ")-1), MiddleInitialTrim(Mid([Name],InStr(1,[Name]," ")+1,InStr(InStr (1, [Name], " ")+1,[Name]," ")-InStr(1,[Name]," "))) and LastName:IIf(InStr(InStr([Name]," ")+1,[Names]," ") <>0, Right([name],Len([name])-InStr(InStr([Name]," ")+1,[Name]," ")),Right([Name],Len([Name])-InStr([Name]," ")))
Unfortunately, it puts #Error if there is no middle initial. Any way round this problem?

David

View Replies


ADVERTISEMENT

Tables :: How To Convert Middle Names To Middle Initials

Dec 13, 2012

I have names which are in the following format

smith, john adam
smith jr, john adam
smith, john a
smith, john

How can I make all middle names middle initial IE

smith, john a.
smith jr, john a.
smith, john a.
smith, john

I would imagine I need to use instrrev and insert "*." after the last space. Would that work?

View 2 Replies View Related

SubForm In Middle Of Tab Order

Nov 3, 2005

Is it possible to set the Tab Order to move to a subform before all the controls in the Main form have been passed through, and then come back to the Main form where one left off?

I have a form with a client name and a chargable service, a subform with products and, on the main form again, amount tendered.

Logic dictates that one select all items for which one is paying before showing how much is paid.

Right now, I go through the client info, then chargable service, amount tendered, and then anything purchased on the subform. That's kinda bass ackwards.

I'd somehow like to insert the subform's controls into the Tab Order, after chargable service and before amount tendered.

Anyone know if I can do that, if so, how?

View 7 Replies View Related

MsgBox To Show In The Middle Of The Form

Dec 30, 2006

Hi,

I have a Form that is modal and popup, and which opens without the MS Access in the background. It is like a separate window (piece of program) that runs under Windows XP.

If I move the Form on my screens (I have dual monitors) I would like that the messages that are triggered by various actions to appear on top of the form not - for example - on the other screen .

I can add more info if necessary.

Thanks for help.

View 2 Replies View Related

Remove Numbers In Middle Of Field ?

Jan 5, 2007

Hello,

Is it possible to remove a couple of numbers in the middle of a field by using an update query ?

I have for example: YF000491 and would like to make it YF0491.

Any help would be greatly appreciated.

Thanks

View 6 Replies View Related

Find A City In The Middle Of A Field

Jan 11, 2008

Ok Im having trouble with this, I need to remove cities from an address field but don't know a simple query that does this. Can any body help

heres an example

Address1 City
10/F, HONG KONG LAI CHI KOK EXCHANGE IIHONG KONG

Now I want to be able to pull Hong kong out of the address1 field but without searching in the address field with *HONG KONG* as this would involve checking every city in a table.

Please help!

View 1 Replies View Related

Forms Open In The Middle Of The Form

Dec 21, 2006

I have several forms that open in the middle of the form instead of at the top in the first field. Any ideas to correct this problem?

View 2 Replies View Related

Modules & VBA :: How To Find Middle Of Screen

Nov 19, 2014

How can I find the middle of the screen, or at least the middle of the Access window? I want my login form to be placed in the middle of the screen.

View 9 Replies View Related

Extracting Middle Initial From Text String

Dec 21, 2005

Hello,

Is there an easy way to split a full name into firstname, middle name and lastname? I have a field name with names such as James R Lowes and i would like to split the name in 3 like.
Firstname : James
Middle Initial: R
Lastname: Lowes

I was able to find a module to extract the first name from a string, but don't know much about VB and cannot figure out to do the rest.

Please help!

thanks,

Pablo

View 5 Replies View Related

Extracting Middle Initial From Text String

Dec 21, 2005

Hello,

Is there an easy way to split a full name into firstname, middle name and lastname? I have a field name with names such as James R Lowes and i would like to split the name in 3 like.
Firstname : James
Middle Initial: R
Lastname: Lowes

I was able to find a module to extract the first name from a string, but don't know much about VB and cannot figure out to do the rest.

Please help!

thanks,

Pablo

View 14 Replies View Related

Reports :: Centering Objects In The Middle Of The Page?

Oct 22, 2013

I have a report with 4 sub reports. I want to center them so it looks nice.

IS there a way to easily center objects in the middle of the page?

View 1 Replies View Related

Modules & VBA :: Remove Spaces From Middle Of A Field

Jun 9, 2015

I'm trying to improve the dialer that i place on microsoft access forms. basically there's a command button that dials the number that is in a text box, but we have a new job that's just come in that requires numbers to be copied and pasted into the text box. these numbers have a space between the dialing code and the telephone number and i need to make the dialer check for a space and remove it before dialing.

Here's the code for the dialing buttons:-

Private Sub cmd_Dial_Click()
On Error GoTo Err_cmd_dial_Click
CT.MakeCall "8" & txt_telephone.Value & "#", "", False, "", "", False

[code]...

View 5 Replies View Related

Use Auto Complete Feature When Typing Word In Middle Of Field

Feb 26, 2014

I'm working with a DB to enter orders for picking. I have an item list that I'm linking to when entering orders, and bringing in the data from the item list such as item location etc.

It's setup right now that when I type the first couple of letters into the item field it automatically brings up the matching items and if I click enter it completes the item and brings in the other fields from the item list.

Example: If I type in 'tom' I get back 'tomato', 'tomato sauce' etc. and when I choose the right one and hit enter it fills up the rest of the required info such as item location.

What I would like it to do is have the auto complete also check for middle words.

Example: when I type 'alm' it returns 'almonds', 'almond milk', but don't return 'container almonds' or 'container roasted almonds' etc.

View 1 Replies View Related

Queries :: Replace Middle Four Numbers With A Character To Make Entire Number Unreadable

Aug 2, 2013

I have a field that contains 12 numbers. I need to replace the middle four numbers with a character so that the entire number is not readable. How do I do that?

View 14 Replies View Related

Update Query To Add A "." To Middle Initial

Mar 2, 2006

Dear All:

I have a database with ID_Number, Last_Name, First_Name and Middle_initial. This database has 500 records.

The Middle_initial field is populated with a letter. I wish to add a period "." after each letter in the Middle_initial field only.

Any ideas on how to use an update query to accomplish this?

Thanking in advance.

Dion

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved