A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

data validation in text box



 
 
Thread Tools Display Modes
  #1  
Old May 1st, 2008, 06:47 AM posted to microsoft.public.access.forms
FAISAL
external usenet poster
 
Posts: 25
Default data validation in text box

i want to enter some data in text box,But i should not enter any value in
text box,The data what i enter is should same as what i predifines by using
an another table

any tips on this
Regards
Faisal
Riyadh

  #2  
Old May 1st, 2008, 06:48 AM posted to microsoft.public.access.forms
default105
external usenet poster
 
Posts: 65
Default data validation in text box

Not sure if I follow but here goes. You have data in one table you want the
user to use and stay confined to. If this is the case use a combo box and
set up the not in list event to control the users actions. It is considered
nice to code it to allow the user to add the item to the list if it is not
there if you want them to have that capability. Hope this helps
--
Pete Blackburn - words to live by:
"Don''t ever let somebody tell you. You can''t do something.You got a
dream,You gotta protect it." Edited Quote from the Pursuit Of Happiness








"Faisal" wrote:

i want to enter some data in text box,But i should not enter any value in
text box,The data what i enter is should same as what i predifines by using
an another table

any tips on this
Regards
Faisal
Riyadh

  #3  
Old May 3rd, 2008, 05:15 AM posted to microsoft.public.access.forms
FAISAL
external usenet poster
 
Posts: 25
Default data validation in text box

Deat sir,

my thanks in advance for your reply

Actually i want to know that there there is any way to control text box for
data entry ,like the combo box property limit to list set to true

"default105" wrote:

Not sure if I follow but here goes. You have data in one table you want the
user to use and stay confined to. If this is the case use a combo box and
set up the not in list event to control the users actions. It is considered
nice to code it to allow the user to add the item to the list if it is not
there if you want them to have that capability. Hope this helps
--
Pete Blackburn - words to live by:
"Don''t ever let somebody tell you. You can''t do something.You got a
dream,You gotta protect it." Edited Quote from the Pursuit Of Happiness








"Faisal" wrote:

i want to enter some data in text box,But i should not enter any value in
text box,The data what i enter is should same as what i predifines by using
an another table

any tips on this
Regards
Faisal
Riyadh

  #4  
Old May 3rd, 2008, 06:37 PM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default data validation in text box

In the BeforeUpdate event of your textbox use the DLookup() function to
insure that the value entered is present in the table. If the value isn't
found in the table

Cancel = True
Msgbox "Value not found! Try again!"

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200805/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:43 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.