Givea command button top priority

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a userform in which a user enters data into various test boxes. It also has a number of command buttons which perform various options and become visible or not, and control the flow of the program. I also have data validation for when a user enters data into text boxes.

Is it possible to have one command button which is visible all the time and takes priority over all others when it is pressed? I am trying to give the user the option of saving to a file everything that has been entered in the textboxes at any time and then either continuing with entering more data or exiting the program.

The problem I have at the moment is that when the "save" button is pressed, textboxes which should contain data (but it hasn't yet been entered) are validated and give an error saying they are empty. I would like to override the data validation when the "save" button is pressed.

Thanks
Chris
.

Relevant Pages

  • Re: Creating Multiple Records in a Table
    ... I am not even sure macros can do this. ... The two things the command button will do are: ... The required textboxes by this table are HC_ID, WEEK, ST, DT ...
    (microsoft.public.access.macros)
  • Re: vb as front end of a fortran dll
    ... How does one link the logic of this so that the command ... If the Textboxes are related then consider putting them in a Control ... values that vb has to give fortran in a manner that fortran expects. ...
    (microsoft.public.vb.general.discussion)
  • Re: vb as front end of a fortran dll
    ... How does one link the logic of this so that the command ... If the Textboxes are related then consider putting them in a Control ... Array and looping through checking them. ... values that vb has to give fortran in a manner that fortran expects. ...
    (microsoft.public.vb.general.discussion)
  • Re: Globally Trap Escape Key
    ... A hidden command button on the form. ... I have a set of menu edit options on the form which will allow me ... to enter edit or save mode for the textboxes. ... code whenever the Escape key is pressed. ...
    (microsoft.public.vb.general.discussion)
  • Re: Enter Range value and get report
    ... i just created a simple form with 2 textboxes and a command button. ... Dim ws As Worksheet, ws2 As Worksheet ... transposed in sheet 2 after which the user can print this sheet. ...
    (microsoft.public.excel.programming)