Recent content by evictme

  1. E

    Solved Form_Unload Event

    Found a workaround for the issue - Created a blank form that opens as Hidden when the log off button is clicked. The unload event then checks for this form. Works like a charm. Thanks for the help! I am in the middle of cleaning up a lot of the code in this database and all the help I get...
  2. E

    Solved Form_Unload Event

    I have put it in one of my standard modules. Do I need to reference/call it on the Form code somewhere aside from using the boolean name when checking in the unload event? I keep getting the same error
  3. E

    Solved Form_Unload Event

    Yes. I did this. Still seeing the same issue.
  4. E

    Solved Form_Unload Event

    Thank you for this! What do you mean by "In a standard module?" I have placed it at the top of all the subs for the Form but I am still getting the msgbox firing whether the user clicks the log off button or not. Any ideas? Log off button: Private Sub Command195_Click() ExitButtonClick =...
  5. E

    Solved Search Form - If result <1 then go to result

    Thanks for the help folks. Found this solution. This allows for a search form where you enter the term into a unbound text box. The Results form will come up and load the subform with actual resutls. SearchFormResults Onload Event If Me.SearchQ_Customer_subform1.Form.Recordset.RecordCount =...
  6. E

    Solved Search Form - If result <1 then go to result

    Thats exactly what I am looking to do. The Form with the subform/results is only so I can make the results in datasheet view and interactive so they can select the record they are looking for. I want to the dCount portion but im not familiar enough with the syntax to know exactly how to word...
  7. E

    Solved Search Form - If result <1 then go to result

    Hi everyone, hope everyone is well and staying safe! Back for a little Search function syntax assistance. I have a search form that opens another form with results in a subform that use the original search form's input. Most of the time, it will display all possible results (it includes name...
  8. E

    Solved Form_Unload Event

    Thank you all! I've incorporated that boolean code and have actually started working on shifting my project to outside the Access Shell. This has been a fun project .
  9. E

    Solved Form_Unload Event

    I do have a main form and it has a close button that is programmed to quit, saveall. This is the main thing they see once they log in. However, it is within the Access App (Im guessing this is what you mean by Access Shell Window?) they dont have access to anything other than the Main Form...
  10. E

    Solved Form_Unload Event

    I've done that for the switchboard form but not too sure how I would do that for the Access program itself. Thats the reason I went with the cancel=true route. Im working on coding the boolean but might just leave it as is.
  11. E

    Solved Form_Unload Event

    I am not too familiar with boolean variables. Any chance you know where I can look for samples or if you got an example as to where I can start?
  12. E

    Solved Form_Unload Event

    Hello All, Back at it with a little syntax situation. I've been trying to prevent folks from closing the database by simply clicking the "X" in order to avoid any issues with events and VBA coding. I have a form that loads hidden whenever they log in and have place this code (see below) to...
  13. E

    Solved Updating Sub-form with OnClick event of other Sub-Form

    Got it now! I keep forgetting the syntax is different when the field is not a number. The code below works perfectly. [Forms]![Mission Control]![AuditClicksMC].Form.Filter = "User =""" & [Forms]![Mission Control]![User] & """" [Forms]![Mission Control]![AuditClicksMC].Form.FilterOn = True
  14. E

    Solved Updating Sub-form with OnClick event of other Sub-Form

    User name is not a number field
  15. E

    Solved Updating Sub-form with OnClick event of other Sub-Form

    Hey Guys, Back at it with some VBA mischief...Looking for a little help on syntax with an OnClick event that is not firing very well/at all. I have the mainform (Mission Control) and two sub-forms (AuditClicksMC) and (Current-User) I've wanted to filter the (AuditClicksMC) based on the...
Top Bottom