Update query help>>

[Helen]

Can some one help me please, I have two problems. 1st- I
want to create an update query that prompts you (me) for
first name to be entered in all lower case and converts
the text that is entered into all Upper case. The value
should go to Firstname Field(the query must do the
formatting, without me utilizing the Input Mask). This
query must also ask you for a Lastname to be entered in
all lower case, The value should go to Lastname Field and
must have a format of 1st upper case, the remaining
letters must be lower case (you can do this with Input
Mask).


2nd- I want to create an Update query, which removes all
the spaces from the beginning of Field1 from a table.


3rd
I also am trying to figure out how to remove there are 3,
extra spaces that are in the field called Sentence in a
table. using an update query. and how to remove the same 3
spaces at the end of the field.

Thank You in advance for your assistance
Helen

 

[Gary Miller]

Helen,

1) For this you need to do the conversions with UCase for
all caps and strConv for the ProperCase. Actually StrConv
can do both, but UCase is designed specifically for the
Upper Case. It doesn't matter if you enter it upper or
lower.

UCase([Enter First Name])

StrConv([Enter Last Name], 3)
'3 = vbProperCase

2 & 3) The Trim function strips both leading and trailing
spaces so it should work on both your next questions.

Trim([Sentence])

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Guest]

Hello, I am still confused as to how to enter this, in the
First Name, and Last Name Field in the Update Query.

Thank you for being patient

-----Original Message-----
Helen,

1) For this you need to do the conversions with UCase for
all caps and strConv for the ProperCase. Actually StrConv
can do both, but UCase is designed specifically for the
Upper Case. It doesn't matter if you enter it upper or
lower.

UCase([Enter First Name])

StrConv([Enter Last Name], 3)
'3 = vbProperCase

2 & 3) The Trim function strips both leading and trailing
spaces so it should work on both your next questions.

Trim([Sentence])

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

Can some one help me please, I have two problems. 1st- I
want to create an update query that prompts you (me) for
first name to be entered in all lower case and converts
the text that is entered into all Upper case. The value
should go to Firstname Field(the query must do the
formatting, without me utilizing the Input Mask). This
query must also ask you for a Lastname to be entered in
all lower case, The value should go to Lastname Field and
must have a format of 1st upper case, the remaining
letters must be lower case (you can do this with Input
Mask).


2nd- I want to create an Update query, which removes all
the spaces from the beginning of Field1 from a table.


3rd
I also am trying to figure out how to remove there are 3,
extra spaces that are in the field called Sentence in a
table. using an update query. and how to remove the same 3
spaces at the end of the field.

Thank You in advance for your assistance
Helen

.

 

[Helen]

-----Original Message-----
Hello, I am still confused as to how to enter this, in the
First Name, and Last Name Field in the Update Query.

Thank you for being patient

-----Original Message-----
Helen,

1) For this you need to do the conversions with UCase for
all caps and strConv for the ProperCase. Actually StrConv
can do both, but UCase is designed specifically for the
Upper Case. It doesn't matter if you enter it upper or
lower.

UCase([Enter First Name])

StrConv([Enter Last Name], 3)
'3 = vbProperCase

2 & 3) The Trim function strips both leading and trailing
spaces so it should work on both your next questions.

Trim([Sentence])

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

Can some one help me please, I have two problems. 1st- I
want to create an update query that prompts you (me) for
first name to be entered in all lower case and converts
the text that is entered into all Upper case. The value
should go to Firstname Field(the query must do the
formatting, without me utilizing the Input Mask). This
query must also ask you for a Lastname to be entered in
all lower case, The value should go to Lastname Field and
must have a format of 1st upper case, the remaining
letters must be lower case (you can do this with Input
Mask).


2nd- I want to create an Update query, which removes all
the spaces from the beginning of Field1 from a table.


3rd
I also am trying to figure out how to remove there are 3,
extra spaces that are in the field called Sentence in a
table. using an update query. and how to remove the same 3
spaces at the end of the field.

Thank You in advance for your assistance
Helen

.

.

 

[Gary Miller]

Helen,

Maybe both of us are a bit confused, me with what you have
asked vs. maybe what you really meant??? And you on how to
do what I am saying, especially if I am giving you a
solution that doesn't really fit your model.

You prefaced your posts with 'Update Query'. As I reread the
thread I am thinking that you may not really be updating if
you are asking for user input on every record. Are you
really trying to control what the user is entering, or are
you trying to cleanup faulty records. An UpdateQuery would
be used for the latter and not for the former.

I certainly hope that you are doing your entry through a
form and not directly into a table or a query. If you can
explain a bit more about what/why/how you are trying to
accomplish this, I would be glad to help you tailor this to
what you are doing, or possibly suggest an alternative.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

-----Original Message-----
Hello, I am still confused as to how to enter this, in the
First Name, and Last Name Field in the Update Query.

Thank you for being patient

-----Original Message-----
Helen,

1) For this you need to do the conversions with UCase for
all caps and strConv for the ProperCase. Actually StrConv
can do both, but UCase is designed specifically for the
Upper Case. It doesn't matter if you enter it upper or
lower.

UCase([Enter First Name])

StrConv([Enter Last Name], 3)
'3 = vbProperCase

2 & 3) The Trim function strips both leading and trailing
spaces so it should work on both your next questions.

Trim([Sentence])

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message Can some one help me please, I have two problems. 1st- I
want to create an update query that prompts you (me) for
first name to be entered in all lower case and converts
the text that is entered into all Upper case. The value
should go to Firstname Field(the query must do the
formatting, without me utilizing the Input Mask). This
query must also ask you for a Lastname to be entered in
all lower case, The value should go to Lastname Field and
must have a format of 1st upper case, the remaining
letters must be lower case (you can do this with Input
Mask).


2nd- I want to create an Update query, which removes all
the spaces from the beginning of Field1 from a table.


3rd
I also am trying to figure out how to remove there are 3,
extra spaces that are in the field called Sentence in a
table. using an update query. and how to remove the same 3
spaces at the end of the field.

Thank You in advance for your assistance
Helen




.

.