I have created a table with MS Access 2000 with each field having various masks and lists specific to that field. How do I get UltraDev4 to maintain those rules on the web page side of things? When I get the database connected and creat the form insertion portion of the page, UltraDev creates a simple form with basic text fields. These field, however, have no rules. What I mean a field that says price and is obviously a number you can type text. The date field can be anything you want and the Auto Number field is left blank.
Any help would be appreciated. If this is posted in the wrong area I would appreciate being pointed in the right direction.
Joe Dunn
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Yes, Sherly is right, there is no validation checking in UltraDev but itsself taking from Ms Access, u have to 2 do validations by urself based on ur requirement using Javascript. If u need any help in javascript validations code, let me know, I will try to provide u the required code.
Good Luck...:)
You can use activex controls if you want, but you need to be able to distribute them if you are going to make this an Internet application. This is doable, but can get tricky.
One example is the microsoft date picker activex control. Also microsoft forms 2.0 controls should be filterable
You can then link up the controls to your save code
Otherwise, you can validate on the blur event for the control
Good luck
Greg
Try Yaromat's page. He has an extension called Checkform. Validate the fields on your form using this extension.
http://www.yaromat.com/dw/
Hope this helps
Shiraz
Business Accounts
Answer for Membership
by: sherlyPosted on 2001-05-23 at 18:59:41ID: 6114285
Oh well, there's no so called mask for input fields in UltraDev, what you can do is to use Javascript to validate all of the fields before user submit the form.
For example, check the price field and make sure user enter number only. I hope this will help, if you need help in javascript code, let me know.
Happy programming!
Sherly