Jan 03, 2012
Dear Mr. NeoPa:
I am pleased with your prompt response for help with my questions. I am extremely grateful to you for tutorial links. The first link has an error – page not available. The next three links are good and there is a ton of information for me to read and digest, this will take a while. Sometime in future I will write to you with my comments. Thank you very much!!
Amar Sapra
Last Activity: Jan 4 '12, 04:04 AM
Joined: Dec 31 '11
Location:
-
Jan 03, 2012
Dear Mr. Stewart Ross:
You and Mr. NeoPa have raised my curiosity – can you recommend a book on VBA coding and script for a beginner.Leave a comment:
-
Jan 03, 2012
Dear Mr. NeoPa:
I certainly agree with you, fortunately both the first and last names consist of all text values. If there were numeric values then I would substitute ( ? ) with ( 0 ) zero and ( 9 ).
Mr. Stewart Ross mentioned that using VBA code I could get the same results which I don’t doubt. But since I am not familiar with VBA script and coding I settled for your option.
...Leave a comment:
-
Dear Mr. Stewart Ross:
I agree with Mr. NeoPa in storing the first name and last name in two separate fields. Then combine the values of two fields in third field called Full_Name using expression of combing text values. It worked well when I tried it.
Thank you for your response.Leave a comment:
-
Dear Mr. NeoPa:
I agree with you in storing the first name and last name in two separate fields. Then combine the values of two fields in third field called Full_Name using expression of combing text values.
Thank you for your help!!Leave a comment:
-
Input Mask help in Access 2007
When entering data in the table in datasheet mode I would like the first letter of first name to be automatically capitalized and also automatically capitalize the first letter of last name with a blank space between the first name and last name. Need help with the input mask in design mode.
No activity results to display
Leave a comment: