MsAccess with .net
-
Hai all, Here i have a problem with Msaccess database.Problem is simple. prob1: when i am deleting a record programmitacally with delete button,the record should be decreased by 1 automatically. But in my database if 5 records are there,if i delete 3rd record,now no of records it is showing is 4 with the previous record number.if i enter a new record it is giving 6 as the record_id,which is wrong. i searched for the properties in access for a perticular field,but nothing helps me.How to solve this problem?? prob2; Also how to remove the history of a textbox values?? Like if i insert more than two records,textbox is giving the previous data for that textbox for the next time.I dont want to show the already entered data. Which property i need to set?? Otherwise give me other solution. Thanks in advance.
kissy
-
Hai all, Here i have a problem with Msaccess database.Problem is simple. prob1: when i am deleting a record programmitacally with delete button,the record should be decreased by 1 automatically. But in my database if 5 records are there,if i delete 3rd record,now no of records it is showing is 4 with the previous record number.if i enter a new record it is giving 6 as the record_id,which is wrong. i searched for the properties in access for a perticular field,but nothing helps me.How to solve this problem?? prob2; Also how to remove the history of a textbox values?? Like if i insert more than two records,textbox is giving the previous data for that textbox for the next time.I dont want to show the already entered data. Which property i need to set?? Otherwise give me other solution. Thanks in advance.
kissy
Kissy16 wrote:
when i am deleting a record programmitacally with delete button,the record should be decreased by 1 automatically. But in my database if 5 records are there,if i delete 3rd record,now no of records it is showing is 4 with the previous record number.if i enter a new record it is giving 6 as the record_id,which is wrong. i searched for the properties in access for a perticular field,but nothing helps me.How to solve this problem??
Prob 1: I think your record_id is AutoNumber, so it would return you 6 only.
Kissy16 wrote:
Also how to remove the history of a textbox values?? Like if i insert more than two records,textbox is giving the previous data for that textbox for the next time.I dont want to show the already entered data. Which property i need to set??
Prob 2: Thats because of your IE settings. Go to Tools --> Internet Options. Select Content Tab Click the AutoComplete button. Uncheck the Form Check box and apply the settings.
Regards, Venkatesh Mookkan. Software Engineer, India My: Website | Yahoo Group | Blog Spot
-
Hai all, Here i have a problem with Msaccess database.Problem is simple. prob1: when i am deleting a record programmitacally with delete button,the record should be decreased by 1 automatically. But in my database if 5 records are there,if i delete 3rd record,now no of records it is showing is 4 with the previous record number.if i enter a new record it is giving 6 as the record_id,which is wrong. i searched for the properties in access for a perticular field,but nothing helps me.How to solve this problem?? prob2; Also how to remove the history of a textbox values?? Like if i insert more than two records,textbox is giving the previous data for that textbox for the next time.I dont want to show the already entered data. Which property i need to set?? Otherwise give me other solution. Thanks in advance.
kissy
Kissy16 wrote:
Also how to remove the history of a textbox values?? Like if i insert more than two records,textbox is giving the previous data for that textbox for the next time.I dont want to show the already entered data. Which property i need to set??
Just set the autocomplete property to off. You can directly code it on the HTML. For example: Or on the ASP.NET, you can set the TextBox property of AutoCompleteType to AutoCompleteType.None in your code. best regards, Eriawan :)
-
Kissy16 wrote:
when i am deleting a record programmitacally with delete button,the record should be decreased by 1 automatically. But in my database if 5 records are there,if i delete 3rd record,now no of records it is showing is 4 with the previous record number.if i enter a new record it is giving 6 as the record_id,which is wrong. i searched for the properties in access for a perticular field,but nothing helps me.How to solve this problem??
Prob 1: I think your record_id is AutoNumber, so it would return you 6 only.
Kissy16 wrote:
Also how to remove the history of a textbox values?? Like if i insert more than two records,textbox is giving the previous data for that textbox for the next time.I dont want to show the already entered data. Which property i need to set??
Prob 2: Thats because of your IE settings. Go to Tools --> Internet Options. Select Content Tab Click the AutoComplete button. Uncheck the Form Check box and apply the settings.
Regards, Venkatesh Mookkan. Software Engineer, India My: Website | Yahoo Group | Blog Spot