Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Forcing users to input data

Forcing users to input data

Forcing users to input data


I have a report when users enter a valid ID Number that will list a work list which corresponds to that ID number.  How ever, if the user hit Enter without inputting ID number, then all worklist are returned: or let's say if users enter a non existing ID number, then the result is 0.

But, I would like the following to happen

1.    If users  forget to enter ID Number  & hit enter, then
        they will get a message saying : "Please Enter a valid ID
2.    If users enter a non –existing  Id Number then they will
        get a message " Id Number  Not Valid" "please enter a
        valid ID Number"

Thank you in advance!


Replies continue below

Recommended for you

RE: Forcing users to input data

I don't see what the question has to do with "General database discussion", or even with databases. Looks like you will do better in the appropriate forum for your front-end language. The actual db query will just need to query against the given ID, and use the count of the returned rows to provide an error message.
I notice from your profile that you have asked 15 questions, but have not marked any of the answers as being valuable to you. If you haven't had valuable answers, read FAQ222-2244: How to get the best answers carefully to get ideas about how to ask better questions.
If you have had valuable answers, please read FAQ222-2244: How to get the best answers carefully to see how to mark those answers as valuable. This not only lets the responder know that their time has not been wasted, but also marks the thread for other users.
The FAQ also gives guidance on general forum usage, as I also notice that you haven't yet provided any answers to any one else's questions.

If you want the best response to a question, please check out FAQ222-2244: How to get the best answers first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller  

RE: Forcing users to input data

Make ID number a drop-down field to the user, limited only to the choices in the drop-down.

RE: Forcing users to input data

hdingman, that could be either a very good idea or a very bad idea.  If the OP's app has ten ID numbers, it's a good idea.  If he has a thousand ID numbers, that would kind of suck.

RE: Forcing users to input data


Thanks every one for your input, I was able to resolve the problem.



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close