Link to home
Start Free TrialLog in
Avatar of paulvb
paulvb

asked on

Limit characters to numbers

How do I limit a search field so the end user can only enter 7 digits and be in number format only?

Thanks
Paulvb
Avatar of ClassyLinks
ClassyLinks
Flag of Canada image

Using the FP search feature?  <AFAIK> it is not possible.

There is no way to set these parameters within the wizard itself and because this is one of those features which needs to be "published" there is also no way to modify the html externally.

You could easily build a search feature in ASP to do what you require though.  Is this an option?  If you can run ASP on the server, I could walk you through it.
Avatar of paulvb
paulvb

ASKER

What I really need to do is setup an Access database, I am very familiar with Access,
but I have no idea how to even start with ODBC. If I had a simple databse to start with that I could look at and take apart and change. This would be a great help to me.
As far as .asp I know very little about this. What do you suggest I do?

Thanks
Paulvb
Good choice!

As an aside 90% of the questions I answer in here are related to just that.  FP can't do exactly what we want it to.  Usually ASP can.  8-)

Great sites for ASP components/tutorials include:

www.asp101.com
www.activeserverpages.com
www.asphole.com

As for a search script...

http://asp101.com/samples/db_search.asp

Either download or view the ASP code...it is well documented.

You can always post here for more help, or ask ASP specific questions in the ASP topic area.  In here, you get input mostly from me.  In there you get help from dozens!

Does this help?
Paul.....does any of this help, or do you require further information?
Avatar of paulvb

ASKER

I went to these pages, but I think .asp is over my head. I need a sample ODBC to see what is involved. I know Access pretty well.
Thanks
Paulvb
ASKER CERTIFIED SOLUTION
Avatar of ClassyLinks
ClassyLinks
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
How's it going Paul?
Paul, please return and let me know how you are making out.  I cannot provide assistance if I do not know what has already worked for you and what has not.
Paul...I haven't heard from you in almost 2 weeks.  I'll wait until monday and then request assistance from CS to close this question.
3 weeks w/o response  ;-(

Submitting to CS.
This question has gone over the require 21 day period.  The give me the ability to accept an answer due to the absence of the User.

I will award this question to ClassyLinks.  In he last comment to Paul was that it was not over his head, and provided information as to how it can be done.

Thanks all,
ComTech
Community Support