473,399 Members | 3,888 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

Deactivate few fields in the form while inserting a record

subashini Thiyagarajan
Hi ,

In ASP how to deactivate few fields while inserting a record to the database(access).


i want to insert a record.e.g having 5 fields.it is not reqired to fill all the fields in a form as per my condition.upon first filed selection(drop down) remaining field should show or deactivate how to dooooooooooooooooooo?

As per the dropdown selection we shoud control the text boxes in the form.same time which ever text box in visible those data only we required to take it to database..
Dec 23 '06 #1
7 2152
its so simple u can use the SQL statment UPDATE <table name> set <Field name>=<'value'>, like this u can type the field name and the values...
Dec 29 '06 #2
Dear,
thanks for your reply.

I am aware of update statement my question is not that.update is backend process.what i required is in order to get the input value itself i want to make visible of the fileds in the form.

those fields suppost to me auotmatic of their visiblity as per the list box selection.

e.g i have one list box and 10 text boxes in the form.Generally all text boxes are visible.

as per the drop down selection i want to deactivate few fields those inputs are not necessary to fill.

i don't want to defaultly deavtivate the text boxes.depends on the selection sometimes 1 and 6th.or some time 7th and 8th like that.


u got it.still more explanation needed
Jan 2 '07 #3
karthi84
271 100+
hi,
y can't u do using if condition checking your listbox values.
Jan 2 '07 #4
how to do? ok i am getting the list box value what code u use to deactivate?

Generally

disabled="disabled" is used to deactivate

how i'll pass the value to the input tag.please explain
Jan 4 '07 #5
karthi84
271 100+
refer to ur thread "list box selections should decide the textbox display" there i have posted the reply which will apply for this also. try it and reply.

regards.....
Jan 4 '07 #6
hi everybody i'm a new guy.....
Jan 9 '07 #7
karthi84
271 100+
hi everybody i'm a new guy.....
welcome canarias,
to this new world . vbmenu_register("postmenu_2299164", true);
Jan 10 '07 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: baskar | last post by:
Hi, I have a table with 90 fields. When I try to use the recordset with addnew and set all the 90 fields and then update the record set it fails the following error seen in the log, SQL0117N...
5
by: Maxine G | last post by:
I have two forms, a menu and a data entry form. The entry form is bound to a query against linked SQL server tables. In the deactivate event, I have some code which asks the user if they want to...
6
by: allyn44 | last post by:
HI--what I am trying to do is 2 things: 1. Open a form in either data entry mode or edit mode depending on what task the user is performing 2. Cancel events tied to fields on the form if I am in...
2
by: John | last post by:
I have two tables in a 1:M relationship- the parent has 5 fields in the primary key and the child 6 (these are actually pretty far downstream in a complicated ER model, but the problem is between...
4
by: msilva10 | last post by:
In my application I have a table called Tenant and I have another table called Leases. As I add a new Lease to a Tenant I have a Yes/No Field that defaults to yes when I add a new Lease. But I need...
3
by: sherry3718 | last post by:
hi every body, Im Sherry, 25 years old from east. i'm beginner to microsoft access,i've designed a form in access that shows and get's the information about people. i have designed a query and...
3
by: Kalaine | last post by:
MSAccess 2003: Users tab through the data entry fields on a form, and accidently tab to the next record thereby erroneously inserting a record. What can I code in the Form_BeforeInsert to prevent...
8
by: Wingot | last post by:
Hey, I have a program I am trying to write using Visual C#, SQL Server 2005/2008, and Visual Studio 2008, and one part of it includes a Schema called Client. Inside this schema, three tables...
0
by: daverskully | last post by:
I have two tables created and want to link two forms created from these tables so that specific fields are populated once one field is selected, but not all fields being populated, with a new record...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.