473,225 Members | 1,398 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,225 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 2142
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...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.