Search results

  1. C

    Display msgbox if required field is blank

    The "Dim combovalue..." is actually being used in my Else statement. I have additional code that I hid in order to make my question simplier to understand. Thanks for questioning that! :D
  2. C

    Disable system error messages

    Is there a way to disable the automatic error messages that occur when a user: 1. enters a letter in a number field 2. enters a date in the wrong format (should be MM/DD/YY and they enter MM//DD/YY, etc.) 3. clicks on a button that will open a hyperlink (Currently a message pops up to make sure...
  3. C

    Accessing Lotus Notes Database

    Hi all! I'm currently trying to provide my users a connection to a Lotus Notes database after they click on a button. I have searched the forum and there is a lot of information concerning the mail file, but nothing about a separate database. The name of the database I'm trying to connect to...
  4. C

    Display msgbox if required field is blank

    Thanks for your input. I was able to determine the solution. Attached is my code. :D Private Sub SaveCustomerInfo_Button_Click() Dim combovalue As Double If Me.cmbo_CorporateGovernance.ListIndex < 0 Then MsgBox "You must select a value for the Corporate Governance."...
  5. C

    Display msgbox if required field is blank

    On my form, I have a combo box for a required field. Once the user populates the data they click a button which, if the required field is populated, will open another form. If the required field is not populated, I do not want to open the other form but instead want a msgbox to appear. Below...
  6. C

    Code updates combo box but doesn't update linked subform

    Pat and DB7, Thanks for your help so far with this. Unfortunately, neither solution has worked. I have simplified my database to only include 2 Forms, 2 Subforms, and code for the relevent buttons and combo boxes (Pat's code is there now). Do you mind taking a look at this to determine if...
  7. C

    Code updates combo box but doesn't update linked subform

    I have two forms (FormA, FormB) with combo boxes (cboA, cboB) that control the record being shown in the subforms (SubformA, SubformB). I have written the following code and attached it to the "AfterUpdate" function on the combo boxes and it updates the subform perfectly. Private Sub...
  8. C

    Function from FormA sets combo box value on FormB but does not update SubformB

    I have two forms (FormA, FormB) with combo boxes (cboA, cboB) that control the record being shown in the subforms (SubformA, SubformB). I have written code and attached it to the "AfterUpdate" function on the combo boxes and this works perfectly. Here's my problem.... I have a button on FormA...
Back
Top Bottom