Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to create access clear button in the form using MS ACCESS

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 09-06-2009
Member
 
Join Date: Nov 2008
Posts: 88
How to create access clear button in the form using MS ACCESS
  

I wanted to have the clear button option on my web form and the clear button should have the same function as what we see in the calculator or if you are not getting then here is the little description, clear button should clear content displayed on the output so please suggest if anyone aware about this.

Thanks for your help

Reply With Quote
  #2  
Old 09-06-2009
Member
 
Join Date: Dec 2008
Posts: 161
Re: How to create access clear button in the form using MS ACCESS

Have you designed your form, if yes then Open your form in design view and ensure the Toolbox is shown. Then Click the Command Button icon. Click somewhere on your form and a new button will appear.The command button wizard will appear - click cancel and close the wizard Right click your new button and select Properties, Select the "Other" column and in the Name row give the button a name that means something to you (like "FieldClear").
Reply With Quote
  #3  
Old 09-06-2009
Member
 
Join Date: Jan 2009
Posts: 140
Re: How to create access clear button in the form using MS ACCESS

Here is the following code where you need to apply it to your existing code but for that you need to have the proper understanding about the form requirement you are designing.

Code:
Clear all the controls in the Form
   For Each ctl In Me.Controls
   For Each ctl In Me.Controls
       Select Case ctl.ControlType
       Case acTextBox, acComboBox, acListBox
           ctl.Value = Null
       Case acCheckBox
           ctl.Value = False
    End Select
Next ctl
Reply With Quote
  #4  
Old 09-06-2009
Member
 
Join Date: Oct 2008
Posts: 167
Re: How to create access clear button in the form using MS ACCESS

A form is bound to its RecordSource which may be a table or a query of one or more tables. Where 'box' is the ID attribute of your textbox you want to clear. You should no longer use the global access method to acquire HTML elements. IE, use in document.getElementById('id').value = '';"Another" does not compute in this context.If you only want to use the form for data entry and not for viewing existing data, change the form's DataEntry property from No to Yes.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to create access clear button in the form using MS ACCESS"
Thread Thread Starter Forum Replies Last Post
Access - form with a dropdown menu Logan 2 Windows Software 5 21-01-2010 01:18 PM
How to add browse button to access 2007 form Broot Software Development 3 31-08-2009 09:48 AM
How to create button on visual C++ Form Ground 0 Software Development 3 14-08-2009 10:26 AM
Access vba code form issue Jaiwanti Software Development 3 06-07-2009 12:32 PM
How to connect the web form to Ms Access using ASP.NET? VijayW Software Development 2 16-02-2009 08:04 PM


All times are GMT +5.5. The time now is 02:47 AM.