- Microsoft Access Open Form Openargs Null Statement
- Open Form Art Definition
- Microsoft Access Open Form Openargs Null And Hypothesis
OpenArgs sometimes NULL, Why?
OpenArgs sometimes NULL, Why?
Microsoft Access Open Form Openargs Null Statement
In the new form I initially 'seemed to have' fixed the problem by capturing me.openargs value into a variable in the FormOpen event. Now, that is passing as Null. I've tried structuring the calling code directly using me.Name, tried it by setting a string variable to me.Name's value then passing that, even tried various combinations. Nov 24, 2010 There a couple of less than ideal ways to do that without using acDialog. The easiest is to have the first form open the second form in its Close event. The other is for the original form to loop, waiting for the first form to close: DoCmd.OpenForm 'frmRawBresserImport DELDuplicates', OpenArgs:='qry1PREAPND Find Name Duplicates'. Jul 04, 2003 I generate an OpenArgs string and pass it to a popup form. Msgbox test is fine on the sender form but is NULL on the popup form. I do not know how I am losing the value in between. SENDER FORM: DoCmd.OpenForm 'frmINFO', ARGSTRING MsgBox ARGSTRING tests successfully for the ARGSTRING value. POPUP FORM ('frmINFO'). A null value can be passed to OpenArgs by omitting the value in the OpenForm call, or by double-clicking the form in the Access Objects sidebar. If it's a modal form, you should explicitly check if it's open and close it before opening it if so. This is a common gotcha.
Open Form Art Definition
Microsoft Access Open Form Openargs Null And Hypothesis
I have had some wierd things happen with Access Forms. First the linkcriteria is getting passed correctly(set properly in the openform command) when the form_open function is called in the new form the openargs variable is null, why is that? Also some global variables are getting lost somewhere, i have to close the form and open it again. I am trying to get away from useing globals but this is still disconcerting. The only other things is that I have seen the sql fail and rollback the transaction and yet the changes are still saved. I don't get it. One question, when you use docmd.menuitem to save, does it respect transactions(meaning if an error occurs in a seperate sql statement and I rollbakc the transaction, will it also rollback. Also is there a good tutorial somewhere about creating classes in VBA(with inheritance and polymorphism - or their limitations)? I realize that some of my problems might be my programming techniques, I am asking to learning so don't be shy on the criticism(do it in love though :)). Thanks for answering my silly questions.
Questions:
1) lost Open args
2) lost variables
3) flaky transactional stuff
4) building classes in VBA
5) why is the sky blue
6) why do elephants like peanuts
.....
Thanks
JoeSmoe